Today we’re going to continue our exploration of the server-level in PS. You’ll remember before we’ve explored it a little bit when we talked about querying cluster nodes.
So today we’re going to kill users in a DB. This [...]
OK, so a while back I wrote a post about how Oracle doensn’t build as much of a community as MS. And not only do I stand by it, but I’ve seen quite a few of the replies around the [...]
This post was particularly inspired while cleaning my house today. It’s easy, if you think you’ve got a clean house then just stand up on a ladder some time and change your perspective. I think you’ll find there are lots [...]
One of my big peeves is devs writing code to protect themselves against things that never happen.
You really see it all the time don’t you? And it always sounds so reasonable at the time, but it really isn’t if you [...]
Ok, not ‘no more’, but you guys should seriously limit your usage of select * for everything. I realize that it’s easier to support when you change the data requirement, but it pushes a lot more data than you need and [...]
As you know our other DBA just left and he just started his new job. I was IMing him today and asked him how it was going. He said, the last DBA was an idiot. It’s funny, cause I can’t count [...]
This is the perfect topic to go along with what I wrote on my other blog today in The real difference between SQL Server and Oracle.
The best database career advice you’ve never heard!
Become a DBA. Become a BETTER DBA. Use the Roadmap.
The DBA Roadmap Seminar is 7 MP3 tracks (over 5 hours!) of insider guidance on your database career. We'll teach you how and what to study as a DBA, weigh in on controversial resume debates, teach you to recognize a worthy recruiter, and discuss the new professionalism of interviews. Also some bonus materials, PDF companion guides, and really spiffy intro music!
Once your $99 PayPal payment is submitted, you'll get the download link in e-mail! (Download is a 370Mb ZIP file.)
Visit www.DBARoadmap.com for info, forums, and more!
Tags
Architecture blunders Camtasia Career Coding Standards CPU data generator DBA Development disaster firewall Idiots Inside SQL Server Interview ITBookworm Jobs Kalen Delaney Katmai Ken Henderson LiteSpeed MidnightDBA PASS Summit 2011 Pinnacle politics Powershell Powershell Hero Query techniques Red-Gate reporting restore SQL Express 1433 SCM SQL Server SQLServerDVD.com SSIS SSRS Training troubleshooting TSQL Tuesday tuning Tutorials Video post videos YukonInterview: Kalen Delaney!
Archives
ITBookworm.com!- Reading: Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions by Itzik Ben-Gan
- Repost: “Problems with my new book” by Grant Fritchey
- Announcing SQL Server 2012 Query Performance Tuning by Grant Fritchey
- Quick Review: Logitech Trackball
- Book Review: Microsoft SQL Server 2008 Internals, by Kalen DeLaney et al





