Thoughts on the PASS BAC
I recently read PASS and Business Analytics: A Winning Combination on the PASS blog and it reminded me that I’ve been...
2015-07-08
580 reads
Blog Posts
What is the database property “Compatibility Level”
What is the database property Compatibility Level? I don’t get asked to write about specific subjects very often but in...
2015-07-08
661 reads
AdventureworksCI Step 3 Handling data with SSDT
This is part of a series on how to take the Adventureworks database and bring it in line with modern standards. How do we put a legacy SQL Server...
2015-07-07
2 reads
AdventureworksCI Step 3 Handling data with SSDT
This is part of a series on how to take the Adventureworks database and bring it in line with modern...
2015-07-07
736 reads
AdventureworksCI Step 3 Handling data with SSDT
This is part of a series on how to take the Adventureworks database and bring it in line with modern...
2015-07-07
37 reads
AdventureworksCI Step 3 Handling data with SSDT
This is part of a series on how to take the Adventureworks database and bring it in line with modern...
2015-07-07
36 reads
Blocking and deadlocking on purpose
Blocking and deadlocking are not things you typically want to do deliberately. But sometimes you need to test error handling...
2015-07-07 (first published: 2015-07-01)
2,567 reads
Pros and Cons of Switching to Database Managed Services
What are exactly Database Managed Services?
The term is widely used and covers so many things simultaneously, so it is hard...
2015-07-07
985 reads
Run SQL Server In A Container Today July 2015
Containers are one of the big things at the moment, Microsoft has recently announced that they will be bringing official support to Windows. While this is great news it...
2015-07-07
3 reads
Run SQL Server In A Container Today July 2015
Containers are one of the big things at the moment, Microsoft has recently announced that they will be bringing official...
2015-07-07
28 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