Powershell in a Month Day 12 – A Practical Interlude

This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month...

PowerShell Remote Commands

This is something I've found useful here recently when I had a server acting up. It's a simple way to...

Reliably Drop A Database With CLR Stored Procedure

 
After I read Greg Low’s post and my initial try, I kept on thinking that I need to come up...

SSAS Reporting Action with Date Parameters

Reporting Actions in Analysis Services allows you to open a report in Reporting Services. Most of the time users want...

The “most_recent_sql_handle” column

While researching my last post I ran across an interesting column I hadn’t noticed before, sys.dm_exec_connections.most_recent_sql_handle. I mentioned it in...

Tip: Jobs without a scheduled run

It’s awfully comforting to see all those backup and maintenance jobs in your SQL Agent list, isn’t it? It’d be...

Using multiple CTEs in one query

This is a fairly simple thing to do, but I had to look it up the other day and thought...

Volunteers Needed For PASS SUMMIT

Last night I submitted my application to volunteer for the 2014 PASS Summit Program Committee.

Not know what PASS is? head...

Get Rid of These 5 T-SQL Bad Habits with SQL Prompt

We all have bad habits. Maybe we eat too many snacks, spend too much time on the couch watching TV,...

Power BI for Office 365 pricing announced

Pricing for Power BI for Office 365 has been announced (see pricing).

 
It’s all very confusing to me but Melissa Coates does a...