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

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 | 15,498 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 | 7,311 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,309 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,045 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,190 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,571 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,171 reads

Chris Date and the Relational Model

Chris Date is famous for his writings on relational theory. Chris took on the role of communicating and teaching Codd's relational theory, and reluctantly admits to a role in establishing SQL as the dominant relational language. Richard Morris interviews the well-known author and computer scientist.  Read more...
By Additional Articles 2014/09/10 | Source: SimpleTalk | Category: interview
Rating: (not yet rated)  Rate this |   Briefcase | 4,386 reads

Basics of Dimensional Modeling

Introduction of how to design a star schema dimensional model for new BI developers  Read more...
By Derek Wilson 2014/09/09 | Source: | Category: star schema
Rating: |  Discuss |   Briefcase | 5,648 reads

SQL Server Live! Orlando, FL

SQL Server Live! is designed to finely tune the skills of DBAs, developers, Business Intelligence specialists (just to mention a few) with five days of workshops, deep dives and breakout sessions from November 17 - 21 2014.  Read more...
By Press Release 2014/09/09 | Source: | Category: events
Rating: (not yet rated) |  Discuss |   Briefcase | 405 reads
Ask SQL Server Central

Question of the Day

Storing code in Version control

By Steve Jones 2014/09/12 | Category: version control
Rating: (not yet rated) |  Discuss |   Briefcase | 896 reads

What is the format of the database code typically stored in a VCS?

Top Members (last 30 days)
# Name Score Level
30 days All-time
560 1215 Ten Centuries  
Eirikur Eiriksson
438 1933 SSCommitted  
don1 76084
303 303 Old Hand  
298 349 Old Hand  
295 2728 SSCrazy  
Latest forum posts