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

Headlines today   February 28, 2017

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: (not yet rated) |  Discuss |   Briefcase | 104 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: (not yet rated)  Rate this |   Briefcase | 407 reads
Previous headlines

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 | 559 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,106 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 | 1,686 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,182 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,293 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,434 reads

Performance Surprises and Assumptions : GROUP BY vs. DISTINCT

Aaron Bertrand acknowledges that DISTINCT and GROUP BY are usually interchangeable, but shows there are cases where one performs better than the other.  Read more...
By Additional Articles 2017/02/23 | Source: SimpleTalk | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 6,335 reads

Stairway to Exploring Database Metadata Level 7: Extended Properties

In this level, I’ll introduce Extended Properties. As with the previous levels, I want to illustrate as much as possible with practical and immediately useful code.   Read more...
By Phil Factor 2017/02/22 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 650 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Error while loading Excel data into database

Issue: I am trying to load data from Excel 97 – 2003 sheet into a database table. I have written a...  Read more...
By 2017/02/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 267 reads

Better SQL Agent Job Alerts

  They kinda suck. I mean it is nice that we have the option for the SQL Agent to tell us...  Read more...
By WaterOx 2017/02/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 537 reads
Question of the Day

Fun with Time

By Steve Jones 2017/02/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 102 reads

What does this code return:

SELECT DATEDIFF(MINUTE, 0, @t) 
Top Members (last 30 days)
# Name Score Level
30 days All-time
11066 58925 SSC Guru  
Jeff Moden
9744 55812 SSC Guru  
Steve Jones - SSC Editor
5721 42618 SSC-Forever  
4104 19256 SSCoach  
Lynn Pettis
3364 27850 One Orange Chip  
Latest forum posts