Planning a Longer Break Soon
I’m sure you know what I mean when I say that I feel like my ability to task switch and...
2009-11-11
480 reads
Blog Posts
Speaking at the .NET User Group meeting
When a SQL Server application is under performing, how can you isolate where the actual problem is? Would more memory...
2009-11-11
289 reads
Troubleshooting SQL Server Database Mirroring Problems with Best Practices: Requirements, and the 64-bit Benefit
As mentioned in previous disaster recovery posts and article, during my current mandate I have been tasked with what will...
2009-11-11
11,977 reads
Using a SSRS Report to run SQL Agent Jobs
Data Warehouse latency is often a complaint I have heard from end users when trying to access data via either...
2009-11-11
6,596 reads
And the Winner is........
DB Audit Challenge #1
And the Winner is….
First, I want to thank everyone that participated in the DB Audit Challenge, and...
2009-11-10
814 reads
Article of the Week – Sanjay Mirsha (Data Compression)
Data Compression was introduced in SQL Server 2008. This feature helps compress data inside the database, thus potentially reducing the...
2009-11-10
722 reads
Looking Back – PASS Summit 2009 Day 2
Tuesday started early for me because I had to be at the bloggers table in time for the opening remarks...
2009-11-10
638 reads
PASS Summit 2009 – Overall Event
I thought that we got a great Summit from PASS in 2009. This week I’ll be looking back at some...
2009-11-10
697 reads
SQL Connections
I’m flying off to the SQL Server Magazine Connections part of DevConnections in Las Vegas later this afternoon. I’m presenting...
2009-11-10
560 reads
SQL Server MVP Deep Dives Book Signing at PASS
The PASS Community Summit is one of the highlights of my professional year. It’s a time when members of the...
2009-11-10
387 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