SQL Server Data Tools – Business Intelligence for Visual Studio 2012 Released!

SSDTBI for Visual Studio 2012 enables customers to use the Analysis Services, Integration Services, and Reporting Services project templates within the Visual Studio 2012 shell. Read more to get the download details.

The Year That Was – 2012

2012 was, simply stated, a year that kicked my butt.  When I wasn’t struggling professionally, I was struggling personally.  Health issues, culminating in a diagnosis of Type II diabetes, and the passing of my father soon after Thanksgiving marked my biggest struggles.  I apologize to those of you who are normally on my Christmas card [...]

SQLMag = SQL Server Pro. Goes all-digital!

I was recently chatting with Megan Keller, my long-time editor for the Tool Time column and Executive Editor at SQL Server Pro, DevProConnections, and SharePoint Pro.

Dev Advice: Make a Tiny Dev Database Act Like a HUGE Prod Database

If you’re struggling with doing development on a big SQL Server database, learn the ropes on cloned databases asap!

New on SQLMag Tool Time Blog – Update to FineBuild

Read about the latest update to FineBuild for SQL Server, a tool with speeds installation and configuration of SQL Server and associated utilities and programs.

Everybody Needs a Test Harness

Here’s a handy little block of T-SQL code to improve code stability.

What I’m Reading, July 22 2011

Kevin shares articles on BigData, Federal government IT and cloud computing, Microsoft research into data analytics and BigData, hashtags in social media, and max degrees of parallelism.

Microsoft Windows Platforms Blog Watch

Links to great Microsoft blogs and tool resources for networking, performance, and the Windows platform.

Is There Such a Thing as Easy ETL?

As soon as your data loading process involves some difficult or sophisticated cleansing or transformations, it gets really, really hard. I’ve found a cool, free tool – expressor studio – that shields your data integration application, with its associated business and transformation rules, from changes that might occur to underlying target or source files.

From SQLMag Tool Time Column: SSMS Plug-in News

I first wrote about Mladen Prajdic’s excellent tool in my Tool Time column at SQL Server Magazine