This whitepaper explores the differences between the approaches, state based or migrations based, and how Redgate tools can help.
2018-04-05 (first published: 2016-03-24)
6,278 reads
Azure Cosmos DB offers features that facilitate data availability and resiliency. However, there is also a different, very important aspect of facilitating access to distributed data sources in the most optimal manner, which focuses on access control mechanisms. Read on to learn the specifics of this aspect, as it applies to Azure Cosmos DB.
2018-04-04
2,223 reads
The various Snapshot options in Reporting Services 2016 explained.
2018-04-03
3,503 reads
T-SQL does not have an easy way to transpose a row and a column. Of course, there is the PIVOT statement, but it doesn’t quite accomplish the task. In this article, Darko Martinovic shares another method using a SQLCLR stored prodedure.
2018-04-03
5,350 reads
Using SELECT to store values into variables is an important technique, but you need to know some of the gotchas as well.
2018-04-02
6,051 reads
When you’re planning for disaster recovery, offsite backups in the cloud are an attractive option. SQL Server Management Studio makes it easy to back up to the cloud inside the GUI, and you can learn how in just 90 seconds.
2018-04-02
3,400 reads
A step-by-step guide to creating a practice setup for the 70-462 exam using Azure virtual machines.
2018-03-30 (first published: 2015-08-25)
5,831 reads
Tara Kizer explains that many of you are troubleshooting Parameter Sniffing issues the wrong way in production. In this three-part series, she will show you how to troubleshoot it the right way.
2018-03-30
3,974 reads
2018-03-29
2,294 reads
SQL Server 2017 now includes a new feature to represent complex relationships in data called Graph Databases. Robert Sheldon introduces Graph Databases in the first article of this new series.
2018-03-29
4,343 reads
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Comments posted to this topic are about the item Finding Motivation
Comments posted to this topic are about the item The Last Binary Value of...
Comments posted to this topic are about the item SQL Art, Part 2: New...
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers