Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Welcome to

A Microsoft SQL Server community of 1,874,635 DBAs, developers and SQL Server users

Previous headlines

SQL Server Performance Dashboard Reports

Setting up SQL Server Management Studio (SSMS) based performance dashboard driven off servers that are registered through a Central Management Server (CMS).  Read more...
By Arun Sirpal 2016/12/09 (first published: 2015/08/20) | Source: | Category: sql server
Rating: |  Discuss |   Briefcase | 9,367 reads

Some Tips for Minimising the Pain of HTML Input Forms

HTML Input forms are, by their nature, tiresome for the user of any website. However, with some attention to detail and a dash of JavaScript, it is possible to reduce the drudgery of form-filling to the minimum and minimise mistakes. Dino explains four ways of making things better for the user of your website.  Read more...
By Additional Articles 2016/12/09 | Source: SimpleTalk | Category: html
Rating:  Rate this |   Briefcase | 1,486 reads

Troubleshooting a painful query using execution plans in SQL Monitor

When something's wrong with your database you need to be able to identify the primary pain points within SQL Server and get to the root cause of the problem fast. Grant Fritchey explains how you can use execution plans inside SQL Monitor to help quickly and simply identify the problem.  Read more...
By Additional Articles 2016/12/09 | Source: Redgate | Category: execution plans
Rating: (not yet rated)  Rate this |   Briefcase | 1,678 reads

Downloading multiple files from internet with SSIS and C#

This is a tutorial to download multiple files from internet using the SSIS Script Task.  Read more...
By Daniel Calbimonte 2016/12/08 | Source: | Category: ssis
Rating: |  Discuss |   Briefcase | 769 reads

Can comments hamper stored procedure performance?

After a recent conversation on Twitter, Aaron Bertrand shows where excessive comments in your stored procedures might have an impact on performance.  Read more...
By Additional Articles 2016/12/08 | Source: | Category: stored procedure
Rating: (not yet rated)  Rate this |   Briefcase | 2,989 reads

Free Webinar: Redgate DLM Demo

Learn how to use Redgate’s DLM solution to improve your database change management process in our free webinar on December 13th. Microsoft Data Platform MVP, Grant Fritchey, and Redgate’s Arneh Eskandari, will demonstrate how Redgate’s tools plug into TFS, TFS Build & Microsoft Release Management so that you can build, test and deploy your database alongside your application code.  Read more...
By 2016/12/08 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 1,945 reads

Stairway to Exploring Database Metadata Level 5: Exploring Facts About Tables

Now that we've explored, in preceding levels, some of the information that is available about indexes, triggers, keys and distribution statistics, we can concentrate on the tables themselves and their columns.  Read more...
By Phil Factor 2016/12/07 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 910 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 2016/12/07 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 78,754 reads

SQLBits 2017

SQLBits 2017 has been announced. The conference will take place on April 5-8, 2017 in Telford, UK.  Read more...
By Additional Articles 2016/12/07 | Source: SQLBits | Category: sqlbits
Rating:  Rate this |   Briefcase | 1,722 reads

Cloning a SQL Server Login with all permissions using PowerShell

Cloning a SQL Server login with permissions that match another login is a common task. In this post, Jeffrey Yao shows how this an be done using PowerShell.  Read more...
By Additional Articles 2016/12/07 | Source:
Rating:  Rate this |   Briefcase | 2,427 reads
Redgate DevOps Survey

Question of the Day

SQL Server 2016 SP1 Features

By Steve Jones 2016/12/09 | Category: sql server 2016
Rating: (not yet rated) |  Discuss |   Briefcase | 570 reads

Which of these features cannot be used in SQL Server 2016 SP1+ Standard Edition?

Top Members (last 30 days)
# Name Score Level
30 days All-time
519 540 Mr or Mrs. 500  
Alok Seth
411 411 SSC-Addicted  
403 515 Mr or Mrs. 500  
Eirikur Eiriksson
251 6574 SSCertifiable  
Jeff Moden
219 42081 SSC-Forever  
Latest forum posts