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,868,645 DBAs, developers and SQL Server users

Headlines today   September 29, 2016

Installing R packages in SQL Server R Services

This article shows four ways you can use when installing missing R packages for Microsoft R Services.  Read more...
By Tomaž Kaštrun 2016/09/29 | Source: | Category: r package
Rating: (not yet rated) |  Discuss |   Briefcase | 542 reads

Masking Your Data with SQL Server 2016

There are times when you want some users to see part of a column value but not the whole thing, but you want other users to see the complete column value without any masking. The new SQL Server 2016 Dynamic Data Masking feature will allow you to define these different kinds of masking rules - Greg Larson explains.  Read more...
By Additional Articles 2016/09/29 | Source: Database Journal | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 2,116 reads

New Redgate SQL Compare 12 has landed!

SQL Compare 12 has landed with a brand new user interface, support for SQL Server 2016, and a wealth of fixes and improvements. Check out this blog post from Redgate's Carly Meichen to hear more about what’s new, why the team have built it, and how. Read now.  Read more...
By 2016/09/29 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,084 reads
Previous headlines

Stairway to Exploring Database Metadata Level 3: Exploring Indexes

This level of the Stairway to Exploring Database Metadata focuses on indexes and all the information you can gather about them.  Read more...
By Phil Factor 2016/09/28 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 878 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2016/09/28 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 75,672 reads

Faster DBCC CHECKDB with SQL Server 2016

DBCC CHECKDB is a built-in SQL Server command that allows you to check database integrity and consistency in one simple command, but running it on large databases can be a nightmare. In this article, Ahmad Yaseen explains how you can enhance the command to run faster in SQL Server 2016.  Read more...
By Additional Articles 2016/09/28 | Source: | Category: dbcc checkdb
Rating: (not yet rated)  Rate this |   Briefcase | 1,557 reads

PowerShell Solutions - Several tips for daily tasks

In this tip, we will talk about PowerShell and SQL Server Log and Data Files.  Read more...
By Daniel Calbimonte 2016/09/27 | Source: | Category: datafile
Rating: |  Discuss |   Briefcase | 1,436 reads

PowerShell Desired State Configuration: DSC Resources

Desired State Configuration (DSC) allows you to automate the way that you manage configuration data for software services as well as the environment in which these services run. DSC uses a set of built-in and custom 'resources' as the building blocks for a configuration. If you have specific requirements you may need to create the relevant resource to make the configuration happen. Nicolas Prigent provides a practical guide to DSC resources.  Read more...
By Additional Articles 2016/09/27 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 1,522 reads

Bones of SQL – Grouping By User-Defined Calendar Periods

Although it is common to group by periods such as Week, Month, or Quarter, sometimes alternative periods are needed. This simple technique lets you split a year into periods with any number of days.  Read more...
By Bob Hovious 2016/09/26 | Source: | Category: date manipulation
Rating: |  Discuss |   Briefcase | 1,203 reads

Expanding the uses of DBCC CLONEDATABASE

Erin Stellato goes into detail about some practical use cases for a new DBCC command in SQL Server 2014 SP2 : DBCC CLONEDATABASE.  Read more...
By Additional Articles 2016/09/26 | Source: | Category: dbcc clonedatabase
Rating: (not yet rated)  Rate this |   Briefcase | 2,150 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Database Deployments in Uncontrolled Environments

The ideal is to make a change and see that change deployed to production, in a perfect world we would...  Read more...
By Ed Elliott 2016/09/29 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 485 reads

How to Setup Kerberos Correctly

David was in Copenhagen this weekend delivering his Kerberos talk Taming the Beast: Kerberos for the SQL DBA to SQL...  Read more...
By David Postlethwaite 2016/09/29 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,178 reads
Question of the Day

Round averages

By Steve Jones 2016/09/29 | Category: aggregate function
Rating: (not yet rated) |  Discuss |   Briefcase | 740 reads

I've got this data:

StudentID Test   TestScore
1 Quiz 1 9.50
2 Quiz 1 9.00
3 Quiz 1 8.50
4 Quiz 1 8.00
5 Quiz 1 7.50

Which of these queries gives me an average of...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
410 2117 SSCrazy  
GP Van Eron
331 2224 SSCrazy  
253 367 Old Hand  
193 45327 SSC-Forever  
Jeff Moden
189 41436 SSC-Forever  
Latest forum posts