THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
IT Horror Stories
SQL Server 2012
Top 10 DBA Mistakes on SQL Server. (Now with Prizes for Participation!)
The first big mistake I made as a DBA was coming to work with my zipper wide open. But I digress.Hear one of my most popular session via streaming media at SQLSentry.TV!Microsoft SQL Server is easier to administrate than any other relational database on the market. But “easier than everyone else” doesn’t mean it’s easy. And it doesn’t ...
April 9, 2014
Learn More About SQL Server IO and Query Tuning in These Webcasts
I'm doing two new webcasts next week on Wednesday, December 19th, one in the morning and the other after lunch. SSDs are a Game Changer for SQL Server Storage No, session is not exclusively about SSDs. But this is my first session on IO and storage tuning that emphasizes SSDs over hard disks. As Bob Dylan said ''Times, they ...
December 14, 2012
Quick Tip - Speed a Slow Restore from the Transaction Log
Here's a quick tip for you:During some restore operations on Microsoft SQL Server, the transaction log redo step might be taking an unusually long time. Depending somewhat on the version and edition of SQL Server you've installed, you may be able to increase performance by tinkering with the readahead performance for the redo operations. ...
November 14, 2012
Brought to you by