Professional Microsoft SQL Server 2008 Administration
When I came home from work tonight, there waiting on my was my copy of Professional Microsoft SQL Server 2008...
2008-11-03
1,163 reads
Blog Posts
Sniffing out bogus data
/* Imagine that you have some names and addresses. You are anxious to look at the addresses that may be spurious....
2008-11-03
673 reads
The Wise Old Man Part 3
In my previous posts The Wise Old Man Part 1 and The Wise Old Man Part 2 I wrote about...
2008-11-03
712 reads
DBA and Doctor
I always feel it is harder to be a DBA than to be a doctor while we are doing almost...
2008-11-02
1,328 reads
How Many People Can a Manager Manage?
This question came up during lunch this past week, and it's a good question. I'll start with my stock 'It...
2008-11-02
555 reads
Timing is Everything
I got up this morning, wanting to go through the forums, check on Database Weekly, etc. as a Sunday morning...
2008-11-02
574 reads
Auditing for Blank Passwords
Auditing blank passwords in SQL Server 2005 and 2008 proves a bit more challenging than in SQL Server 2000. In...
2008-11-01
1,236 reads
SQL Server 2008 Data Compression Example
I was experimenting with the effects of row and page compression in SQL Server 2008 Enterprise Edition.
First, I identified...
2008-10-31
4,291 reads
Follow Up to Blog Review Post
A month or so ago I posted Blog Review - Yours & Mine to see what I might get for feedback about...
2008-10-30
1,499 reads
New Books on SQL Server 2008
Since the release of SQL Server 2008, a slew of new books have been released, or are about to be...
2008-10-30
1,725 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers