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

Headlines today   May 30, 2017

Comparing and Synchronizing Two Folders with Azure

In this article, we will compare two folders using PowerShell, the command prompt and other tools.  Read more...
By Daniel Calbimonte 2017/05/30 | Source: SQLServerCentral.com | Category: compare
Rating: (not yet rated) |  Discuss |   Briefcase | 7 reads

SQL Server Temporal Tables: How-To Recipes

Tables that return the value of the data in the table at a particular point of time have been with us since the first relational database, but have always required special queries and constraints, and can be tricky to get right. System-versioned Temporal Tables, new in SQL Server 2016, make such tables behave like any other. How do you create one, or modify an existing table? How can you get an In-Memory Optimized OLTP table to be Temporal? Alex Grinberg shows how.  Read more...
By Additional Articles 2017/05/30 | Source: SimpleTalk | Category: temporal tables
Rating: (not yet rated)  Rate this |   Briefcase | 325 reads

Azure SQL Database - Dynamic Data Masking

A number of security-related features are built into Azure SQL Database, including Transparent Data Encryption, Row-Level Security, and Azure SQL Database Auditing. Their availability reflects the consistent effort by Microsoft to provide functional parity between Azure SQL Database and SQL Server instances running in Azure virtual machines as well as in your on-premises environment. Another example of this trend is support for Dynamic Data Masking, covered in this article.  Read more...
By Additional Articles 2017/05/30 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 314 reads

Webinar: Microsoft’s Agile Transformation Story

Learn how Microsoft adopted DevOps at scale in this free Redgate webinar on June 12. Donovan Brown, Senior DevOps Program Manager in Microsoft’s US Developer Division, will share how Microsoft embarked on its own DevOps journey reducing a three-year release cycle down to three weeks. Sign up now.  Read more...
By 2017/05/30 | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 387 reads
Previous headlines

Combining R and SQL Server to diagnose performance bottlenecks

Using clustering algorithms to analyse index usage data from SQL Server’s DMVs & simplify complex performance investigations.  Read more...
By Nick Burns 2017/05/29 (first published: 2015/12/07) | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 8,428 reads

Generating Plots Automatically From PowerShell and SQL Server Using Gnuplot

When you are automating a number of tasks, or performing a batch of tests, you want a way of automating the production of your plots and graphs. Nothing beats a good graphical plot for giving the indications of how the process went. If you are using PowerShell and maybe also SQL Server, it pays to use a command-line plotting tool such as Gnuplot to do all the hard work. It turns out to be handy for a range of data jobs, turning PowerShell into a handy data science tool.  Read more...
By Additional Articles 2017/05/29 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 915 reads

Using striped backups with SQL Clone

If you’re a Redgate SQL Backup customer, occasionally you’ll need to convert your SQL Backup (.sqb) files to the native SQL Server backup format (.bak), perhaps to perform native database restores on a server where SQL Backup isn’t installed. This produces a striped backup, because each thread used when making the backup will produce a separate file. Can we use a striped backup produced in this way, or indeed any striped backup, as the source for a SQL Clone image? Short answer: we can! Let’s see how that works.  Read more...
By Additional Articles 2017/05/29 | Source: Redgate | Category: sql clone
Rating: (not yet rated)  Rate this |   Briefcase | 722 reads

How to deploy a database plus static data using SQL Compare and SQL Data Compare

This article from Tony Davis describes how to the use the Redgate SQL Compare and SQL Data Compare GUIs to get the current version of a database schema, and its static data, into version control, and then automate database deployments from the version control system using SQL Compare's command line and PowerShell.  Read more...
By Tony Davis 2017/05/26 | Source: Redgate | Category: sql compare
Rating: (not yet rated)  Rate this |   Briefcase | 2,750 reads

Datetime vs. Datetime2

Read a short comparison of datetime and datetime2 types. Learn about their structure, as well as the advantages and disadvantages of each.  Read more...
By Robert Hartmann 2017/05/26 (first published: 2016/01/05) | Source: SQLServerCentral.com | Category: datetime
Rating: |  Discuss |   Briefcase | 13,691 reads

It’s not you, it’s me (I/O troubleshooting)

Monica Rathburn talks about a few of the more common elements she always checks for when troubleshooting I/O problems.  Read more...
By Additional Articles 2017/05/26 | Source: SQLPerformance.com | Category: io performance
Rating: (not yet rated)  Rate this |   Briefcase | 2,048 reads

Ask SQL Server Central

From the SQLServerCentral Blogs

Power BI Custom Visuals Class (Module 51 – Hierarchy Slicer)

In this module you will learn how to use the Hierarchy Slicer Power BI Custom Visual.  The Hierarchy Slicer visual...  Read more...
By Devin Knight 2017/05/30 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 146 reads

Power BI Report Server–Trial

I just installed the Power BI report server following @SQLDusty YouTube 13 minute Step-by-Step video. You have to download both...  Read more...
By Thomas LeBlanc 2017/05/30 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 421 reads
Question of the Day

SQL Server 2014 system databases

By Stanley Kapfunde 2017/05/30 | Category: sql
Rating: (not yet rated) |  Discuss |   Briefcase | 75 reads

Which of the following is not a valid system database in SQL Server 2014?

Top Members (last 30 days)
# Name Score Level
30 days All-time
Jeff Moden
29757 119232 SSC Guru  
29020 119327 SSC Guru  
Steve Jones - SSC Editor
19659 84812 SSC Guru  
Grant Fritchey
15162 56969 SSC Guru  
Lynn Pettis
12006 52820 SSC Guru  
Latest forum posts