I found this question over at DBA StackExchange the other day and it left me shaking my head. How is it possible that there is no way to automatically recycle, or reset, the SQL Server Analysis Services (SSAS) error log in a similar manner to SQL Server? After all, it’s not like the technology doesn’t … Read more
Microsoft SQL Server comes with a boatload of additional components. One component is the SQL Agent service. The purpose of the SQL Agent is to serve as a job scheduler. Many experienced DBAs use jobs running inside the SQL Agent to perform routine tasks such as backups, updating statistics, and rebuilding indexes as needed. While the … Read more
No one sets out to become a DBA. Nobody. Well, there was that one kid who wanted to be our summer intern, but I’m fairly certain he was just saying that to get a job at the time. Truth be told, I did want to be a DBA. But that was only after having been a … Read more
Just a quick post for some Friday fun. If you want to know how to do database mirroring right, start with this MSDN link: http://msdn.microsoft.com/en-us/library/ms189852.aspx And if you are thinking of buying yourself a nice book on Christmas on database mirroring, I’d recommend this one: Pro SQL Server 2008 Mirroring
Tomorrow I fly West to Seattle, heading to the Microsoft MVP Summit for Sunday and Monday followed by the PASS Summit on Tuesday through Friday. I usually try to write some type of Summit preview post but time was short this year. Instead I decided to share something else with you, and that’s a specific … Read more
A while back I wrote a post on the five database design mistakes you don’t want to make. I always meant to build slides for the post but never seemed to have the time. I finally found a few odd moments here and there over the past few weeks and got a deck uploaded to … Read more
