Have you lost your mind?! What could I possibly mean by that title? I’m a DBA… One of the basic tenets of a DBA is “backup, backup, backup”, right? Well sort of… Far too often I hear people asking questions like “will this setup allow our backups to be fast?”, “how is your backup process … Read more
Reading a blog this week, I learned quite a few new tips and tricks about SQL Server Management Studio. Incremental Serach (No annoying search window pop-up and searches as you type), replace within files from SSMS!!, Block Selects and Moves for the T-SQL Code formatting OCDers (like me). Check it out and add Aaron to … Read more
Adam Mechanic over on his blog has announced a code camp offered by Microsoft, and the New England and New Hampshire SQL Server User Groups. Looks like a great time of learning and the price is right
Updated [2016] This post continues to be a popular destination for searches like “How do I shrink a database?” I made some copy edits. I also wanted to reiterate a default position: It isn’t usually a good idea to shrink your SQL Server database. There are exceptions, but they are exceptions. This post is part 1 in a series … Read more
The SQL Server Customer Advisory Team has a great blog and they have a good article here about upgrading to 2008. Lot of reasons to upgrade to 2008 (especially if you are on SQL Server 2000 or earlier). Check it out; http://blogs.msdn.com/sqlcat/archive/2008/12/08/ultimate-guide-to-upgrading-to-sql-server-2008.aspx
Haven’t looked into all of the details underneath but at the surface probably a good reminder of where WITH RECOMPILE can be helpful… Using SQL Server Reporting Services, a workaround was used (this is the part I want to look into more) to basically get a blank report showing when a user first links to … Read more
Interesting Issue Today/Yesterday – A query was using a linked server to grab data from DB2 via an ODBC connection. Normal execution time is about 15 minutes. This had run on for at least 7 hours when it was decided to kill it, appeared to be doing nothing but causing blocks (due to Intent Shared … Read more