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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,880,894 DBAs, developers and SQL Server users

Rss
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: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 700 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: SQLPerformance.com | Category: index
Rating:  Rate this |   Briefcase | 1,853 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 | 602 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,202 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,851 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: SQLServerCentral.com | Category: active directory
Rating: |  Discuss |   Briefcase | 3,211 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,332 reads

SQL Server Trace Flags - Complete list

Article in markdown format: https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Trace%20Flag.md  Read more...
By Konstantin Taranov 2017/02/23 | Source: SQLServerCentral.com | Category: trace-flag
Rating: |  Discuss |   Briefcase | 1,474 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,432 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: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 666 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 | 955 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 | 1,524 reads
Question of the Day

Fun with Time

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

What does this code return:


DECLARE @t TIME = GETDATE();
SELECT DATEDIFF(MINUTE, 0, @t)  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
11362 59255 SSC Guru  
2.
Jeff Moden
10034 56141 SSC Guru  
3.
Steve Jones - SSC Editor
5846 42775 SSC-Forever  
4.
Lowell
4225 19381 SSCoach  
5.
Lynn Pettis
3451 27949 One Orange Chip  
Latest forum posts