Monitoring for Timeouts
The question came up at SQL Rally, “Can you use Extended Events to monitor for query timeouts?”
My immediate response was...
2015-03-20 (first published: 2015-03-12)
7,642 reads
Blog Posts
Achievement Unlocked: 24 Hours of Pass Session Submitted
I have finally submitted a session for a speaking engagement. Those who know me know that this is a very...
2015-03-19
743 reads
Audit Schema Change Report
In a recent article on SSG, I discussed how to use Extended Events to function in a Profiler like fashion....
2015-03-19 (first published: 2015-03-11)
6,657 reads
Azure SQL Database Elastic Scale Part 1 - What is Sharding?
Azure SQL Database Elastic Scale Part 1 - What is Sharding?
MARCH 19, 2015
This week, Microsoft introduced an update to Azure SQL Database Elastic Scale Preview. This update is good...
2015-03-19
40 reads
Azure SQLDatabase v12 Premium Editions and Available Cores
A couple of days ago, during the great SQL Unplugged live show, I have asked a couple of questions the...
2015-03-19
870 reads
Free Professional Advice on Setting up Continuous Integration for Sql Server Databases
Calling all London/Sussex Sql Developers does this sound like you? Would you like to set up Continuous Integration or Continuous...
2015-03-19
39 reads
Free Professional Advice on Setting up Continuous Integration for Sql Server Databases
Calling all London/Sussex Sql Developers does this sound like you?
Would you like to set up Continuous Integration or Continuous DeploymentDo...
2015-03-19
409 reads
Free Professional Advice on Setting up Continuous Integration for Sql Server Databases
Calling all London/Sussex Sql Developers does this sound like you? Would you like to set up Continuous Integration or Continuous...
2015-03-19
47 reads
Free Professional Advice on Setting up Continuous Integration for Sql Server Databases
Calling all London/Sussex Sql Developers does this sound like you? Would you like to set up Continuous Integration or Continuous Deployment Do you want to get your databases...
2015-03-19
6 reads
Getting Under The Hood
Whenever a piece of software does something that makes me think this is awesome I find myself blocking out the...
2015-03-19
58 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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