SSRS reports in SharePoint mode, Saga #2: PowerShell generates email subscriptions

Life is full of opportunities, it only takes to notice and use them. About 3 months ago I wrote a...

Free SQL Training In Sacramento

In a few short days the newest SQL Saturday event.  This one will be on the far West coast of the United States. This marks the first time for...

Free SQL Training In Sacramento

In a few short days the newest SQL Saturday event.  This one will be on the far West coast of...

Editorial: Cloud Skills

Cloud Skills is the editorial today, thinking about the changes we see in the boxed product versus the cloud and...

T-SQL Window Functions – Part 3: Aggregate Functions

This is a reprint with some revisions of a series I originally published on LessThanDot. You can find the links...

Last Weeks Top “Reading” Links #91

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

How to change TempDB system Database files location?

Steps to change TempDB system Database files location :- 1) Check current file location of TempDB Exec SP_helpDB TempDB You can use below query as well for file location...

Project Moriarty

This past weekend I started writing notes for what I’m calling Project Moriarty, what I hope will be five questions...

SQL Server Quickie #15 – Merge Join Operator

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...

How to change TempDB system Database files location?

Steps to change TempDB system Database files location :-
1) Check current file location of TempDB
Exec SP_helpDB TempDB

You can use below...