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

Welcome to

A Microsoft SQL Server community of 1,743,623 DBAs, developers and SQL Server users

Headlines today   August 19, 2014

Finding special characters within character strings

Special Characters can lead to many problems. Identifying and reporting on them can save a lot of headache down the road.  Read more...
By Michael Morin 2014/08/19 | Source: | Category: special characters
Rating: |  Discuss |   Briefcase | 6,143 reads

SQL Monitor Custom Metric: Out of memory errors

The number of out of memory errors that have occurred within a rolling five minute window. If you just want to keep an eye out for any memory errors, you can watch the ring buffers for the Out of memory errors alert when it gets registered there.  Read more...
By Press Release 2014/08/19 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 3,769 reads

Newsletter Changes - Reducing Size

A change to the newsletter is coming soon. 
By Site Owners 2014/08/19 | Source: | Category: sqlservercentral
Rating: (not yet rated) |  Discuss |   Briefcase | 647 reads

How to configure SSL encryption in SQL Server

Tibor Nagy explains how to configure Secure Sockets Layer (SSL) encryption on our SQL Servers, with a trusted certificate.  Read more...
By Additional Articles 2014/08/19 | Source: | Category: ssl
Rating: (not yet rated)  Rate this |   Briefcase | 4,549 reads
Previous headlines

Automate Your Central Management Server Registrations

Easily register SQL Servers in your inventory to your CMS for easy multi-server queries.  Read more...
By S. Kusen 2014/08/18 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 1,675 reads

Common database deployment blockers and Continuous Delivery headaches

Deployability is now a first class concern for databases, so why isn’t it as easy as it should be? Matthew Skelton explores seven of the most common challenges which will bring your database deployments to their knees.  Read more...
By Additional Articles 2014/08/18 | Source: SimpleTalk | Category: database deployment
Rating: (not yet rated)  Rate this |   Briefcase | 5,540 reads

SQL Saturday #300 - Kansas City

SQL Saturday is coming to Kansas on September 13, 2014. Our very own Steve Jones will be presenting, alongside other big names like Glenn Berry, Kathi Kellenberger, Sean and Jen McCown, Jason Strate, and many more. Register while space is available.  Read more...
By Press Release 2014/08/18 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 3,627 reads

From Hairdresser to DBA – How to start a career in IT

In writing about his career change from hairdresser to DBA, Greg Lucas shares his experiences and offers advice for those looking to move into IT.  Read more...
By Greg M Lucas 2014/08/15 (first published: 2012/09/11) | Source: | Category: professional development
Rating: |  Discuss |   Briefcase | 15,630 reads

Red Gate Rolls Out the Red Carpet for SQL Server Users

SQL in the City, the unique event for database developers and administrators organized by Red Gate Software, hits the streets of London and Seattle this fall. Now in its fourth year, it features presentations by some of the world’s top SQL Server speakers.  Read more...
By Press Release 2014/08/15 | Source: SQL in the City | Category: sql in the city
Rating: (not yet rated) |  Discuss |   Briefcase | 196 reads

Why the SQL Server FORCESCAN hint exists

It is often generalized that seeks are better than scans in terms of retrieving data from SQL Server. The index hint FORCESCAN was recently introduced so that you could coerce the optimizer to perform a scan instead of a seek. Which might lead you to wonder: Why would I ever want a scan instead of a seek?  Read more...
By Additional Articles 2014/08/15 | Source: | Category: forcescan
Rating: (not yet rated)  Rate this |   Briefcase | 6,117 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Exception handling in SQL Server

                     SQL server gives the exception/error handling mechanism which is similar to c#, Try..Catch block. In SQL Server, we can write...  Read more...
By Vivek Johari 2014/08/19 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,003 reads
Question of the Day


By Tom Thomson 2014/08/19 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,068 reads

What are the values delivered by the final select in the following code:

declare @z int = 0;
while @z < 3
set @z += 1 ;
declare @j int = 0 ;
declare @i int = @z ;
set... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
450 21617 SSC-Insane  
411 688 SSChasing Mays  
335 42747 SSC-Forever  
Eirikur Eiriksson
321 1526 SSCommitted  
Koen Verbeeck
280 13532 SSChampion  
Latest forum posts