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,882,580 DBAs, developers and SQL Server users

Headlines today   March 28, 2017

Performing a Right and Comprehensive Age Calculation

Age calculation based on the right method used in real life.   Read more...
By Sergiy Floka 2017/03/28 | Source: | Category: datetime conversions
Rating: |  Discuss |   Briefcase | 100 reads

Who Changed My Database Schema?

Have you ever wanted to know who made a schema change to your database? If so, that information is tracked in the default trace - Greg Larsen shows how to view it.  Read more...
By Additional Articles 2017/03/28 | Source: Database Journal | Category: schema
Rating: (not yet rated)  Rate this |   Briefcase | 181 reads
Previous headlines

Create reports in Azure SQL Data Warehouse using SSRSS

In this article, we will show how to create reports in ASDW using SSRS  Read more...
By Daniel Calbimonte 2017/03/27 | Source: | Category: azure
Rating: |  Discuss |   Briefcase | 426 reads

Using AT TIME ZONE to fix an old report

Rob Farley contributes to T-SQL Tuesday #87, showing how he would use AT TIME ZONE to simplify reports based on an end user's time zone.  Read more...
By Additional Articles 2017/03/27 | Source: | Category: at time zone
Rating: (not yet rated)  Rate this |   Briefcase | 1,610 reads

The Mysterious Case of the Missing Default Value

Sometimes things are not exactly how we think they are. Read the story of the missing default value and learn why.  Read more...
By Raul Gonzalez @SQLDoubleG 2017/03/24 (first published: 2015/12/01) | Source: | Category: sql server internal storage
Rating: |  Discuss |   Briefcase | 5,315 reads

Encrypting SQL Server: Transparent Data Encryption (TDE)

Transparent Data Encryption (TDE) encrypts the data within the physical files of the database, the 'data at rest'. Without the original encryption certificate and master key, the data cannot be read when the drive is accessed or the physical media is stolen. The data in unencrypted data files can be read by restoring the files to another server. TDE requires planning but can be implemented without changing the database. Robert Sheldon explains how to implement TDE.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,445 reads

Comparing Space Usage for Different Compression Types

This is an investigation, to get an impression on the impact of the used disk space before and after compression considering different index types.  Read more...
By Michael Salzmann 2017/03/23 | Source: | Category: compression
Rating: |  Discuss |   Briefcase | 622 reads

Getting Started with Azure SQL Data Warehouse - Part 2

Arshad Ali discusses the architecture of Azure SQL Data Warehouse and how you can scale up or down, based on your need.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,336 reads

Continuous Delivery and the Development DBA

How to do database development with trunk based development and Continuous Delivery  Read more...
By Pedro Lopez 2017/03/22 | Source: | Category: continuous delivery
Rating: |  Discuss |   Briefcase | 1,009 reads

Follow-up #1 on leading wildcard seeks

Aaron Bertrand shows how to implement simple triggers that maintain trigram-type tables used for better supporting wildcard searches.  Read more...
By Additional Articles 2017/03/22 | Source: | Category: wildcard
Rating: (not yet rated)  Rate this |   Briefcase | 2,681 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

TempDB Multiple Datafiles

Problem Most DBAs are aware that (prior to SQL 2016) one of the most common, post installation changes that needs to...  Read more...
By iainthepitman 2017/03/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 420 reads

Why Before How

I’ve spent a lot of time browsing and participating in online technical forums. In my early years in the industry...  Read more...
By Tim Mitchell 2017/03/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 173 reads
Question of the Day

SSMS Tips - Text Results

By Steve Jones 2017/03/28 | Category: management studio (ssms)
Rating: (not yet rated) |  Discuss |   Briefcase | 39 reads

The default display for results in SSMS 2016 is to provide a grid of the result set. If I want to quickly switch to text results for a query, what...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
17551 74744 SSC Guru  
Jeff Moden
16679 70988 SSC Guru  
Steve Jones - SSC Editor
9946 51788 SSC Guru  
Grant Fritchey
9435 29794 One Orange Chip  
Lynn Pettis
6505 33858 SSC-Dedicated  
Latest forum posts