More Thoughts on Certification
After a great response to my last post on Certification, I need to post my thoughts on 70-450 PRO: Designing,...
2010-03-22
580 reads
Blog Posts
PASS BI Virtual Chapter
Did you know that PASS has virtual chapters, allowing members to participate in virtual meetings that are geographically agnostic? One...
2010-03-22
1,222 reads
SP_SPACEUSED & SP_MSTABLESPACE
Take a look two SP inside the sys Procedure in SQL Server 2008 (included also in the SQL Server 2005),...
2010-03-22
4,549 reads
SSWUG Ultimate vConference Discount Code
The SSWUG Ultimate Virtual Conference is coming up on April 7, 8, and 9th. This is three days of very...
2010-03-22
833 reads
Why UniqueIdentifier is a Bad Choice for a Clustered Index in SQL Server
I had a question today about why it was “bad” to use a UniqueIdentifier as the data type for a...
2010-03-22
9,364 reads
I’ve Moved and So Should You
After blogging on Live Spaces for a couple of years, I’ve made the difficult decision to move to my own...
2010-03-21
522 reads
Improve Performance and Take a peak, at SafePeak for SQL Server
There's an exciting new product on the market, and Pearl Knows is in on the ground floor, and wanted to share.
If...
2010-03-21
679 reads
Info about Maximum specifications for SQL Server 2008/2005
A quick info where you can find the Maximum specification for SQL Server 2008/2005 (32 bit & 64 bit).
SQL Server 2008...
2010-03-21
1,253 reads
Report Recipe Book Released
Our SQL Server Reporting Services Recipe book was released in April. This is
a cookbook style book for experienced SSRS designers...
2010-03-21
543 reads
Script: Transaction Log Backup
My last post showed a little script that I use for taking full backups of all my databases on an...
2010-03-21
7,801 reads
Blogs
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Forums
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries