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

Headlines today   April 25, 2014

Oiling the gears for the data dictionary

Documenting the database is always a challenge, and there are many techniques you can use to help all the people on your team understand what all your tables are used for. David Poole brings us an easy way to implement a framework for documentation.  Read more...
By David Poole 2014/04/25 (first published: 2011/02/17) | Source: | Category: documentation
Rating: |  Discuss |   Briefcase | 8,158 reads

PowerShell One-Liners: Help, Syntax, Display and Files

Michael Sorens aims to make PowerShell a bit easier to get going with by providing a series of collections of general-purpose one-liners to cover most of what you'll need to get useful scripting done.  Read more...
By Additional Articles 2014/04/25 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 382 reads
Previous headlines

XML Workshop : Utilizing Relational Data In XML Files

Have you received an XML file that must be migrated into a production database? Today’s workshop dives into an ad hoc method of processing relational datasets delivered in an XML file format.  Read more...
By Matthew Pettit 2014/04/24 | Source: | Category: xml
Rating: |  Discuss |   Briefcase | 2,452 reads

Prevent multiple users from running the same SQL Server stored procedure at the same time

There is a stored procedure that must be run by only one user at a time. In this tip, learn how to prevent multiple users from running the stored procedure at the same time.  Read more...
By Additional Articles 2014/04/24 | Source: | Category: locking
Rating:  Rate this |   Briefcase | 3,080 reads

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,962 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,835 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 | 3,859 reads

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,311 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 | 968 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,968 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

From where does SSMS get its database defaults?

We can create a database simply by typing in the command createdatabase DB1 We don’t have to provide any other...  Read more...
By David Postlethwaite 2014/04/25 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 497 reads

Why does my Failover Cluster Instance Keep Failing Back and Forth?

A few months ago I was paged by a client because their SQL Server Failover Cluster Instance (FCI) was experiencing...  Read more...
By @DBA_ANDY 2014/04/25 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 236 reads
Question of the Day

SQL Server port

By Steve Jones 2014/04/25
Rating: (not yet rated) |  Discuss |   Briefcase | 100 reads

How would I change the port that SQL Server listens on?

Top Members (last 30 days)
# Name Score Level
30 days All-time
499 499 SSC-Addicted  
491 500 Mr or Mrs. 500  
442 2664 SSCrazy  
346 402 SSC-Addicted  
342 41572 SSC-Forever  
Latest forum posts