Midnight DBA

Happy Pi day! We talked about geekdom for all, ORMs and their LEVEL of crappiness, code that makes Jen angry, and much more.

Here Jen explains what a stored procedure is, and how to create a basic one with no parameters. She also compares it with other objects stored in the DB.

On DBAs@Midnight tonight we talked out when you would separate databases into instances or VMs. Cindy Gross gets arrested for a good cause in Idaho. @Kleegeek gets our new No-Suck Seal of Approval (TM). We learn TRULY fascinating things about Duolingo, and pit big shops against small.

The little brouhahas about PASS sessions have already begun. We talk about a delicious dish: tongue! And more on Itzik's APPLY course, Powershell tips, defining simplicity, and more.

We sing a special love song! And discover that Sean is the perfect Vday hubby...who knew? Sean reviews a slasher movie, we discuss troubleshooting code and a columnstore solution. The Powershell shipping requirements, the Strata conference, and many, many other things.

Tonight we got a huge compliment on our DBARoadmap, we showed off Sean's new 4-monitor setup, we had an SP debate, gave a Powershell tip, and finished up with a big talk about feeling the fraud.

Tonight we got a huge compliment on our DBARoadmap, we showed off Sean's new 4-monitor setup, we had an SP debate, gave a Powershell tip, and finished up with a big talk about feeling the fraud.

Tonight we talked Bitcoin and money laundering, what 'industry leading' really doesn't mean, Net Neutrality's repeal, Engineer Barbie, and more!

This week, Sean's new Windows phone won't let him swear. Other than that, it's working out well! Also: recruiter email fail, yak shaving, a Dropbox rant, building schools in Haiti, a weird LIKE problem, and our thoughts on XML.

This week we had a bit of news and fluffery, and then Denny Cherry chatted with us on Skype about his new book, "The Basics of Digital Privacy". And strange to say, we actually had plenty of tech stuff to talk about from work...go figure!

It's the day after Thanksgiving! So, we talk about Thanksgiving! And by sheer coincidence, present two skits about our dear, dear mothers. Sean makes a valiant attempt to keep the show rated 'IT', and we wander around aimlessly in a fog of turkey-induced lethargy.

We had a BIG discussion on privacy vs BI for the masses. Sean took us on a tour of interesting resumes. And we covered Jen's opinion on what candidates should know about a company. Of course, Sean and Freddie agree with Jen. Why wouldn't they?

This week we have a bit of Teen Time, an episode of On the Phone, a RANT, and some techie talk: managed backups, delayed durability, and weird problems with snapshot replication. This episode is well padded with good old fashioned fluffery!

There's a new MCM in town, and oh yeah, it's also PASS week.

We cover spanking clients, reading error messages, and we have a rant on java as well as a new episode of Superfan.

This week we had a story about a man who needs more Microsofts. We blew someone's mind with Powershell. Two skits. Favorite author and speaker interviews. An SSPI error that wasn't Kerberos. And we remember Ken Henderson. Microsoft-Microsoft-Microsoft.

Most of this week's show is entirely taken up by the very strange, almost calamitous adventure that was Sean going to get our brand new mic. Call this one a study in the bizarre. Also starring: Hanlon's Razor, consluting, amazing new tech breakthroughs.

We're back after skipping a week, and we discovered that Sean and Jen share a psychic link regarding LOGSPACE. We dodge busses, talk about Powershell weaknesses in SQL Server, announce THREE upcoming SQL books, and we have a new bit called "On the Phone".

We actually had some GOOD news in the world.

We announce Allan's new book (presale), frustrations, new awesome laptops, and we had a BIG techie discussion about one of Sean's Powershell videos (Script SQL Objects with Powerhsell, Advanced - http://t.co/IPifZW2MU5).

We were live from SQL Saturday Oklahoma this week! Ben Affleck is the new Batman, we give the first Nut Up or Shut Up award...oh yeah, and we also found time to talk some SQL.

Season five! Season five! Season five! We're delighted and enthralled and unfocused, just like the last four seasons! We have a new skit, gave an award to the NSA itself, and....well, take a look and see. SEASON FIVE, BABY!

We had a big discussion on WIT with a call from SirSQL. We also talked about a good way to get your entire team on the same page about their goals. It can also go a great way to seeing why everybody's not on the same page. Overall a pretty good show.

We have a new intern! News included NSA and mind-blowing technology. Jen finds a psychic tech product, Sean's ex-co-worker has very strong opinions. Companies don't take maintenance into account, like, ever. We had a good talk on schemas and when to use them.

Jen's been consluting for a year now, Sean's impressed with the telecom stuff at work, and we discuss some ideas for a show mascot. The Tech Tip is on Powershell, Jen is unhappy with Idera's auditing tool, but adores printing from her phone.

Today we had a minor interview embarassment, proper punishments for IT sins, and a positive job leaving experience.Jen gave the weather report, and Sean talks about someone WHO IS EFFECTIVE AT HIS JOB. Weird. Tech tip: Relog. Sean interviewed level 8 wizard. No, he was an 8 at wizards.Jen praises Idera support.

On the show tonight, we talk have an interview skit, a talk about forced cluster disasters, messing with developers, and a lot of mentions of TV shows that replaced actors without explanations. Weird.

Tonight we had 'ultimate' news, a mild production disaster story, degrees of DBAs, and a Powershell tech tip. We had a simply lovely talk about workplace discrimination. Sean tells us about an UPGRADE OR DIE policy. A solid, solid show!

This was a big shw! We had a resume review, an interview skit, a visit from ItsNic, talks about filling drive space and being effective and lazy at the same time. Big, big show.

This was a big shw! We had a resume review, an interview skit, a visit from ItsNic, talks about filling drive space and being effective and lazy at the same time. Big, big show.

In this episode we have production hijinks, a review of Sean's Trainsignal course, and some interesting info about Bit.ly. Jen tells us why we should care about CISPA (and what to do). And we have a real live resume review! The tech tip was on Powershell object properties.

We talked about the importance of attribution, and the perfect techie house. Sean says you should check out Kendal Van Dyke's SQL Power Doc. And we had a recruiter skit, and discussed what makes you work harder.

Tonight we held a brief memorial for a fallen fellow, Alan Weber (@aauugold). We also talked about cycling error logs, a stuck replication database, handling your business the way you should, and autogrow. Tech tip was on 1NF (atomicity), and we had an interview skit! AauuuuuGOLD!

This week we talk about what would happen if you ran your life like Sean's last company ran IT. And I believe we also do gross bathrooms at work, and even managed to throw in some techie stuff.

This week we have a big collection of end user mistakes, stupid vendors, chewing out DBAs, and more. Oh, and we unveil our newest award.

We've decided to become a kinder, gentler show. We're no longer going to be sarcastic, hurtful, or unsupportive... for this show anyway. This is going to be a fun ride.

I heard someone today say that you can't change startup parameters in Powershell. So I made this vid to set the record straight.

Today I'm dropping tables based off of a regex expression and by rowcount. Good stuff here. The power of the shell shines through with the easy regex expression.

Here I show you how to truncate a mass of tables in the same schema. Of course, you don't have to limit it to a single schema if you don't want.

I love making vids on the trickier stuff and this one is it. Here we're talking about duplicating sp_configure in Powershell. It's pretty easy, but there's a trick to it.

Here I show you how to turn off AutoShrink on a DB and then how to make sure it's turned off on all your DBs.

Here we're finding the root install directory for SQL Server.

This continues the series on detach/attach for DBs. Along the way I show you how to deal with a powershell provider bug, work with the stringCollection object, and use all 4 overloads for the AttachDatabase method.

Detaching DBs in Powershell is pretty easy, which is why you should learn how to do it. It takes less typing than the t-sql version. However, there are also methods for discovering which files belong to the DB that was detached and that can be invaluable when you're trying to attach a DB on a big server and you don't know where all the files may be.

Getting IP address and DNS info from your servers in a useful format isn't as straightforward as you would think. Here I'm going to show you how to get that info painlessly and in a way you can use for all your automated processes.

Changing object schemas is easy enough in T-SQL when it's a single object, but it get considerably more complicated when you've got several objects to change, or even several thousand. This is where Powershell comes in. Here I show you how to very easily change the schema of as many objects as you like in just a few seconds. And I throw in some regex in there for good measure. Let's have some fun.

Here I show you how to change permissions in SQL Server using Powershell. There are 2 methods I discuss and I even show you some of the problems you can run into. This is the 1st in a series so be sure to watch the 2nd one too. In This video I also reference a couple other vids. Those are here:<br><a href = "http://midnightdba.itbookworm.com/VidPages/PowershellScriptDBObjects/PowershellScriptDBObjects.aspx">Scripting DB Objects in Powershell (Advanced Topics)</a><br> <a href = "http://midnightdba.itbookworm.com/VidPages/PowershellCycleErrorLog/PowershellCycleErrorLog.aspx">Cycle Error Log on all Servers using Powershell</a>

Continuing from the 1st video, here I show you how to capture useful errors from the method call. I explain how to Trap the errors and loop through InnerException to make sure you get all of them. If you saw the last vid, you can't miss this one.

Would you like to work with the SQL Server error logs in Powershell? Well here I'm gonna show you how. Not only do we pull in the current log, but I also show you how to get all of the historical logs for all the instances on the server as well. Good stuff.

Here I show you how to use the Carrier Method for using powershell to cycle all your error logs. This is an excellent way to get started using powershell, and I use it even though I know it fairly well.