Bad weather and Power Outage
After years of mild weather in the St. Louis area, this is the second time we have been hit hard...
2006-12-02
1,332 reads
Blog Posts
Excellent post on encryption
Laurentiu Cristofor has an excellent blog post, Who needs encryption?, which presents some point blank facts about encryption and the...
2006-12-01
1,645 reads
Professional Association of SQL Server - Midlands Chapter First Meeting
If you are in South Carolina or a nearby location (Charlotte, Augusta, etc.) and are interested in participating in an...
2006-12-01
1,577 reads
TechEd 2007 tracks announced
The Microsoft TechEd tracks have been released early here:
Sneak Peak at the 2007 Tracks
For those who are interested in attending...
2006-12-01
1,484 reads
Data Dude
I went to an abbreviated version of the Visual Studio 2005 Team Edition for Database Professionals launch this morning. The...
2006-11-30
1,581 reads
ApexSQL SQL Server VIP/MVP Offer
ApexSQL has an offer to anyone who is a SQL Server MVP or VIP for a gratuity of their ApexSQL...
2006-11-29
1,741 reads
Measuring pi by throwing frozen hot dogs?
I saw this today on my Google front page under the How To section:
How to Calculate Pi by Throwing Frozen...
2006-11-29
1,624 reads
Microsoft Network Monitor 3.0 Released
If you aren't familiar with Network Monitor, it's a packet sniffer that's a Windows component on the server builds (Control...
2006-11-29
1,591 reads
SSMS and scripting
I've heard a lot of complaints about SQL Server Management Studio concerning slowness and some of the things, like scripting...
2006-11-28
1,368 reads
Default schema
Sadly, I haven't had much experience yet with SQL Server 2005 except for Reporting Services and SSIS. The majority of...
2006-11-27
1,402 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