Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,853,123 DBAs, developers and SQL Server users

Rss
Headlines today   February 10, 2016

Foreign Key Indexes and Binding

Understand what FK's do and how they use indexes. Then use my script to see if they're using good indexes.  Read more...
By Steve Hood 2016/02/10 | Source: SQLServerCentral.com | Category: foreign keys
Rating: |  Discuss |   Briefcase | 2,080 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2016/02/10 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 49,306 reads

Cloud Adoption Survey

Are you thinking about the cloud yet? Redgate is conducting some research into cloud adoption to better understand both the drivers and the blockers. Whether or not you’ve taken the plunge yet, they would love to hear from you. Participate in the survey and be entered into a draw to win an Amazon gift card worth $100.  Read more...
By Additional Articles 2016/02/10 | Source: Redgate | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,326 reads
Previous headlines

Enabling TDE on Databases in an AlwaysOn Scenario

Enabling Transparent Data Encryption on Databases in Always On Scenario  Read more...
By Sanjiv Doshetty 2016/02/09 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 1,555 reads

The SQL Server 2016 Query Store: Accessing Query Store Information Using DMVs

The SQL Server 2016 Query Store provides several new ways of troubleshooting queries, studying their plans, exploring their context settings, and checking their performance metrics. In using the Query Store to ensure that performance is as good as possible, it isn't long before it becomes important to be familiar with the DMVs that are associated with the query store, and using them in custom queries.  Read more...
By Additional Articles 2016/02/09 | Source: SimpleTalk | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 1,663 reads

Thinking About the Cloud?

Are you thinking about the cloud yet? Redgate is conducting some research into cloud adoption to better understand both the drivers and the blockers. Whether or not you’ve taken the plunge yet, they would love to hear from you. Participate in the survey and be entered into a draw to win an Amazon gift card worth $100.  Read more...
By Additional Articles 2016/02/09 | Source: Redgate | Category: cloud
Rating: (not yet rated)  Rate this |   Briefcase | 2,130 reads

tSQLt and the INSERT EXEC Problem

A proposed solution to the INSERT EXEC problem in tSQLt  Read more...
By Charles Silbergleith 2016/02/08 | Source: SQLServerCentral.com | Category: ms sql
Rating: |  Discuss |   Briefcase | 3,675 reads

Exploration of SQL Server 2016 Always Encrypted – Part 3

In this third article of the exploring SQL Server 2016 Always Encrypted series, Greg Larsen looks at the differences between an Always Encrypted column that uses an encryption type of Deterministic and those that use encryption type of Randomized.  Read more...
By Additional Articles 2016/02/08 | Source: Database Journal | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 1,527 reads

Centrally collect replication conflicts and send an alert

Automatically capture replication conflicts and generate an automated email notification.  Read more...
By Kimberly Killian 2016/02/05 (first published: 2011/10/17) | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 2,651 reads

Microsoft Survey on Backup and Security

Microsoft is looking for some people to talk to for ~20 minutes via phone/Skype and as a thank you for sharing, will provide a $10 Amazon gift card after the call.  Read more...
By Press Release 2016/02/05 | Source: SQLServerCentral.com | Category: backup and restore
Rating: (not yet rated) |  Discuss |   Briefcase | 336 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Loading a Text File from T-SQL

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...  Read more...
By Steve Jones 2016/02/10 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,639 reads

On the addition of useless where clauses

I remember a forum thread from a while back. The question was on how to get rid of the index...  Read more...
By Gail Shaw 2016/02/10 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,481 reads
Question of the Day

Suspect Pages

By Steve Jones 2016/02/10 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 677 reads

If I wanted to know which pages might be corrupted or torn in your database, where would you look inside SQL Server?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Ed Wagner
422 7968 SSCertifiable  
2.
Orlando Colamatteo
320 7685 SSCertifiable  
3.
Hugo Kornelis
309 7122 SSCertifiable  
4.
ALPESH.KARP
289 1153 Ten Centuries  
5.
Rick.Cornell.SME
258 5302 SSCertifiable  
Latest forum posts