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,433 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 | 118 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 | 676 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 | 396 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 | 753 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,394 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,395 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,703 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 | 483 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,691 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,746 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 | 147 reads
Question of the Day

AG Backup Preference

By Steve Jones 2016/12/08 | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 77 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
308 6563 SSCertifiable  
262 283 SSC Veteran  
249 249 SSC Veteran  
Jeff Moden
236 42077 SSC-Forever  
Ed Wagner
203 9955 SSCrazy Eights  
Latest forum posts