Getting Started With PowerShell Variables Yesterday we laid the ground work for PowerShell Week. Today we will learn about Variables in PowerShell. You will notice that PowerShell variables work very differently from SQL Server variables. The evolution of variables in SQL Server is pretty straight forward. In SQL Server 2000 you had to DECLARE a variable as a [...]
Posts under ‘SQL Server’
I’ll Be Speaking at geekSpeak
Next week I am giving a PowerShell for Data Professionals session on MSDN’s geekSpeak. If you haven’t heard of geekSpeak all you really need to know is they have one primary rule for presenters:Your webcast is limited to only 1 Power Point slide. geekSpeak presentations focus on practical live examples and interactive question and answer sessions that allow you to learn from [...]
I’ll be speaking at CodeStock!
I’ll have more info for you guys later but this will be my first non-SQL-centric event that I will be speaking at so I just wanted to share I’m extra-excited about this event because this year they are making a push for Women In Technology. Here’s a snippet from that announcement: “This year we are [...]
T-SQL Tuesday #005 – Reporting – The Round-Up
Well I’d say this T-SQL Tuesday was a success. 33 people contributed blogs; and two people ended up with two different posts they wanted to submit. I would have had this round-up out sooner but trying to read 33 blog posts after work is a little much and terribly fun at the same time. The [...]
T-SQL Tuesday #005 – Reporting
Invitation for T-SQL Tuesday #005- Reporting Spring Break or not, time marches on and so does T-SQL Tuesday. I’ll be your host this month and we are going with “Reporting”. The Post must go live between 00:00:00 GMT on Tuesday the 13th of April and 00:00:00 GMT on Wednesday the 14th (also known as 8pm [...]
Coding for the Weekend
I’ve mentioned that my company is doing a data center move in the near future and I’ve been building out some PowerShell scripts to get ready for that. Before we get there though we are having to rebuild one of our test environments from the ground up. When I told my coworker Shyam of my [...]
SQL Saturday #33 PowerShell Slide Deck
I’ve posted a copy of my slide deck that I used for my PowerShell sessions at SQL Saturday #33 in Charlotte. Anyone is welcome to use all or part of it if they would like to do they’re own PowerShell session. I’d love to hear any suggestions for improving it. I’m working on getting all [...]
MacGyver Meets TSQL2sDay
Please be aware that I haven’t had a chance to double-check the technical details of this post before the deadline so if you see an error please feel free to comment about it. The events happened years ago but it’s funny how history has a way of repeating itself. Because I have too few hours [...]
Get More Done with SQLPSX
In my LiveMeeting session for the AppDev Virtual Chapter of PASS yesterday I talked about building on top of tools that others had already built for you to use. A great one for any DBA to use is the SQL PowerShell Extensions known as SQLPSX. Even if you’ve never used PowerShell before you should take [...]
How Big Were Last Nights Backups?
Last week one of the Sys Admin’s asked me “How big were last night’s backups?” I was like “Why are you asking me? We drop all of the backup files onto one of your arrays so why don’t you tell me.” Background: We’re doing a Data Center move and they wanted to move a copy of all [...]
