Virtual Presentation on SSIS Workload Thread Load Balancing
How is it possible to aggregate 12,000,000 records of sales data in a short time window? In this presentation you...
2010-01-08
1,167 reads
Blog Posts
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
418 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,718 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,347 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,004 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,579 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,143 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
326 reads
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
611 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers