Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,757,324 DBAs, developers and SQL Server users

Rss
Headlines today   October 22, 2014

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: SQLServerCentral.com | Category: stairway series
Rating: (not yet rated) |  Discuss |   Briefcase | 615 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 | 27,322 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 | 2,817 reads
Previous headlines

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: SQLServerCentral.com | Category: baseline
Rating: |  Discuss |   Briefcase | 2,691 reads

Exploring Your SQL Server Databases with T-SQL

Scott Swanberg shares 38 scripts he uses time and time again for discovering more about database objects.  Read more...
By Additional Articles 2014/10/21 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 5,654 reads

Survey on SSDT and Database Projects

Red Gate are developing new tools for users of SSDT and Database Projects in Visual Studio. If you use these technologies, help us make our tools ingeniously simple by completing this 10 minute survey.  Read more...
By Press Release 2014/10/21 | Source: Red-Gate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 10,609 reads

What To Do When the Import and Export Wizard Fails (Part I)

My “Success” story describes the import process when it works without a hitch, while my “Challenge” story highlights a common difficulty encountered when using the Microsoft Import and Export Wizard, and then offers a solution.   Read more...
Rating: |  Discuss |   Briefcase | 2,227 reads

Starting as a SQL Server Business Intelligence Developer

Besides the technical skills required to be a proficient SQL Server business intelligence developer, there are numerous "soft" skills that can contribute to your success.   Read more...
By Additional Articles 2014/10/20 | Source: MSSQLTips.com
Rating: (not yet rated)  Rate this |   Briefcase | 6,308 reads

SQLintersection & DEVintersection Conference Descends On Las Vegas November 10-13

DevIntersection and SQLIntersection conference will bring together experts from Microsoft, SQLSkills, .NET Rocks, and 90 industry gurus.   Read more...
By Press Release 2014/10/20 | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated) |  Discuss |   Briefcase | 173 reads

5 Reasons You Must Start Capturing Baseline Data

It is widely acknowledged within the SQL Server community that baselines represent valuable information that DBAs should capture. Unfortunately, very few companies manage to log and report on this information, and DBAs are then forced to troubleshoot from the hip and scramble to find evidence to prove that the database is not the problem. This article will make a compelling argument for why DBAs must start capturing baseline information, and will create a roadmap for subsequent posts.  Read more...
By Erin Stellato 2014/10/17 (first published: 2012/11/19) | Source: SQLServerCentral.com | Category: baselines
Rating: |  Discuss |   Briefcase | 15,055 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Networking at the PASS Summit

The 2014 PASS Summit is coming up in a few weeks and thousands of SQL Server professionals will be coming...  Read more...
By Steve Jones 2014/10/22 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,391 reads
Question of the Day

DONEPROC

By Kshitij Satpute 2014/10/22 | Category: doneproc
Rating: (not yet rated) |  Discuss |   Briefcase | 202 reads

Which of the following statements is true regarding DONEPROC?


1) The token value is 0xFE.


2) A DONEPROC token may be followed by another DONEPROC token or a DONEINPROC only...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
RK Mandava
970 1533 SSCommitted  
2.
Iwas Bornready
572 3507 Hall of Fame  
3.
DonlSimpson
487 852 SSC Eights!  
4.
D C S Vyas
420 3792 Hall of Fame  
5.
Steven Wittek
399 514 Mr or Mrs. 500  
Latest forum posts