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

Welcome to

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

Headlines today   February 9, 2016

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: | Category: alwayson
Rating: |  Discuss |   Briefcase | 1,063 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 | 960 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 | 1,157 reads
Previous headlines

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: | Category: ms sql
Rating: |  Discuss |   Briefcase | 3,358 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,235 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: | Category: replication
Rating: |  Discuss |   Briefcase | 2,614 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: | Category: backup and restore
Rating: (not yet rated) |  Discuss |   Briefcase | 316 reads

How to read data from multiple Excel worksheets with SQL Server Integration Services

Read this tip to learn how to import data from multiple Excel worksheets into SQL Server using SSIS.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,220 reads

SQL Azure Performance Benchmarking

An evaluation of the SQL Azure Database Performance Levels recommended by the DTU Calculator service, and a comparison with on premise SQL Server performance.  Read more...
By Paul Brewer 2016/02/04 | Source: | Category: sql azure
Rating: |  Discuss |   Briefcase | 973 reads

Monitoring In-Memory OLTP: What's Important?

In-Memory OLTP has evolved to be a great solution. However, a production system that uses it needs careful monitoring to avoid stress conditions becoming problems. As with many new features of SQL Server, it pays to plan a monitoring strategy to ensure that you are alerted as soon as possible when things go awry.  Read more...
By Additional Articles 2016/02/04 | Source: SimpleTalk
Rating:  Rate this |   Briefcase | 1,695 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Microsoft Azure Stack in Preview!

Microsoft made available the first technical preview of its new Microsoft Azure Stack offering today.  It was announced last week.  Azure...  Read more...
By 2016/02/09 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 554 reads

Excel Power Map vs. Power BI Globe Map visualization

[2016-02-02] PowerMap in Excel is a great tool with good design and comprehensive user experience. I’ve started using it about...  Read more...
By Rayis Imayev 2016/02/09 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 728 reads
Question of the Day

Converting hex values

By Steve Jones 2016/02/09 | Category: cast and convert
Rating: (not yet rated) |  Discuss |   Briefcase | 606 reads

I have a hex value and want to check if the first 3 characters are zeros. Which of this will work for me as the expression I put inside the...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
Ed Wagner
404 7936 SSCertifiable  
Orlando Colamatteo
311 7668 SSCertifiable  
Hugo Kornelis
295 7093 SSCertifiable  
286 1146 Ten Centuries  
258 5302 SSCertifiable  
Latest forum posts