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

Headlines today   December 8, 2016

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 | 578 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,440 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,147 reads
Previous headlines

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 | 828 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,545 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,537 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 | 1,943 reads

Non-Numeric Measures in DAX

Enhance the functionality of your SSAS Tabular and PowerBI output, by understanding HOW-, WHY- and WHEN to leverage the power of DAX to create text, date or Boolean measures.  Read more...
By James McGillivray 2016/12/06 | Source: | Category: dax
Rating: |  Discuss |   Briefcase | 497 reads

Azure SQL Database - Authenticating Application Access by Using Azure AD Tokens

Learn how to leverage Azure Active Directory when connecting to Azure SQL Database from applications or services in a non-interactive manner, by relying on token-based authentication.  Read more...
By Additional Articles 2016/12/06 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 2,889 reads

Have you adopted database DevOps?

Redgate invites you to participate in a survey to uncover rates of adoption of DevOps practices among Microsoft SQL Server database users. The survey will take between 5 and 10 minutes to complete. All respondents who provide a valid email address will be sent a copy of the research report when available, as well as being entered into a prize draw to win a $250 Amazon gift card.  Read more...
By 2016/12/06 (first published: 2016/12/02) | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 4,863 reads
Redgate DevOps Survey

From the SQLServerCentral Blogs

SSIS Data Flow "Sequence Containers" are Here!

Wooo! OK - maybe too much of a celebration... and I do have meatier topics in the article pipeline.  However, I just...  Read more...
By Todd McDermid 2016/12/08 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 226 reads
Question of the Day

AG Backup Preference

By Steve Jones 2016/12/08 | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 472 reads

I have a two node Availabilty Group (AG) in my environment, and I need to ensure the databases are backed up while minimzing load on the primary. I want to...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
Eirikur Eiriksson
307 6565 SSCertifiable  
286 286 SSC Veteran  
273 294 SSC Veteran  
Jeff Moden
231 42078 SSC-Forever  
Ed Wagner
197 9956 SSCrazy Eights  
Latest forum posts