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

SQL Server 2014 – Delayed Durability

Pop quiz: What does ACID stand for?
That should be a pretty easy question for database professionals:
AtomicityConsistencyIsolationDurabilityIt’s that last property, durability,...

Table Hierarchy updated

Recently a need resurfaced to explore the foreign key tree (hierarchy/genealogy) as it related to a specific table within a...