SQLvariations: SQL Server, a little PowerShell, maybe some Hyper-V Rotating Header Image

Posts under ‘T-SQL’

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 [...]

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 [...]

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 [...]

Get Adobe Flash playerPlugin by wpburn.com wordpress themes