Don’t Make Dumb Mistakes by Duplicating Indexes
Just today, I was reviewing the indexing of a database used by a third-party application. As part of my review,...
2009-04-15
2,426 reads
Blog Posts
Full Text Catalog Scripting "Gotcha" in SSMS 2008
With every new version of SQL Server comes a set of deprecated features. Usually Microsoft gives fair warning that these...
2009-04-15
584 reads
Last Call for Speakers for SQLSaturday #7 in Birmingham on May 30
I just had a call with John Baldwin who is leading the effort in Birmingham and there plenty of action...
2009-04-15
303 reads
Learn How to Use the SQL Server 2008 Transact-SQL Debugger
Bill Ramos, a SQL Server Product Manager, has written a three part series on how to use the SQL Server...
2009-04-15
857 reads
Microsoft Releases Updated White Paper on Troubleshooting SQL Server 2008 Performance
Microsoft has finally updated their classis Troubleshooting SQL Server Performance white paper for SQL Server 2008, which is available at:
Troubleshooting...
2009-04-15
1,244 reads
Portland, OR Code Camp Set for May 30, 2009
The Portland Code Camp will be held at Reed College on Saturday, May 30, 2009. This free event will include...
2009-04-15
420 reads
Pragmatic Works Foundation Class
This week I've been extremely busy working on the new Pragmatic Works Foundation class, which is the brainchild of Brian...
2009-04-15
704 reads
Richmond, VA Code Camp to be Held April 25
The Richmond Code Camp 2009.1, will be held on Saturday 25, 2009 at the J. Sargeant Reynolds Community College in...
2009-04-15
636 reads
Starting Conversations - Part 2
A week or so ago I posted a note about reading How to Start a Conversation and Make Friends (worth...
2009-04-15
385 reads
Tax Day
A reminder of one of the downsides of working is today: Tax Day. In the US, income tax filing is...
2009-04-15
867 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