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

Rss
Headlines today   January 18, 2017

Five Useful SQL Server Management Practices

This article outlines five SQL Server capabilities you can use to enhance your efficiency as a DBA.  Read more...
By Kenneth Igiri 2017/01/18 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 548 reads

Put your Database under Source Control

This article will walk you through a demostration on linking your DB to SubVersion with RedGate SQL Source Control.  Read more...
By Thomas Liddle 2017/01/18 | Source: SQLServerCentral.com | Category: db source control
Rating: |  Discuss |   Briefcase | 151 reads

SQL Server v.Next : STRING_AGG() performance

Aaron Bertrand takes an initial look at the performance of a new function, STRING_AGG, in SQL Server v.Next CTP 1.1.  Read more...
By Additional Articles 2017/01/18 | Source: SQLPerformance.com | Category: sql server v.next
Rating: (not yet rated)  Rate this |   Briefcase | 704 reads
Previous headlines

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: SQLServerCentral.com | Category: r services
Rating: (not yet rated) |  Discuss |   Briefcase | 753 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 | 2,642 reads

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: SQLServerCentral.com | Category: pivot
Rating: |  Discuss |   Briefcase | 1,533 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,826 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 | 2,093 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: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 9,188 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: MSSQLTips.com | Category: alwayson
Rating: (not yet rated)  Rate this |   Briefcase | 1,712 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

SQL Server 2016 SP 1

By David Postlethwaite SQL Server 2016 SP1 was released in November 2016 only five months after the initial release. There have been...  Read more...
By David Postlethwaite 2017/01/18 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 499 reads

Do I have a Database Master Key in a database? #SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...  Read more...
By Steve Jones 2017/01/18 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 353 reads
Question of the Day

EXECUTE as SELF

By Steve Jones 2017/01/18 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 215 reads

If I create a stored procedure with EXECUTE AS SELF in the definition, under what context is the procedure executed?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
joseph breese
10040 10040 SSChampion  
2.
Jeff Moden
2865 44994 SSC-Forever  
3.
Steve Jones - SSC Editor
1672 36062 SSC-Dedicated  
4.
GilaMonster
1547 47192 SSC-Forever  
5.
SQLRNNR
990 21073 SSC-Insane  
Latest forum posts