SSC Syndication
Steve Jones at SqlServerCentral.com has created a Blog for me over there at SqlServerCentral.com. I will be syndicated there and...
2010-01-07
609 reads
How to Read the Results of SELECT @@VERSION in SQL Server
The simple query SELECT @@VERSION can quickly tell you quite a bit about a SQL Server installation (and the underlying...
2010-01-07
4,135 reads
Handling Database Mirror Failover within an SSIS Package
Recently I was asked how to handle a Mirrored Database Failover within an SSIS package. For those of us that...
2010-01-07
2,577 reads
2009 PASS Summit Presentation Results
I opened my inbox Wednesday morning to find the evaluation results for my presentation on Transactional Replication at the 2009...
2010-01-07
417 reads
Bad Default Database Leads to a Failed Login Attempt
Yesterday we had a user receiving the infamous failed login attempt error (no, that's not a valid IP):
Login failed for...
2010-01-07
1,715 reads
Book Review: SQL Server 2008 Query Performance Tuning Distilled
I recently finished reading the Apress book SQL Server 2008 Performance Tuning Distilled by Grant Fritchey and Sajal Dam. I...
2010-01-07
1,345 reads
Too Much Data – Idiocracy or Star Trek?
I used to think that too much data was never a bad thing. That having more information out there is...
2010-01-07
372 reads
Recharging
I was hoping that 4 days in the mountains would be a nice time to recharge. Unfortunately, with my wife...
2010-01-07
447 reads
Speaking at SQLSaturday #32 in Tampa on January 23, 1010
I’ll be heading to Tampa the afternoon of the 22nd for the speaker party, and then presenting Social and Not...
2010-01-07
325 reads
Error rsAccessDenied : The permissions granted to user 'Toma-PC\Toma' are insufficient for performing this operation.
In my problem of the day, I found this one out on the Microsoft Reporting Services Forum. I bumped my head...
2010-01-07
24,002 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