Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,796,799 DBAs, developers and SQL Server users

Rss
Headlines today   April 20, 2015

SSIS Design Pattern - Staging Delimited Flat Files

Learn how to use SSIS to load Delimited Flat Files to staging tables.  Read more...
Rating: |  Discuss |   Briefcase | 4,381 reads

How to Get SQL Server Data Conversion Horribly Wrong

One of the most certain ways of going wrong with any relational database is to get data conversion wrong. Implicit data conversion is a good feature for the expert but can cause a lot of trouble to the unwary. These boil down to seven ways of failing to get data conversion right. Rob Sheldon explains and gives sage advice on how to avoid the problems.  Read more...
By Additional Articles 2015/04/20 | Source: SimpleTalk | Category: data conversion
Rating: (not yet rated)  Rate this |   Briefcase | 2,939 reads
Previous headlines

The Elusive Conditional WHERE Clause

What's this, a conditional WHERE clause that doesn't use dynamic SQL?  Read more...
By John Hick 2015/04/17 (first published: 2013/04/18) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 31,943 reads

Webinar: Wait, what exactly are we shipping? Keeping control in database continuous delivery

Join us on Tuesday 28th April at 4pm BST (11am EDT) for a free webinar panel discussion featuring Brian A. Randell, Grant Fritchey, Steve Jones, and host, Stephanie Herr, on the topic of maintaining visibility and control in database continuous delivery.   Read more...
By Press Release 2015/04/17 | Source: Red-Gate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 3,896 reads

How DBAs Can Adopt the Craftsman Mindset

The job of a DBA requires a fusion of skill and knowledge. To acquire this requires a craftsman mindset. Craftsmen find that the better they get at the work, the more enjoyable the work gets, and the more successful they become. Deliberate practice, Specialization and an appetite for overcoming difficulty are good habits to deliberately adopt to successfully grow those craftsmanlike skills to the point that you become “so good they can’t ignore you”.  Read more...
By Additional Articles 2015/04/17 | Source: SimpleTalk | Category: dba skills
Rating:  Rate this |   Briefcase | 4,144 reads

How to Categorize Uncategorized Data

Using SQL to perform cluster analysis to gain insight into data with unknown groups  Read more...
By Stephan Calderon 2015/04/16 | Source: SQLServerCentral.com | Category: cluster analysis
Rating: |  Discuss |   Briefcase | 3,406 reads

Microsoft® SQL Server® 2014 Service Pack 1 (SP1) released

Service Pack 1 for SQL Server 2014 has been released.  Read more...
By 2015/04/16 | Source: Microsoft SQL Home | Category: sql server 2014
Rating:  Rate this |   Briefcase | 6,650 reads

Selecting Data Using the TOP Clause

There are times when you don’t what to return a complete set of records. When you have this kind of requirement to only select the TOP X number of items Transact SQL (TSQL) has the TOP clause to meet your needs. In this article Greg Larsen explores how to select a subset of data from a record set.  Read more...
By Additional Articles 2015/04/16 | Source: Database Journal | Category: top
Rating:  Rate this |   Briefcase | 5,522 reads

Stairway to SQL Server Security Level 8: Data Encryption

This stairway level will explore data protection through encryption, both when the data is in motion across the network or in memory and at rest in a table. You’ll learn about the encryption key hierarchy and the various kinds of keys you can use to encrypt data, as well as how you can manage the keys or let SQL Server do it for you.  Read more...
By Don Kiely 2015/04/15 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,529 reads

Free eBook: Defensive Database Programming

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.  Read more...
By Press Release 2015/04/15 (first published: 2013/08/28) | Source: Red-Gate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 56,305 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

On Automation

I’m a big fan of automation. I’ve been in IT for 27 years now. One unchanging rule during that time...  Read more...
By Brian Kelley 2015/04/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,680 reads

Converting identifiers into SQL Server table variables in Management Studio

If I had a nickel for every time someone gave me a list of identifiers and asked me to pull...  Read more...
By jsterrett 2015/04/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,867 reads
Question of the Day

NONclustered 2 clustered

By Carlo Romagnano 2015/04/20 | Category: ddl
Rating: (not yet rated) |  Discuss |   Briefcase | 896 reads

I want to optimize the index in a third party database defined as: 

CREATE TABLE dbo.dsa ( i INT NOT NULL );

ALTER TABLE dsa ADD CONSTRAINT pkdsa PRIMARY KEY NONCLUSTERED(i);
I run...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
ArnoKwetters
816 816 SSC Eights!  
2.
Eirikur Eiriksson
459 3442 Hall of Fame  
3.
zzalina0
407 1331 Ten Centuries  
4.
Grant Fritchey
300 15049 SSCoach  
5.
daniel.plocinik
248 447 SSC-Addicted  
Latest forum posts