Interesting Case of SSIS Failures
Interesting Case of SSIS Failures
We had an interesting case of SSIS failures recently where the cause ended up being improved...
2010-06-10
1,053 reads
Robert Davis
- Interests: Poker, computers, reading/writing horror fiction
T-SQL Tuesday # 07: Walkthrough for Sysprep in SQL Server 2008 R2
T-SQL Tuesday # 07: Walkthrough for Sysprep in SQL Server 2008 R2
This blog entry is participating in T-SQL Tuesday #007, hosted...
2010-06-08
4,899 reads
Taking A Medical Approach to Performance Troubleshooting
Taking a Medical Approach to Performance Troubleshooting
I find it difficult sometimes to explain to someone how to have a take...
2010-05-31
2,640 reads
Are you a DBA? You might Be!
Are you a DBA? You might Be!
On Twitter, people do a lot more than gossip and post messages about mundane,...
2010-05-29
2,508 reads
Study Tips for the SQL MCM Exams
Study Tips for the SQL MCM Exams
I met the new rotation of the SQL Server Certified Master program on Friday....
2010-05-16
2,119 reads
Database Mirroring FAQ: Is Mirroring Supported by MS Access front-end?
Question: Is Mirroring Supported by MS Access front-end?
The following question was posted on a SQL Server discussion group. My reply...
2010-05-07
2,301 reads
The Toilet Analogy … or Why I Never Recommend Increasing Worker Threads
The Toilet Analogy … or Why I Never Recommend Increasing Worker Threads
Lately I’ve noticed an increasing number of people recommend increasing...
2010-05-07
6,242 reads
A Few Updates on the MCM: Plaques, Visitors, New Class, and New MCM’s
A Few Updates on the MCM: Plaques, Visitors, New Class, and New MCM’s
I just want to pass along a few...
2010-05-01
1,157 reads
Undocumented Capabilities of Extended Event Objects
Undocumented Capabilities of Extended Event Objects
The extended event objects (objects exposed by an event package) are listed in the system...
2010-04-28
2,162 reads
Looking forward to Optimize for Ad hoc Workloads in Sql Server 2008
Looking forward to Optimize for Ad hoc Workloads in Sql Server 2008
One of the features of SQL Server 2008 that...
2010-04-23
3,211 reads
Blogs
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
Have a Plan for Your Personal Downtime
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Forums
Resolving Access Denied Errors During SQL Server Database Attachment
Comments posted to this topic are about the item Resolving Access Denied Errors During...
The Lesser Used Functions
Comments posted to this topic are about the item The Lesser Used Functions
SQL in an Azure VM Backup
Comments posted to this topic are about the item SQL in an Azure VM...
Question of the Day
SQL in an Azure VM Backup
If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)
See possible answers