Browse the archive
Like most people, I’ve changed jobs a few times in my life. My path from teenage grocery store cashier to Database Architect was a complicated and multi-step journey. During that journey, I’ve made some good decisions, and some bad decisions. If you’re like …
Continue readingToday, my friend Derik Hammer (blog) asked about moving SSRS reports between (versions and) instances of SSRS: Derik Hammer@SQLHammer twitter What is the best way to move 2008 R2 SSRS reports into an existing 2012 SSRS instance? Catalog move is insufficient …
Continue readingA practical look at SQL Server’s COMPRESS() function and its use with large object data.
Continue readingShortcuts & tips from an Impatient DBA This series of short posts will demonstrate some lesser-known features, keyboard shortcuts, and other tips that make my day as a DBA more productive. None of these are groundbreaking super-secret features–they are the …
Continue readingQuestion In the good old days there was a shortcut ctrl-B for changing the size of the Query & Result panes in the Query Analyzer sql editor. In Query Analyzer, just press ctrl-B and the screen splitter handle was in focus. Then repeatedly press up/down …
Continue reading<img class=“alignright wp-image-532 size-full” src="/wp-content/uploads/TSQL2SDAY-300x300.png" width=“300” height=“300” / alt=“T-SQL Tuesday logo; links to the event video."> It’s T-SQL Tuesday, the blog party that SQL Server expert Adam Machanic (blog) …
Continue readingShrinking a SQL Server database is usually the wrong fix; learn when the rare exceptions may apply.
Continue readingSomeone posted to #sqlhelp on Twitter, asking the following: “Wondered if anyone could enlighten me as to why ISNUMERIC(‘7d8’) returns 1?” Sure enough, SELECT ISNUMERIC('7d8') returns a 1. WTF? d isn’t numeric! OK, sure, if you say “seven-dee-eight” out loud …
Continue readingThis week at work, I noticed CPU on one server seemed pretty high. I wasn’t familiar with this particular server, but based on the applications it supported, I was expecting the server to be under-utilized. I went over to vCenter to look at historical CPU …
Continue readingFor T-SQL Tuesday, I reflect on the SQL Server features I use and the ones I leave behind.
Continue reading
