BI on SQL Azure - Yes you can

Just 4 years before, it was not possible to have end to end Business Intelligence (BI) solution on SQL Azure....

Multi-Cursor Editing SQL feels like the movie Inception just became real

Yes… multicursor editing is epic No… SSMS doesn’t support multi-cursor editing the way it should. Yes… you can do some...

Automated Metadata Report for SSAS Tabular

There’s been an excellent free solution for documenting SSAS metadata in multi-dimensional models for quite some time: http://www.purplefrogsystems.com/blog/2010/09/olap-cube-documentation-in-ssrs-part-1/.
I had the...

Multi-Cursor Editing SQL feels like the movie Inception just became real

- Yes… multicursor editing is epic

- No… SSMS doesn’t support multi-cursor editing the way it should.
- Yes… you can do some...

Yes, Foreign Keys Help Performance

I created this example several years ago that illustrates how foreign key constraints can help performance. It’s a contrived example....

Custom Column in SQL Data Generator

One of the interesting things with Redgate’s SQL Data Generator (SDG) is that it allows the user of custom data...

The Poor Man’s SQL Backup Encryption - Syndication – WaterOx Consulting

Well, that was interesting While playing around with demos to use in my newer session, Hacking Exposé Too (See it...

PASS Summit 2015: Recommendations and Invitations (#sqlpass #Summit15)

The last week of October, we’ll be at the PASS Summit in Seattle, WA.  As some of you already know – and as I...

SQL Server 2014: parallel execution of SELECT INTO statements

In Microsoft SQL Server 2014 new in-memory options are presented. One of them is online transaction processing (OLTP) that complementing...

Extended Events Categories

Packages have a couple of descriptors (or classifiers) that can be useful to help figure out what events contained within that package might be related to other events.
Related Posts:

How...