SQL Server Development Permissions

After setting up a new SQL Server instance for development I found the following permissions were needed extra permissions were...

TRY_CONVERT broken by WITH SCHEMABINDING in SQL Server 2012 Data Tools build

Here's a bug you might find if attempting to schemabind an object that uses the new TRY_CONVERT function.

To reproduce, run...

Consuming News Through Social Media and Read It Later With Pocket

These days the fastest way, not always the most accurate, to get news is through social media.  Technology, sports, politics,...

How I used Data Explorer to create a demo

Some time ago Data Explorer, an add-in for Excel 2010 or 2013, was released in Public Preview. In short, it...

How To Be An Expert At What You Do

Every successful company has them. They’re the lifeblood of their organisations. Linchpins essential to getting things done and doing them...

Laws You Break at Your Peril

Laws of Thermodynamics
TANSTAAFL
Gods of the Copybook Headings
All magic comes with a price
Winter Is Coming
My adult years started with a pretty...

Madison SQL Saturday (#SQLSat206) Coming Up

It’s coming up in just a couple weeks… the SQL Saturday in Madison, Wisconsin.  On April 6th, a couple hundred...

New SQLTreeo Version

We are glad to announce that new SQLTreeo SSMS Add-In was published.
List of new features/enhancements are following:
Local storage support...

PowerPoint–My Dashboard and Report Design Tool

At some point I think that I am becoming a Microsoft Office specialist as opposed to a BI Architect.  All...

PowerShell Usage in DBA Work – Case Study 5/7

One challenge in a super-multiple server (say a few hundred servers) environment is to know what sql services (SSRS/SSAS/SSIS/Engine/Agent etc)...