PASS Board Call For Nominations Open
Nominations opened today and will run through July 21st. Whether you’re planning to be a candidate or not, I hope...
2010-06-24
553 reads
Blog Posts
PowerShell Script to Remove Old Backups
A Twitter user asked for a script to remove old backups, and I had one I built back in February,...
2010-06-24
1,125 reads
Traveling with Steve
I don’t travel a lot, but with the success of SQL Saturday, I find myself heading out on the road...
2010-06-24
1,328 reads
24 Hours of PASS
On the 19th/20th May (last month) the Professional Association of SQL Server (PASS) held its second 24 hours of PASS...
2010-06-23
723 reads
Building a PASS Voting Solution – Part 5
Today we move over to the web side of things. I put this together with VS 2010, and it’s a...
2010-06-23
577 reads
Change Data Capture vs Change Tracking
Make sure to check out the comments on this one!
A short conversation on Twitter Monday night reminded me of this...
2010-06-23
1,085 reads
Error 25602 When Creating an Extended Events Session: a Security Risk
Error 25602 When Creating an Extended Events Session: a Security Risk
I came across an interesting issue recently when helping someone...
2010-06-23
3,575 reads
How To Stay Current with SQL Server Cumulative Updates
Since the release of SQL Server 2005, Microsoft has been using what they call an Incremental Servicing Model for SQL...
2010-06-23
2,189 reads
In The Spotlight!
I received an unexpected but certainly not unwelcome email last night letting me know that I've been selected to present...
2010-06-23
412 reads
Learning Powershell
I’ve been attending a Powershell fundamentals class with Don Jones (blog|twitter). If you read my blog you might be aware...
2010-06-23
1,707 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