Testing Failover for Azure SQL Database
It is always a good idea to test your failover processes when you have setup failover groups in Azure. I...
2018-10-02
355 reads
Blog Posts
Where Are Your Data Leaks?
It has been almost impossible to avoid reading about the numerous large-scale data breaches reported on a seemingly daily basis....
2018-10-02 (first published: 2018-09-25)
1,953 reads
Why Wont SQL Server Use My Filtered Index?
As with most of my posts of late all examples here are using the StackOverflow SQL Server database that can...
2018-10-02
118 reads
Why Wont SQL Server Use My Filtered Index?
As with most of my posts of late all examples here are using the StackOverflow SQL Server database that can...
2018-10-02
229 reads
[Video] Configuring Geo-Replication to SQL DB
With the hurricane bearing down on the east coast of the United States last week, making sure you have a...
2018-10-01 (first published: 2018-09-21)
1,302 reads
Azure Cosmos DB Free Trial – walk through of Gremlin API for Graph
After the 2018 Microsoft Ignite event, Microsoft announced a free trial of Azure Cosmos DB. For those who are eager to check out Cosmos DB, this is a great...
2018-10-01
13 reads
Azure Integration Options and Overview
Today I’d like to talk about Azure integration services that you can leverage within the platform. Integration services allow data...
2018-10-01 (first published: 2018-09-20)
1,458 reads
Azure Integration with Logic Apps
Today I’d like to talk about integration with Azure Logic Apps and how they can help your organization to do...
2018-10-01
298 reads
I helped write a book! No, not THOSE books…
Every now and again, someone asks if I write romance novels. Why? Well, let’s ask Bing who Kendra Little is…. To clarify, I am not married, I have dogs...
2018-10-01
4 reads
Redgate Releases Sept 2018–Practicing DevOps
At Redgate, we build tools to help you build software in the entire DevOps cycle. In fact, I love this...
2018-10-01
297 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
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