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

Previous headlines

Outer Join – What am I missing (SQL Spackle)

This article shows how to find missing rows in a table using a outer join.   Read more...
By Patrick Cahill 2015/02/27 (first published: 2013/11/12) | Source: | Category: outer joins
Rating: |  Discuss |   Briefcase | 17,896 reads

Cloud Storage Replication Is Not Backup

The options that you need to select when setting up an Azure Storage service account allow you to specify the durability and high-availability of your data, but they don't provide for data recovery to a point-in-time. In fact, it means that some of the bad things that can happen to data are more efficiently replicated to all copies. Backup is quite a separate issue.  Read more...
By Additional Articles 2015/02/27 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 3,183 reads

SQL Saturday #381 - Richmond, VA

SQL Saturday is coming to Richmond on March 21, 2015. Join us for a free day of SQL Server training and networking. There are also paid-for pre-con sessions available from Tim Mitchell and Kevin Kline. Register while space is available.  Read more...
By Press Release 2015/02/27 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 2,140 reads

The Potential of Joins

An article about how we underestimate the power of joins and degrade our query performance by not using proper joins  Read more...
By Ashutosh Pandey 2015/02/26 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,052 reads

Another Look at Tuning Big Data Queries

Most large organizations have implemented one or more big data applications. As more data accumulates internal users and analysts execute more reports and forecasts, which leads to additional queries and analysis, and more reporting. The cycle continues: data growth leads to better analysis, which generates more reporting. Eventually the big data application swells with so much data and querying that performance suffers.   Read more...
By Additional Articles 2015/02/26 | Source: Database Journal | Category: big data
Rating:  Rate this |   Briefcase | 6,140 reads

How do you develop and deploy your database?

Could you spare 3 minutes to do us a quick favor? Redgate’s running this short survey on how our readers develop and deploy databases. It’s just 12 multiple choice questions, so if you’ve got a couple of minutes to spare, we’d love to hear from you.  Read more...
By Press Release 2015/02/26 (first published: 2015/02/05) | Source: Red-Gate | Category: deployment process
Rating: (not yet rated)  Rate this |   Briefcase | 12,495 reads

Stairway To SQL Server Columnstore Indexes Level 1: A First Look At Columnstore Indexes

This level introduces of you to the fundamentals of columnstore indexes, introdused in SQL Server 2012 to manage the indexing of very large tables.  Read more...
By Hugo Kornelis 2015/02/25 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,572 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2015/02/25 (first published: 2013/07/17) | Source: Red-Gate | Category: concurrency
Rating:  Rate this |   Briefcase | 51,910 reads

The DRI Subject of References

A database must be able to maintain and enforce the business rules and relationships in data in order to maintain the data model. It does this through referential constraints. They aren't complex, but are powerful, especially with the means to attach DRI actions to them. Joe Celko explains all, and pines for the ANSI CREATE ASSERTION statement.  Read more...
By Additional Articles 2015/02/25 | Source: SimpleTalk | Category: dri
Rating:  Rate this |   Briefcase | 5,213 reads

Error handling with try-catch-finally in PowerShell for SQL Server

PowerShell V2 introduces the "try-catch-finally" statements, similar to those you already use when you write .NET code. "Try-catch-finally" encloses a block of script that is likely to produce errors under specific circumstances and therefore helps you to keep your code organized. This article is a short usage guide for this error handling construct.   Read more...
By Additional Articles 2015/02/24 | Source: | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 5,374 reads
Ask SQL Server Central

Question of the Day

Maximum number of databases per instance

By Bhushan Kulkarni 2015/02/27 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 934 reads

What is the maximum number of database you can create per instance on SQL Server 2014?

Top Members (last 30 days)
# Name Score Level
30 days All-time
Anshul Parmar
379 379 Old Hand  
376 2387 SSCrazy  
337 2959 SSCrazy  
317 318 Old Hand  
Dilip D. Kulkarni
310 1038 Ten Centuries  
Latest forum posts