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

Headlines today   January 16, 2017

A Possible Alternative to SQL UNPIVOT

Understand how to use the SQL UNPIVOT statement and then an equivalent using XML and XPath Querying in SQL Server.  Read more...
By Paul Milligan 2017/01/16 | Source: | Category: pivot
Rating: |  Discuss |   Briefcase | 1,107 reads

Free Webinar – Database DevOps Demo

Learn how to extend DevOps practices to SQL Server databases in our free demo webinar on January 17th. Microsoft Data Platform MVP, Steve Jones will demonstrate how Redgate’s database automation tools plug into Git, Jenkins & Octopus Deploy. Learn how to branch and merge with SQL Source Control then automate the build and deployment of changes with DLM Automation. Register now.  Read more...
By Additional Articles 2017/01/16 (first published: 2017/01/11) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 3,421 reads

Using Power BI Desktop to Visualize SQL Server Metadata

You can easily use PowerBI Desktop to show graphically how your database is growing, which tables are taking the most space, how various parts of SQL Server is consuming memory, its use of indexes and so on. Sure, you can create graphs in SSMS, but with PowerBI, you can create reports that you can then publish to others, and which allow drill-down. It is a great way to get familiar with PowerBI Desktop as well. Rob Sheldon shows how simple it is to do.  Read more...
By Additional Articles 2017/01/16 | Source: SimpleTalk | Category: power bi desktop
Rating: (not yet rated)  Rate this |   Briefcase | 1,540 reads
Previous headlines

Scrubbing Personally Identifiable Information

Managing personally identifiable information when moving databases to unsecure environment can be challenging. With this flexible and extendable solution for scrubbing it, you can save yourself some time and effort.  Read more...
By Daniel Brown 2017/01/13 (first published: 2015/01/06) | Source: | Category: restore
Rating: |  Discuss |   Briefcase | 9,068 reads

Configure SQL Server AlwaysOn Availability Group on a Multi-Subnet Cluster

A “multi-subnet” environment is defined when the OS cluster used as the backbone for AlwaysOn has server nodes that are located in multiple/different subnets. Deploying SQL Server AlwaysOn Availability Groups requires a Windows Server Failover Clustering (WSFC) cluster and each availability replica of a given availability group must reside on a different node of the same WSFC cluster. This post from Manvendra Singh will help you in configuring an HA and DR solution for SQL Server AlwaysOn in multi-subnet networks.  Read more...
By Additional Articles 2017/01/13 | Source: | Category: alwayson
Rating: (not yet rated)  Rate this |   Briefcase | 1,527 reads

Backing Up SQL Server Databases is Easier in PowerShell than T-SQL

Learn how easy the new SQLServer module makes backups of SQL Server databases.  Read more...
By Aaron Nelson 2017/01/12 | Source: | Category: powershell
Rating: |  Discuss |   Briefcase | 1,513 reads

Identifying Last Night’s SQL Agent Job Failures

Finding the nightly job failures is just one of a DBA's morning rituals. It is fairly easy to scan all the email with a number of creative search criteria, but what if you would like a more automated approach? Read on to learn how to find and report all job failures using a script.  Read more...
By Additional Articles 2017/01/12 | Source: Database Journal | Category: sql agent
Rating:  Rate this |   Briefcase | 2,778 reads


U-SQL introduces two new data types - SQL.ARRAY and SQL.MAP. Here, we look at what we can do with SQL.ARRAY and the CROSS APPLY EXPLODE expression.  Read more...
By Mike McQuillan 2017/01/11 | Source: | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,225 reads

SQL Server Database Provisioning

Database provisioning for development work isn't always easy. The better that development teams meet business demands for rapid delivery and high quality, the more complex become the requirements for the work of development and testing. More databases are required for testing and development, and they need to be more rapidly kept current. Data and loading needs to match more closely what is in production. Grant Fritchey explains.  Read more...
By Additional Articles 2017/01/11 | Source: SimpleTalk | Category: provisioning
Rating: (not yet rated)  Rate this |   Briefcase | 3,322 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

What is ETL?

In my ongoing series on ETL Best Practices, I am illustrating a collection of extract-transform-load design patterns that have proven...  Read more...
By Tim Mitchell 2017/01/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,289 reads
Question of the Day

DECLARE multiple vars with default value

By Thomas Franz 2017/01/16 | Category: declare
Rating: (not yet rated) |  Discuss |   Briefcase | 725 reads

What will be the content of @t when you execute the following statements:

DECLARE @s VARCHAR(5) = 'test',
@t VARCHAR(5) = @s;

Top Members (last 30 days)
# Name Score Level
30 days All-time
joseph breese
10040 10040 SSChampion  
Jeff Moden
2742 44859 SSC-Forever  
Steve Jones - SSC Editor
1567 35957 SSC-Dedicated  
1501 47143 SSC-Forever  
964 21047 SSC-Insane  
Latest forum posts