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

Headlines today   March 26, 2015

SQL Saturday #372 - Exeter, UK

SQL Saturday, organized by SQL South West, is coming to Exeter, England on April 25. This is sure to be a special event, and as always, offers a free day of training and networking. Register while space is available.  Read more...
By Press Release 2015/03/26 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 2,631 reads

Unit Testing with SQL Server

Learn how to begin unit testing with tSQLt and SQL Server.   Read more...
By Alessandro Alpi 2015/03/26 | Source: | Category: unit testing
Rating: |  Discuss |   Briefcase | 3,148 reads

Self-maintaining, Contiguous Effective Dates in Temporal Tables

'Temporal' tables contain facts that are valid for a period of time. When they are used for financial information they have to be very well constrained to prevent errors getting in and causing incorrect reporting. This makes them more difficult to maintain. Is it possible to have both the stringent constraints and simple CRUD operations? Well, yes. Dwain Camps patiently explains the whole process.  Read more...
By Additional Articles 2015/03/26 | Source: SimpleTalk | Category: temporary tables
Rating: (not yet rated)  Rate this |   Briefcase | 3,573 reads
Previous headlines

Level 6: Analyse & Deploy an AlwaysOn Availability Group

In level 6 of this stairway, we will look deeper into Availability Groups and how to set them up along with a Listener.  Read more...
By Perry Whittle 2015/03/25 | Source: | Category: cluster
Rating: |  Discuss |   Briefcase | 1,814 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.  Read more...
By Press Release 2015/03/25 (first published: 2014/03/05) | Source: Red-Gate | Category: ebook
Rating: (not yet rated)  Rate this |   Briefcase | 36,042 reads

Exploding the Myths of Big Data

As big data application success stories (and failures) have appeared in the news and technical publications, several myths have emerged about big data. This article explores a few of the more significant myths, and how they may negatively affect your own big data implementation.  Read more...
By Additional Articles 2015/03/25 | Source: Database Journal | Category: big data
Rating: (not yet rated)  Rate this |   Briefcase | 6,239 reads

Identifying Start Dates not Aligned with End Dates on a Prior Row

When effective end dates don't align properly with effective start dates for subsequent rows, what are you to do?  Read more...
By Dwain Camps 2015/03/24 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,120 reads

Database source control workshop, Cambridge UK

Redgate is hosting a 1 day public workshop on April 22, 2015. This workshop will teach you how to put a database in source control, deploy a database from source control, and monitor database changes across development, testing, and production environments.  Read more...
By Press Release 2015/03/24 | Source: Red-Gate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 4,639 reads

Integrating Database Lifecycle Management into Microsoft's Application Delivery Process

In order to automate the delivery of an application together with its database, you probably just need the extra database tools that allow you to continue with your current source control system and release management system by integrating the database into it. If you're using the Microsoft stack, then Redgate's tools can help with some of the difficult database parts of the process, as Jason Crease demonstrates.   Read more...
Rating:  Rate this |   Briefcase | 4,589 reads

SQL Cop and SQLServerCentral

Steve Jones runs the SQL Cop tests against the SQLServerCentral database and looks at the results.  Read more...
By Steve Jones 2015/03/23 | Source: | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 3,864 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Azure SQL Database Elastic Scale Part 1 - What is Sharding?

Azure SQL Database Elastic Scale Part 1 - What is Sharding?MARCH 19, 2015 This week, Microsoft introduced an update to Azure SQL...  Read more...
By Paul Hebhardt 2015/03/26 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,500 reads

How to resequence column based on numeric prefix using TSQL

Beginning in version 2005, SQL Server is making manipulation of  partitioned set of rows easier by using Window Functions (ROW_NUMBER(), aggregate functions...  Read more...
By MarlonRibunal 2015/03/26 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,832 reads
Question of the Day

SQL Jobs

By S M 2015/03/26 | Category: sql jobs
Rating: (not yet rated) |  Discuss |   Briefcase | 809 reads

You have setup a SQL Agent Job that has syntax error in it. You also added an output file to get the output of the job after it's executed. Now...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
534 534 Mr or Mrs. 500  
414 971 SSC Eights!  
Jeff Moden
313 36842 SSC-Dedicated  
Anshul Parmar
305 452 SSC-Addicted  
264 2615 SSCrazy  
Latest forum posts