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,880,969 DBAs, developers and SQL Server users

Headlines today   March 1, 2017

Stairway to U-SQL Level 13: SQL.MAP

We met SQL.ARRAY in the last step. Now say hello to SQL.MAP, which can store pairs of values.  Read more...
By Mike McQuillan 2017/03/01 | Source: | Category: u-sql
Rating: |  Discuss |   Briefcase | 420 reads

DevOps and “Shift Left” for Databases

The easiest way of explaining how a DevOps approach to database deployment can dramatically speed up the process is to use the term ‘shift-left’. By performing, or at least preparing for, all the processes and tasks that are necessary for deployment as soon as possible in the development cycle, it is possible to move from big, infrequent releases to “little and often”. Stephanie Herr explains how ‘shifting left’ can get deployment pipelines moving.  Read more...
By Additional Articles 2017/03/01 | Source: SimpleTalk | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,667 reads
Previous headlines

In-Place Upgrade or Migration

To upgrade or migrate, that is the question. And I have an answer.  Read more...
By Jim Youmans 2017/02/28 | Source: | Category: sql
Rating: |  Discuss |   Briefcase | 957 reads

One way to get an index seek for a leading %wildcard

In an effort to make leading wildcard searches sargable, Aaron Bertrand plays around with a trigram-type implementation in SQL Server.  Read more...
By Additional Articles 2017/02/28 | Source: | Category: index
Rating:  Rate this |   Briefcase | 2,914 reads

Performance Dashboard Error: Could not find stored procedure

In this article, you will learn how to troubleshoot error when you try to launch the main Dashboard Report.  Read more...
Rating: |  Discuss |   Briefcase | 641 reads

The Last Week for SQL Bits 2017 Discounts

This is the last week for a discounted registration to SQL Bits 2017. The price goes up after Mar 4, so register today.  Read more...
By Press Release 2017/02/27 | Source: SQLBits | Category: sqlbits
Rating: (not yet rated)  Rate this |   Briefcase | 1,570 reads

Encrypting SQL Server: Using an Encryption Hierarchy to Protect Column Data

SQL Server Encryption is an essential part of what is required for protecting data. Column-level encryption can be a very effective way of doing this. In the first in a series of articles on the theme of SQL Server Encryption, Robert Sheldon once more makes it all seem easy.  Read more...
By Additional Articles 2017/02/27 | Source: SimpleTalk | Category: encryption
Rating:  Rate this |   Briefcase | 2,436 reads

Enumerate Windows Group Members

Here a quick script showing how to get all the Active Directory users in a AD group.  Read more...
By Lowell Izaguirre 2017/02/24 (first published: 2016/03/17) | Source: | Category: active directory
Rating: |  Discuss |   Briefcase | 3,247 reads

Using SQL SERVER and Cloud Hosted Databases with OBIEE 11g

If your organisation is committed to using Oracle Business Intelligence Enterprise Edition (OBIEE) 10g/11g /12c as their BI solution, you aren't thereby committed to using Oracle throughout your organisation. You can use a range of data sources including SQL Server, and save a great deal of money by doing so. Sadly, Oracle will only support the use of the venerable SQL Server 2008 R2. Zafar Ali demonstrates how to connect OBIEE to the world beyond Oracle.  Read more...
By Additional Articles 2017/02/24 | Source: SimpleTalk | Category: business intelligence (bi)
Rating:  Rate this |   Briefcase | 2,551 reads

SQL Server Trace Flags - Complete list

Article in markdown format: 
By Konstantin Taranov 2017/02/23 | Source: | Category: trace-flag
Rating: |  Discuss |   Briefcase | 1,536 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Upgrading SQL Server on Linux

I saw this week that there was a new CTP (v1.3) of SQL Server v.Next. I haven’t had a lot...  Read more...
By Steve Jones 2017/03/01 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 880 reads
Question of the Day

Getting Data and Headers

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

I want to copy a set of data from my results with the headers.  For example, I have selected three columns for two rows. I want to copy just these...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
12179 60170 SSC Guru  
Jeff Moden
10637 56869 SSC Guru  
Steve Jones - SSC Editor
6138 43159 SSC-Forever  
4541 19738 SSCoach  
Lynn Pettis
3709 28253 One Orange Chip  
Latest forum posts