Grouping Sets
I have given a talk about new data types and T-SQL features to three local groups. I am presenting it...
2008-11-28
2,211 reads
Blog Posts
Database Adminstration Scalability
database administration scalabilityI am working on a project that is very successful in terms of its market
share, i.e. product users...
2008-11-27
1,870 reads
Does regulation make data any safer?
Working with healthcare organizations, I am constantly aware of the restrictions my staff and I must abide by according to HIPAA constraints. ...
2008-11-27
1,670 reads
Pumpkin Tossing
One more holiday post. Hope you all enjoyed Thanksgiving and are now enjoying either a quiet and well deserved day...
2008-11-27
1,364 reads
Happy Thanksgiving
I'm cheerfully taking the day off today (and tomorrow too!), and I'm writing this a week in advance as I...
2008-11-26
1,458 reads
Surface Demo
Second try. The video didn’t embed in the previous post. Nor this one. Here's the link
Microsoft Surface Demo
This is from...
2008-11-26
1,432 reads
Surface Possibilities
This is interesting. I’m not sold on Surface, though I did play with one last week in Seattle.
2008-11-26
1,391 reads
Workaround Primary Key Violations in SSIS
Before you get much further, please do not use this for every case where you have issues with duplicate rows....
2008-11-26
1,520 reads
Airlines Don't Care About Customers? Nor Does The Government!
I saw this post about a recent panel that tried to come up with guidelines for airlines as far as...
2008-11-25
1,387 reads
Catching Up
My goal of 400 posts a month has been in jeopardy with all the traveling I've been doing over the...
2008-11-25
1,479 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