SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,888,168 DBAs, developers and SQL Server users

Rss
Headlines today   July 20, 2017

Resolve Network Binding Order Warning in failover cluster

In this article, I’m going to show a procedure to resolve an issue that I found while running cluster validation report. you may receive below warning message that includes information about the cause of the warning, which can help you to resolve the issue.  Read more...
By Ganapathi varma Chekuri 2017/07/20 | Source: SQLServerCentral.com | Category: sql cluster
Rating: |  Discuss |   Briefcase | 188 reads

Extending DevOps practices to SQL Server databases – Branching & Merging with VSTS

Join Microsoft Data Platform MVP Steve Jones for the next Database DevOps demo webinar on July 25. He’ll be plugging Redgate tools into Visual Studio Team Services and showing how you can branch and merge your database changes. Sign up now.  Read more...
By 2017/07/20 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 1,423 reads

Find Database Connection Leaks in Your Application

Michael Swart shows how to investigate and fix database connection leaks, an application issue that can lead to connection timeouts.  Read more...
By Additional Articles 2017/07/20 | Source: SQLPerformance.com | Category: connection
Rating: (not yet rated)  Rate this |   Briefcase | 1,672 reads
Previous headlines

Stairway to Advanced T-SQL Level 8: Functions to Generate Date and Time values

When you build applications that store records in SQL Server you will most likely have to store date and time values as part of the data. To manage all the different date related tasks you might need to perform Microsoft has introduced a number of date functions. In this stairway I will be exploring those date and time functions.  Read more...
By Gregory Larsen 2017/07/19 (first published: 2015/10/21) | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,135 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's new In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.  Read more...
By Press Release 2017/07/19 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 37,429 reads

7 Things Every SQL Server DBA Should Know About Linux

In this tip John Grover will help you make the transition to SQL Server on Linux by explaining the things you need to know.  Read more...
By Additional Articles 2017/07/19 | Source: MSSQLTips.com | Category: linux
Rating: (not yet rated)  Rate this |   Briefcase | 1,900 reads

SQL Data Mask: new masking features, constants and composition

Find out what's new, what's next, and what's coming soon to Redgate's free prototype tool, SQL Data Mask. Don't forget to let them know what you think - if you want to help shape what data masking by Redgate should look like, the team are always available to talk!  Read more...
By 2017/07/19 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 1,762 reads

Configuring Backups Using Veritas Netbackup with AGs

A short description of our experience with Veritas Netbackup on MS SQL Server AG Groups. This article does not give a full description of the procedure for configuring netbackup but highlights a few pitfalls which we think some people will find very useful.   Read more...
By Kenneth Igiri 2017/07/18 | Source: SQLServerCentral.com | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 234 reads

Simple SQL: Attribute Splitting

If the design of a relational database is wrong, no amount of clever DML SQL will make it work well. Dr. Codd’s Information Principle is that you have, inside the entity tables, the columns that model the attributes of that entity. The columns contain scalar values. Tables that model relationships can have attributes, but they must have references to entities in the schema. You split those attributes at your peril. Joe Celko explains the basics.  Read more...
By Additional Articles 2017/07/18 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 2,246 reads

Azure DWH part 11: Data Warehouse Migration Utility

There is a new utility to import data from SQL Server on premises or Azure SQL to Azure SQL Data Warehouse (ASDW)  Read more...
Rating: |  Discuss |   Briefcase | 245 reads
 

Ask SQL Server Central

From the SQLServerCentral Blogs

Add new articles to existing Transactional Replication without initializing old articles

Suppose, you have Transactional Replication configured in your production environment. There is a business requirement to add a new article to the...  Read more...
By Dharmendra Keshari 2017/07/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 611 reads

SQL Server Rookie Mistakes

A quick elementary post which is my entry to this months’ T-SQL Tuesday entry hosted by a good friend SQLDoubleG...  Read more...
By Arun Sirpal 2017/07/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,660 reads
Question of the Day

Disaster Recovery Preparations

By Steve Jones 2017/07/20 | Category: disaster recovery (dr)
Rating: (not yet rated) |  Discuss |   Briefcase | 593 reads

When making disaster recovery plans, which concept deals with the amount of data loss you are willing to tolerate?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
68542 213175 SSC Guru  
2.
Jeff Moden
60917 205055 SSC Guru  
3.
Steve Jones - SSC Editor
38788 140337 SSC Guru  
4.
Lynn Pettis
27517 90592 SSC Guru  
5.
Grant Fritchey
25136 94281 SSC Guru  
Latest forum posts