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

Welcome to SQLServerCentral.com

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

Rss
Headlines today   December 9, 2016

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: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 9,304 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,349 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,431 reads
Previous headlines

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: SQLServerCentral.com | Category: ssis
Rating: |  Discuss |   Briefcase | 750 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: SQLPerformance.com | Category: stored procedure
Rating: (not yet rated)  Rate this |   Briefcase | 2,897 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,724 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: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 900 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,691 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,658 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: MSSQLTips.com
Rating:  Rate this |   Briefcase | 2,252 reads
 
Redgate DevOps Survey



From the SQLServerCentral Blogs

Validating a Set of Database Scripts using DLM Automation

The basis of all the DLM Automation from Redgate is a series of PowerShell cmdlets. They might look intimidating or...  Read more...
By Steve Jones 2016/12/09 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 609 reads
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 | 544 reads

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

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Alok Seth
411 411 SSC-Addicted  
2.
lalit_madan
403 515 Mr or Mrs. 500  
3.
prince rastogi
312 333 Old Hand  
4.
Eirikur Eiriksson
277 6573 SSCertifiable  
5.
Jeff Moden
226 42081 SSC-Forever  
Latest forum posts