SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,885,598 DBAs, developers and SQL Server users

Headlines today   May 24, 2017

Stairway to Columnstore Indexes Level 12: Clustered or Nonclustered?

The previous levels of this stairway describe details, features, and limitations of columnstore indexes in SQL Server. But they do not answer what should be the first question for every database professional: should columnstore indexes be used in my databases; on what tables should they be used; and should they be clustered or nonclustered columnstore indexes?  Read more...
By Hugo Kornelis 2017/05/24 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 314 reads

Masking your on-premise database with SQL Data Mask

In the last update from Redgate Foundry three weeks ago, they announced their intention to build a version of SQL Data Mask that would mask on-premise SQL Server databases, as well as Azure SQL Databases. They're pleased to say this version of the prototype is now available - here are the details.  Read more...
By Additional Articles 2017/05/24 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 644 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 2017/05/24 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 80,551 reads
Previous headlines

Yet another SSIS XML Destination

See a simple script to generate an XML file in SSIS.  Read more...
By Adán Bucio 2017/05/23 | Source: SQLServerCentral.com | Category: ssis
Rating: |  Discuss |   Briefcase | 651 reads

Azure Networking for SQL Server DBAs

The network is important to any DBA because so much performance is dependent on I/O, because of the importance of security, and ensuring that everyone get the right access. DBAs generally need not become experts in Azure networks, but it helps to understand the concepts and language. If you are running a SQL Server Virtual Machine in Azure, then VNets, Subnets, Network Security Groups, VNet peering and VPN gateways are all worth knowing about in order to to keep SQL Servers running smoothly.  Read more...
By Additional Articles 2017/05/23 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,204 reads

How to document multiple SQL Server databases using SQL Doc and PowerShell

You can use SQL Doc’s command-line parameters to automate database documentation, but when you try with a group of databases on a server, they sometimes don’t give you enough control over the job. Phil Factor provides a solution that allows both automation and flexibility.  Read more...
By Additional Articles 2017/05/23 | Source: Redgate | Category: sql doc
Rating: (not yet rated)  Rate this |   Briefcase | 1,636 reads

Azure DWH part 9: Azure PHP and ASDW

In this new Azure Data Warehouse article, we will show how to insert data and retrieve it using PHP.  Read more...
By Daniel Calbimonte 2017/05/22 | Source: SQLServerCentral.com | Category: php
Rating: |  Discuss |   Briefcase | 225 reads

Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 4

Continuing his series covering a step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster, Edwin Sarmiento looks at adding a node to an existing SQL Server 2016 failover clustered instance (FCI).  Read more...
By Additional Articles 2017/05/22 | Source: MSSQLTips.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 1,409 reads

Webinar: Extending DevOps practices to SQL Server databases

In this free demo webinar, Steve Jones and Arneh Eskandari will show how Redgate’s database DevOps solution works to improve your database development and deployment processes. With a focus on using Team Foundation Server (TFS) work items, the webinar will demonstrate how Redgate tools plug into TFS, TFS Build, and Microsoft Release Management. Register now.  Read more...
By Press Release 2017/05/22 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 1,163 reads

Forecasting with SQL

Can you use SQL Server to extrapolate out trends from your data? Lots of companies would have you buy a BI solution instead, but new author Mark Wojciechowicz brings us a great example of how you could forecast something in T-SQL.  Read more...
By Mark Wojciechowicz 2017/05/19 (first published: 2010/02/09) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 16,313 reads

Ask SQL Server Central

From the SQLServerCentral Blogs

Find the number of rows for a value, without querying the table

Dear all, Being a DBA, developers approach me with questions like can you run this query for me in production? Select*FROM[dbo].[FactInternetSales] WHERE UnitPrice...  Read more...
By 2017/05/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,124 reads

Using Azure Machine Learning with an on-premises Database

With Azure Machine Learning (AzureML) you have access to a cloud based, flexible and friendly method to perform machine learning...  Read more...
By Enrico van de Laar 2017/05/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 722 reads
Question of the Day

Listing files in R

By Steve Jones 2017/05/24 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 288 reads

If I want to get a list of files in my current directory in R, how to I get this?

Top Members (last 30 days)
# Name Score Level
30 days All-time
Jeff Moden
29628 114617 SSC Guru  
27763 114287 SSC Guru  
Steve Jones - SSC Editor
19874 81689 SSC Guru  
Grant Fritchey
15392 54677 SSC Guru  
Lynn Pettis
11931 50938 SSC Guru  
Latest forum posts