You’re transaction log files are a mess. You don’t think so, but it’s true. Too many times I have seen transaction logs treated without care; they are placed on the same disk drives as the data files or they are placed on drives not optimized for write activity. I have even seen admins who fail … Read more
Last weekend Karen Lopez (blog | @datachick) and I did a session together at SQL Saturday #159 in Kansas City titled Database Design Throwdown: The Trailer. The reason we called it “The Trailer” is because we are giving people a sneak peek as to what topics we will be covering when we present this session together at the … Read more
It’s going on midnight here so I wanted to share some advice I have for anyone on the overnight shift: You *do* have backups, right?
“Trust [everyone], but always cut the deck.” – Gerald Weinberg Whenever I come across a piece of technical information on the internet I try to remember two things. The first is assume good intentions. The second is trust, but verify. In other words, don’t assume that the person sharing the information is doing so for any other … Read more
Came across this video today and I wanted to share it here. Not sure about you but this video is painfully familiar to me. End users always want more data. They often have no idea what they are looking for. Many are just hoping to come across some nugget of gold in a huge pile … Read more
Last week I had the honor of presenting at TechEd Europe a session titled “Deploying Microsoft SQL Server 2012 Using Windows Server Core“. Presenting that session gave me the opportunity to learn about administering SQL server using PowerShell, specifically how to administer an instance of SQL Server running on Server Core (PRO TIP: it’s the … Read more
