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

Headlines today   October 24, 2014

Memory Corruptions, or Why You Need DBCC CHECKDB

DBCC is a mechanism that can protect you against corruptions causing substantial data loss in your database. If you use it.  Read more...
By Paul Randal 2014/10/24 (first published: 2012/11/08) | Source: | Category: memory corruption
Rating: |  Discuss |   Briefcase | 13,008 reads

The MidnightDBAs release Minion Reindex

The MidnightDBAs have developed a free reindexing solution to help DBAs perform maintenance on their instances. Read about the solution and attend their webinar.  Read more...
By Press Release 2014/10/24 | Source: | Category: press release
Rating: |  Discuss |   Briefcase | 999 reads

The Role of the Technical Architect in Development

What do Technical Architects (TAs) actually do when in a development role? Are they just senior developers 'pushed upstairs' into a management role? Is there a clear distinction between a TA and a product, or project, manager? In an increasingly automated and joined up development environment, the role is important, varied and wide-ranging; as Grzegorz Strzelecki explains.  Read more...
By Additional Articles 2014/10/24 | Source: SimpleTalk | Category: role
Rating: (not yet rated)  Rate this |   Briefcase | 4,525 reads
Previous headlines

Regaining access to SQL server after changing the domain

If you changed your domain and have lost control over the SQL server or have been blocked from logging in , this article talks about it  Read more...
By Yousef Ekhtiari 2014/10/23 | Source: | Category: change domain
Rating: |  Discuss |   Briefcase | 1,907 reads

Building a Better NuGet

NuGet has transformed the ease of getting and installing the latest version of .NET packages, tools and frameworks. It relies on NuGet package authors to get packages right but there is little documentation for them to go by, and there are a few inevitable problems. Ed Charbeneau offers advice from experience.  Read more...
By Additional Articles 2014/10/23 | Source: SimpleTalk | Category: nuget
Rating: (not yet rated)  Rate this |   Briefcase | 4,590 reads

The Mindset of the Enterprise DBA: Delegating Work

A lot of the routine jobs demanded of a DBA can be automated, but a tougher prospect is to automate these jobs in a way that the requestor rather than the DBA can actually set of the job running themselves without compromising security and without risk. Is it true to say that some tasks can be made self-service?   Read more...
By Additional Articles 2014/10/23 | Source: SimpleTalk | Category: delegation
Rating: (not yet rated)  Rate this |   Briefcase | 4,981 reads

Stairway to SQL PowerShell Level 8: SQL Server PowerShell Provider

In this level we continue our journey into the SQL Server space by looking at the SQL Provider that comes with modules for PowerShell. You saw a little bit of the provider for SQL 2008 R2 in Level 2 of this Stairway.  Read more...
By Ben Miller 2014/10/22 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,155 reads

Free eBook: SQL Server Hardware

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.  Read more...
By Press Release 2014/10/22 (first published: 2013/07/24) | Source: Red-Gate | Category: hardware
Rating:  Rate this |   Briefcase | 29,701 reads

Finding a table name from a page ID

Imagine you come to work in the morning and notice that some new rows have been entered into the msdb.dbo.suspect_pages table during the night. Usually the first thing you’re going to do is run DBCC CHECKDB, but if your database is a few TB, that could be several hours before you know where the problem is, and which table may have lost data. You want to find out which table is involved as soon as possible so you can explore your disaster recovery options.  Read more...
By Additional Articles 2014/10/22 | Source: SQLskills | Category: table name
Rating: (not yet rated)  Rate this |   Briefcase | 5,915 reads

Comprehensive Baseline Collector Solution

There are no more excuses for not having baseline data. This article introduces a comprehensive Free Baseline Collector Solution  Read more...
By Robert Virag 2014/10/21 | Source: | Category: baseline
Rating: |  Discuss |   Briefcase | 3,263 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Be Careful! Backups Can Bite You!

Here is a riddle for you… You are requested to move a database from an old server to a new server....  Read more...
By Guy Glantser 2014/10/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,630 reads
Question of the Day

Template parameters

By Steve Jones 2014/10/24 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 673 reads

What's the format for the parameters in a SQL Server Management Studio template file?

Top Members (last 30 days)
# Name Score Level
30 days All-time
RK Mandava
1025 1592 SSCommitted  
Iwas Bornready
525 3545 Hall of Fame  
401 855 SSC Eights!  
D C S Vyas
358 3836 Hall of Fame  
Koen Verbeeck
324 13295 SSChampion  
Latest forum posts