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,749,536 DBAs, developers and SQL Server users

Headlines today   September 15, 2014

Another Way to Look at Trees

An alternative to tree traversal, and ultimately more efficient way to look at organizational structures is presented.  Read more...
By Larry Schmidt 2014/09/15 | Source: | Category: sql server
Rating: |  Discuss |   Briefcase | 4,077 reads

Who Broke the Build?

Continuous Integration and automatic builds are fantastic tools for software teams, but only if developers take responsibility for their code. Karsten Kempe explains how to use Team Foundation Server to drive better continuous integration, and walks through a simple open-source tool he built to make nightly builds more transparent, and more valuable.  Read more...
By Additional Articles 2014/09/15 | Source: SimpleTalk | Category: continuous integration
Rating: (not yet rated)  Rate this |   Briefcase | 3,797 reads

Survey: Using Online Accounts

Using online accounts for license management has some advantages, Red Gate is researching how to implement this for our tools in a way that improves the experience for all involved. To say thank you for your participation, there's a chance to win a $25 Amazon certificate.  Read more...
By Additional Articles 2014/09/15 | Source: Red-Gate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 3,589 reads
Previous headlines

Splitting Strings Based on Patterns

Splitting strings based on patterns supported by LIKE and PATINDEX can be an interesting way to address a wide variety of problems.  Read more...
By Dwain Camps 2014/09/12 (first published: 2012/11/29) | Source: | Category: string manipulation
Rating: |  Discuss |   Briefcase | 16,236 reads

DBAs vs Developers: A Sad Tale of Unnecessary Conflict

For many developers, does DBA really stand for Don't Bother Asking? David Poole thinks it is time to end the unnecessary conflict between developer and DBA, and explains how to deal professionally with the inevitable friction between development and operation activities in IT.  Read more...
By Additional Articles 2014/09/12 | Source: SimpleTalk | Category: dba skills
Rating: (not yet rated)  Rate this |   Briefcase | 8,076 reads

Practical Uses for Synonyms in SQL Server

The concept of a synonym was introduced in SQL Server 2005. Synonyms are very simple database objects, but have the potential to save a lot of time and work if implemented with a little bit of thought. This article discusses what exactly a synonym is, and a few examples of how to use them.  Read more...
By Jason Shadonix 2014/09/11 | Source: | Category: synonyms
Rating: |  Discuss |   Briefcase | 6,635 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 2014/09/11 (first published: 2014/03/05) | Source: Red-Gate | Category: ebook
Rating: (not yet rated)  Rate this |   Briefcase | 15,362 reads

SQL Server Hybrid High Availability and Disaster Recovery

This article summarizes the factors to consider and provide an overview of various options for HA and DR in cloud based SQL Server deployments.  Read more...
By Additional Articles 2014/09/11 | Source: | Category: high availability (ha)
Rating: (not yet rated)  Rate this |   Briefcase | 4,452 reads

Stairway to SQLCLR Level 4: Security (EXTERNAL and UNSAFE Assemblies)

In the fourth level of our Stairway to SQLCLR series we take a detailed look at the EXTERNAL_ACCESS and UNSAFE permission sets. We also explore some differences between using TRUSTWORTHY or an Asymmetric Key.  Read more...
By Solomon Rutzky 2014/09/10 | Source: | Category: sqlclr
Rating: |  Discuss |   Briefcase | 1,627 reads

Are you bad enough to join the DBA Team

If you've ever had a terrible day, send in your story and Grant and Steve will pick their favorite to be spiced up DBA-Team-style. The winner will also be given a ticket to SQL Cruise 2015. Find out how to enter.  Read more...
By Press Release 2014/09/10 | Source: | Category: database administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,224 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Statistics in SQL Server

I’ve put together a new Curah! of links to some of the better articles on SQL Server Statistics, specifically those...  Read more...
By Grant Fritchey 2014/09/15 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,854 reads
Question of the Day

Synonyms 2

By Steve Jones 2014/09/15 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,042 reads

A synonym is used to create a short name for an object, replacing the four part naming of an object with a shorter name. I am working in the AdventureWorks2008...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
566 1221 Ten Centuries  
522 522 Mr or Mrs. 500  
Eirikur Eiriksson
450 1948 SSCommitted  
416 2849 SSCrazy  
don1 76084
303 303 Old Hand  
Latest forum posts