Azure SQL Database offers several benefits, built into the underlying cloud infrastructure, that leverage resiliency and redundancy. You can take advantage of this functionality to facilitate failover and failback in response to events that affect availability of an Azure region.
2017-03-14
3,555 reads
2017-03-13
1,849 reads
Identifying a need for better collaboration between teams is only the first step to introducing DevOps workflows into your organization. You also need to define a common DevOps goal,...
2017-03-13
2,937 reads
Understanding execution plans is a good basic skill for all DBA's and SQL developers. Darren White gives us an overview of what execution plans are in SQL Server and how they are used.
2017-03-10 (first published: 2014-02-18)
30,922 reads
Satnam Singh walks through the steps he took to troubleshoot a recent issue with memory consumption on a staging server.
2017-03-10
6,023 reads
This time we will work with the sqlcmd to handle our Azure SQL Data Warehouse
2017-03-09
1,183 reads
2017-03-09
556 reads
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
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,070 reads
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...
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
I have a SQL Agent job for backing up a set of Analysis Services...
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
Comments posted to this topic are about the item The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers