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.
2017-03-09
5,294 reads
2017-03-08
1,074 reads
The article is about Configuring TempDB Database on Local Disk in SQL Server 2012/2014 Failover Cluster to improve performance.
2017-03-08
2,615 reads
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
No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 2 of a 2-part article.
2017-03-07
1,531 reads
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
Join the SSIS Catalog Compare v2.0 Launch Event on Tue, Mar 7 at 13:00 EST.
2017-03-07 (first published: 2017-03-03)
6,163 reads
No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 1 of a 2-part article.
2017-03-06
1,385 reads
The SQL Server Luxembourg User Group invites you to join us at our next event in Microsoft’s Offices, at 6:00pm on Tuesday 7th March
2017-03-06
542 reads
Greg Larsen explains how you can use Dynamic Management Objects and stored procedures to return your worst performing T-SQL statements.
2017-03-06
5,202 reads
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item The Problem Isn't Always Your...
Comments posted to this topic are about the item Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers