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

Headlines today   April 23, 2014

Stairway to Database Source Control Level 1: Setting Up For Database Source Control

The first level of this stairway introduces the basics of source control, some common technologies and technologies, and demonstrates how to start versioning a SQL Server database.  Read more...
By Dave Green 2014/04/23 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,045 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2014/04/23 (first published: 2013/08/07) | Source: Red-Gate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 18,246 reads

Database Normalization Basics

The task of Database Normalization doesn't have to be painful, especially if you follow Old Mother Celko's Normalization Heuristics.  Read more...
By Additional Articles 2014/04/23 | Source: SimpleTalk | Category: normalization
Rating: (not yet rated)  Rate this |   Briefcase | 2,810 reads
Previous headlines

Partitioning Data in a Multi-tenant Data Warehouse Solution

Part two of our series looks at the partitioning strategy to separate customers' data, providing security and performance.  Read more...
By Sean Woehrle 2014/04/22 | Source: | Category: data warehousing
Rating: |  Discuss |   Briefcase | 3,112 reads

Open Call for Editorials

Steve Jones is putting out an open call for guest editorial pieces in the spring of 2014. If you're interested, read on.  Read more...
By Steve Jones 2014/04/22 (first published: 2014/02/27) | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 946 reads

Microsoft Azure SQL Database Security - Firewall Configuration

Marcin Policht reviews security related challenges of Microsoft Azure Software as a Service-based SQL Database, focusing in particular on the SQL Server and database-level firewall access control functionality and methods that can be employed to implement it.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,769 reads

Automating Database Restores

This article describes a way to automatically restore multiple database backups from a directory.  Read more...
By Sujeet Singh 2014/04/21 | Source: | Category: backup
Rating: |  Discuss |   Briefcase | 4,156 reads

Monitoring SQL Server: An Interview with David Bick

Simple-Talk sat down with David Bick, a Red Gate Product Manager, to discuss his work on SQL Monitor and why passively monitoring SQL Server just doesn’t cut it anymore.  Read more...
By Additional Articles 2014/04/21 | Source: SimpleTalk | Category: interview
Rating:  Rate this |   Briefcase | 2,022 reads

SQL Saturday #308 - Houston, TX

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held May 10, 2014. Register while space is available.  Read more...
By Press Release 2014/04/21 | Source: SQL Saturday | Category: events
Rating:  Rate this |   Briefcase | 714 reads

Unexpected View Performance

Views that use implicit conversion to return result sets may use a different query plan than the statement executed in query analyzer.  Read more...
By Thom Bolin 2014/04/18 (first published: 2011/01/11) | Source: | Category: views
Rating: |  Discuss |   Briefcase | 12,719 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

MDX # 39 – Find Default Measure using MDX Query

In Chapter 1 of our book, MDX with SSAS 2012, we’ve devoted a section “Setting a default member of a...  Read more...
By Sherry Li's BI Corner 2014/04/23 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 516 reads

FileTable–Adding a file to a folder

At my Filestream/Filetable talk yesterday at SQL Intersection, someone asked me about programmatically adding a file to a Filetable. Easy...  Read more...
By Steve Jones 2014/04/23 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 722 reads
Question of the Day

Memory-Optimized Table Disk space

By Steve Jones 2014/04/23 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 760 reads

What is the amount of free disk space required for your durable memory-optimized tables?

Top Members (last 30 days)
# Name Score Level
30 days All-time
499 499 SSC-Addicted  
454 463 SSC-Addicted  
442 2664 SSCrazy  
374 402 SSC-Addicted  
336 440 SSC-Addicted  
Latest forum posts