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

Headlines today   January 17, 2017

Using SQL Server and R Services for analyzing Sales data (Part 3)

Using R integration for analyzing sales data in WideWorldImporters database  Read more...
By Tomaž Kaštrun 2017/01/17 | Source: | Category: r services
Rating: (not yet rated) |  Discuss |   Briefcase | 476 reads

SQL Server in Azure Virtual Machines - Performance Optimizations

When deploying SQL Server in an Azure virtual machine, you can take advantage of several Azure Infrastructure-as-a-Service (IaaS) features that enhance performance of the SQL Server database engine. This article explores a couple of these enhancements, with a particular focus on increased I/O throughput facilitated by the Solid State Drive (SSD) storage available on most Azure virtual machines (VMs).  Read more...
By Additional Articles 2017/01/17 | Source: Database Journal | Category: azure vm
Rating: (not yet rated)  Rate this |   Briefcase | 1,673 reads
Previous headlines

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,392 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,636 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,893 reads

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,136 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,630 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,567 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,898 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,248 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Undestanding Network Latency and Impact on Availability Group Replication

When designing Availability Group systems one of the first pieces of information I ask clients for is how much transaction...  Read more...
By Anthony Nocentino 2017/01/17 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 635 reads

Upcoming SQL Server Events from PASS

There are many ways to reap benefits from being a member of the PASS Global Community. Today, as I write...  Read more...
By Thomas LeBlanc 2017/01/17 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 557 reads
Question of the Day

Clearing Session Context

By Steve Jones 2017/01/17
Rating: (not yet rated) |  Discuss |   Briefcase | 379 reads

In SQL Server 2016, we have a stored procedure called sp_set_session_context. If I use the @read_only parameter and set to 1, how do I change the value of a key?

Top Members (last 30 days)
# Name Score Level
30 days All-time
joseph breese
10040 10040 SSChampion  
Jeff Moden
2854 44972 SSC-Forever  
Steve Jones - SSC Editor
1627 36017 SSC-Dedicated  
1535 47177 SSC-Forever  
984 21067 SSC-Insane  
Latest forum posts