Profile cover photo
Profile photo
Brent Ozar
1,527 followers -
Microsoft Certified Master of SQL Server. Amateur of fun.
Microsoft Certified Master of SQL Server. Amateur of fun.

1,527 followers
About
Brent's posts

Post has attachment
Brent Ozar commented on a post on Blogger.
I haaaaate code in most sessions. This blog post about it is one of my favorites: https://bitquabit.com/post/why-how-is-boring-and-how-why-is-awesome/

It's not that code is universally bad, it's just that the basic code in most sessions doesn't really add much to the discussion. Backups are a great example - watching a database get backed up via code is probably one of the most boring things you could show. 10%...20%...30%... Whether you're doing that in the GUI or in code, it's gonna suck.

Now, showing trace flags or other undocumented tricks about backups, on the other hand, that's completely different.

Post has attachment

Post has attachment
Wanna play with the StackOverflow.com database in SQL Server form? I've got it up on BitTorrent: http://u.brentozar.com/StackOverflow201508.7z.torrent

I'll be blogging about it next week, just linking it here to let people talk about it early. It's a 9GB 7zip file that contains a 70GB SQL Server 2005 database, so it can be attached to any modern version of SQL Server, any edition (except, of course, Express due to the size.) It's the same database that I use in my T-SQL demos.

Post has attachment
Wanna see a module in @thedouglane’s new T-SQL course? Free, today only: http://www.brentozar.com/archive/2015/09/t-sql-level-up-date-and-number-tables-today-only Prepare to laugh and learn.

Post has attachment

Post has attachment

Post has attachment

Post has attachment

Post has attachment

Post has attachment
Wait while more posts are being loaded