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

Posts Tagged ‘T-SQL’

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

Free Training from PASS Virtual Chapters

We’ve got some great free training coming up this week from the AppDev and DBA Virtual Chapters of PASS.  I personally am really looking forward to “SQL Server Consolidation: How to decide on the right approach (between DB, VMs, Instance)?”  It sounds like a really good session to me   Please note that the “Defensive [...]

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