Articles

If you need to run SQL Server in an Azure Virtual Machine, your choice of Azure storage will have a great effect on its performance. If performance is important, you are likely to discover complications and barriers in the storage options when you come to provision the server. If you get it wrong, you could end up with an expensive service. Joshua explains the value of using a lab environment to allow you to make well-informed VM storage decisions when the time comes to provision your production system.

2017-03-09

2,748 reads

Redgate Data Tools in Visual Studio 2017 Enterprise

by Additional Articles

SQLServerCentral.com

RedGate

Today during the Visual Studio launch event, we announced that we’ve partnered with Redgate to include Redgate Data Tools in Visual Studio 2017. Redgate Data Tools includes three components that extend DevOps practices to SQL Server and Azure SQL databases and increase your productivity while doing database development.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2017-03-09

5,294 reads

SQL Migrator (Part 1)

by Datamate Technology

SQLServerCentral.com

Migration

Read about a free automated Upgrade\Migration Tool for SQL Server.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(4)

You rated this post out of 5. Change rating

2017-03-08

1,075 reads

Discuss

TempDB Database On a Local Disk for an FCI

by Sadan Kumar Budde

SQLServerCentral.com

failover

The article is about Configuring TempDB Database on Local Disk in SQL Server 2012/2014 Failover Cluster to improve performance.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2017-03-08

2,624 reads

Discuss

Move Azure SQL Databases using the Export and Import PowerShell cmdlets

by Additional Articles

MSSQLTips.com

Azure SQL database

John Miner shows how to move databases between a cloud development environment and an on-premise production environment using PowerShell cmdlets.

2017-03-08

3,664 reads

Detective Stories - Tracking Down the Database's Dependents Part 2

by Brandie Tarvin

SQLServerCentral.com

database dependencies

No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 2 of a 2-part article.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(5)

You rated this post out of 5. Change rating

2017-03-07

1,536 reads

Discuss

Query Store and In-Memory OLTP

by Additional Articles

SimpleTalk

Query Data Store (QDS)

Once you have Query Store enabled on your databases, runtime statistics are generated for your queries; but what about the natively-compiled stored procedures and memory optimised tables that come with In-Memory OLTP? Do you get the full range of runtime statistics? This is an intriguing question that Enrico explores and answers.

2017-03-07

4,670 reads