The other day I was answering a question in the forums on PowerGUI.org that I thought would be a quick answer. The only problem was that I had my T-SQL hammer in my hand and not my PowerShell hammer. When I read the question I thought of a way to solve the problem using T-SQL [...]
Posts under ‘Code’
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 [...]
Get-Sales | Out-Map = T-SQL Tuesday #005 – Reporting
For this month’s T-SQL Tuesday I thought I’d go with something useful that I’ve been meaning to blog about for weeks now. While listening to the PowerScripting Podcast a few month’s back I heard about a product that sounded really cool for simple data visualization and quickly showing people just how powerful PowerShell is. Now [...]
Checking Disk Space with PowerShell
This is another one of the code examples that I did in my PowerShell for Data Professionals session last week. If you give it your computer name and then run it you will get back a stream or properties like I mentioned during the session. get-wmiobject -query ` “Select DeviceID,Size,Freespace from Win32_logicaldisk where drivetype=3″ ` [...]
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 [...]
SQLServer:\SQL\Databases\Tables> Dir
Getting started talking to your SQL Servers in the PowerShell 2.0 ISE By now hopefully you’ve noticed that SQL Server 2008 comes with PowerShell all over the place. Just about anything you click on in Object Explorer has “Start PowerShell” and you can even execute PowerShell steps in SQL Agent Jobs. You may be wondering [...]
Filtered Indexes: The Conversation
A few months back as one of my very first blog posts I showed off some functionality that I had learned in Bruce Payette’s book “PowerShell In Action” (Coincidentally a new update to the MEAP for the Second Edition was released tonight). I showed how it was not too difficult to Archive the wisdom of [...]
Lunch-n-Learn #01: SQL Server 2005 Features
Yesterday I did a quick Lunch-n-Learn here at my company on a few SQL Server 2005 features and this post is just a follow-up to remind everyone what we saw and where you can find those features. I will try to still make this useful for those of you who didn’t attend. 0: To make [...]
T-SQL Tuesday #002 A Puzzling Situation: Max Server Memory
Today’s post about changing your Max Server Memory setting is to answer the call from Adam Machanic about Puzzling Situations . A couple weeks before I headed out to the 2009 PASS Summit I encountered a puzzler of my own. One of our servers issued an alert that it had an extremely low Page Life Expectancy [...]
T-SQL Tuesday Date, Time, tricks with the DateTime Data Type
Adam Machanic told us all about a new craze sweeping the SQL Blogosphere Nation last week and that is T-SQL Tuesdays. Real quick, the way it works is that on Patch-Tuesday everyone who’s got something to say about the topic of the month releases a blog post about it and the “Host” of the topic [...]
