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

Headlines today   April 15, 2014

Why every SQL Server installation should be a cluster

In this article, I’ll attempt to “convince” you that every SQL Server you put into production should be a SQL Server Failover Cluster Instance (FCI).  Read more...
By Francis Apel 2014/04/15 | Source: | Category: cluster
Rating: |  Discuss |   Briefcase | 6,524 reads

SQL Server Backup Crib Sheet

Robyn Page's crib sheet was a Simple-Talk classic, providing a terse but thorough roadmap of all of the important SQL Server backup-related considerations. It returns, newly revised for SQL Server 2014.  Read more...
By Additional Articles 2014/04/15 | Source: SimpleTalk | Category: backup
Rating:  Rate this |   Briefcase | 2,940 reads

SQL Monitor Custom Metric: Table size (MB)

This metric is useful if you want to know exactly how much physical space a particular table is taking up, including the size of its indexes. If a database is growing quickly within a short time and you suspect a certain table is responsible, you can monitor its actual size, or the rate at which it is increasing.  Read more...
By Press Release 2014/04/15 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 494 reads
Previous headlines

SQL Server 2014 Key Features and Enhancements

SQL Server 2014 comes with a set of enhancements as compared to its processors that brings a lot of business benefits to the applications in OLTP and OLAP environments. This articles highlights a few key enhancements that are built into the product.  Read more...
By Suresh Yaram 2014/04/14 | Source: | Category: in-memory option
Rating: |  Discuss |   Briefcase | 8,516 reads

SQL Server Reporting Services Embedding .NET Code for Report Formatting and Error Handling

I want to embed code into my SQL Server Reporting Servers (SSRS) to allow special formatting for report output. How do I implement and deploy this code and what functionality can use this embedded code?  Read more...
By Additional Articles 2014/04/14 | Source: | Category: error handling
Rating: (not yet rated)  Rate this |   Briefcase | 2,253 reads

Paging Doctor Powershell

Use Powershell to create a single script that checks over your server and every SQL instance on it to help pinpoint problems.  Read more...
By Zach Mattson 2014/04/11 (first published: 2011/04/04) | Source: | Category: sql server
Rating: |  Discuss |   Briefcase | 11,171 reads

The DBA Detective: Disturbing Developments

Originally one of the articles in the first DBA Team series, Grant wonders what Raymond Chandler or Dashiell Hammett would have done if asked to write technical articles for Simple-Talk. He came up with the DBA detective, hard-boiled Joe Dee Beay.  Read more...
By Additional Articles 2014/04/11 | Source: SimpleTalk | Category: database administrator
Rating:  Rate this |   Briefcase | 2,379 reads

SQL Saturday #285 Atlanta

SQL Saturday will come to Atlanta on May 3, 2014. This is a free, full-day event of SQL Server training and networking. SQL Saturday #285 also has 3 (paid for) pre-con sessions available run by Kalen Delaney, Teo Lachev, and Denny Cherry. Make sure to register for SQL Saturday while spaces are available.   Read more...
By Press Release 2014/04/11 | Source: SQL Saturday | Category: events
Rating: (not yet rated) |  Discuss |   Briefcase | 246 reads

How to create an SSIS conditional data flow task

This article demonstrates how to selectively channel records from a flat-file data source to separate destination tables in an SSIS package using a combination of multicast, data-conversion and conditional-split data flow transformation elements within a data flow task.  Read more...
Rating: |  Discuss |   Briefcase | 4,742 reads

Write for SQLServerCentral

We are looking for new content here for the site, based on your experiences in the real world. Submit something and get yourself published.  Read more...
By Site Owners 2014/04/10 | Source: | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 694 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

SQL Server – Hide system objects in Object Explorer – SQL Server Management Studio

By default, SQL Server system objects are listed in Object Explorer in Management Studio. These system objects include system database,...  Read more...
By Vishal.Gajjar 2014/04/15 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,189 reads

April 2014 – SQL Server Monthly Maintenance Checklist

image source Make sure you start the month right by taking the time to make certain your SQL Server environment is...  Read more...
By StrateSQL 2014/04/15 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,070 reads
Question of the Day

Decryption Keys

By Steve Jones 2014/04/15 | Category: encryption
Rating: (not yet rated) |  Discuss |   Briefcase | 891 reads

I have data for my salespeople in a table as follows:

CustomerID  LastSale                Salesman    Sales
----------- ----------------------- ----------- --------------------
1           2014-01-02 00:00:00.000 1           5000
2           2014-01-05 00:00:00.000 2           1000
2           2014-01-06 00:00:00.000 2           300
1           2014-01-06 00:00:00.000 1... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
515 3725 Hall of Fame  
474 474 SSC-Addicted  
373 401 SSC-Addicted  
371 41495 SSC-Forever  
360 374 Old Hand  
Latest forum posts