Well, I finally joined Slideshare. Here are the slides from my most recent presentation (Database Design, Size DOES Matter!) to the SQL Server User Group in Reno, Nevada last week: I’m going to see about pushing many of my presentations to Slideshare in the coming months. I like the idea of Slideshare, just not sure … Read more
Last week I was reminded that opinions are split as to whether or not installing the database client tools (SSMS, Database Control, etc.) onto database servers is a good idea or not. I’ve worked at companies where the installation of such tools was discouraged. I’ve also known companies where the installation of tools is mandatory. … Read more
Are you afraid of deploying (or supporting) an instance of Windows Server Core? Are you telling others to “stay away” because of your own fears of doing something new? Then I am here to tell you that you’re doing it wrong. Last month I decided that it was time to get down and dirty with … Read more
Yesterday I talked about the Accidental Architect. Today I want to add some additional thoughts. There is a reason why we end up gravitating towards careers as DBAs or architects: natural curiosity. We want to know how something works. We want to do our best to ensure that a system is built the right way … Read more
Most readers of this blog are likely to be familiar with the term accidental DBA. It is meant to describe someone that ended up in the role of database administration by pure chance. They simply happened to be in the right place at the right time (or right place at the wrong time). I even wrote a book … Read more
Parameter sniffing is an aspect of SQL Server that is typically viewed as a bad thing. The simple fact is that SQL Server uses parameter sniffing all the time, that’s how SQL Server works. It is only those times when parameter sniffing results in performance issues that people (naturally) complain. It’s a lot like lawyers. It only … Read more
