Currently viewing the tag: "Powershell"
I was helping someone out with something so I thought you guys would like to have these 2 short lines of code that can be pretty useful. Here I’m going to show you how to check your DB for tables that [...]
When I teach powershell the question I get from DBAs most often is what is an overload. Because when we get into methods you can’t go very long at all without stating that they’re overloaded and most DBAs just don’t live [...]
One of the biggest battles I fight when I teach PS or show it to different companies is adoption. DBAs and managers just don’t get why they should be using PS to manage their environments. And the reason so many of [...]
Ok, well I’ve been very busy again and released 3 new PS vids today.
There’s one on dropping tables. I use regex to make this happen, so even if you’re not interested in dropping tables, you can come learn how to [...]
Here’s another vid. This one is on working with detach in PS.
http://midnightdba.itbookworm.com/VidPages/PowershellDetachMethods/PowershellDetachMethods.aspx
Hey guys, I posted a new video last night on how to get IP and DNS info from your servers. I know there are more ways to do it so if you guys have a way you like better send it [...]
I’ve been a busy little guy this week. I’ve posted 4 new videos.
The first one is on cycling the SQL error log from Powershell. Well, not really, you’re really deploying the solution to other boxes using Powershell.
You can see [...]
I read a blog today from my good friend @SirSQL (Nic Cain) where he was talking about how to change retry attempts on all the jobs on a server. Well, technically it’s the job steps that have [...]
About 3mos ago I had my work box rebuilt. The encryption software glitched and it just wouldn’t boot. So the helpdesk girl was able to slave the drive to another box and copy my files to a NAS. I looked and [...]
I got a request today to compare 2 DBs and see if they’ve got all the same tables. It seemed easy enough since I’ve got the redgate Schema Compare tool, but it actually isn’t. See, for some reason Schema Compare doesn’t [...]
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!
SQL Cruise with me…
We'll be on the January 2013 cruise to the Bahamas, teaching and learning SQL and having a GRAND time after hours...all for the less money than a week of "normal" SQL training. Join us!
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
