Omaha SQL Saturday and Friday Pre-Cons

In less than one month, the Omaha SQL/BI User Group will be hosting three all-day pre-con sessions on Friday, August 14th, with an all-day SQL Saturday conference to follow on Saturday, August 15th. Please join us on Friday in one of three sessions: Ed Leighton-Dick: SQL Server Security Master Class Mike Fal: Introduction to Powershell […]

Read more
MVP Davide Mauri creates SSIS Dashboard

For those SSIS customers looking to add a 3rd party dashboard to monitor their SSIS executions, fellow MVP Davide Mauri has written one that you can try out at no cost. Take a look here for more information: https://github.com/yorek/ssis-dashboard Davide also has a working demo: http://ssis-dashboard.azurewebsites.net/

Read more
SSIS vNext: Survey Opportunity to Shape the Future

If you’ve wanted to influence the future direction, now is the best chance to get your thoughts heard. Microsoft has a survey available for you to fill out, with which your feedback will be used to help shape the future of the product. Please fill it out, and use the comment boxes to fully capture […]

Read more
SCOM 2012 R2 – Specified Cast Is Not Valid Error – Run As Accounts

NOTE: SCOM 2012 R2 Update Rollup 5 addresses this issue. See http://support.microsoft.com/kb/3023138 for more details. It turns out that in System Center Operations Manager 2012 R2 (SCOM 2012 R2), there is a pretty nasty, but well documented bug that causes corruption and the following error: After clicking OK a few times, you can attempt to […]

Read more
MAP Toolkit – Connecting to LocalDB

When installing the Microsoft Assessment and Planning (MAP) Toolkit (commonly used for licensing renewal discussions and migration planning), one of the options is to have the tool use the new SQL Server Express LocalDB database container. Because this isn’t a normal SQL service, you may find it a bit challenging to connect to this database […]

Read more
SQL Server Data Tools (SSDT) announced for Visual Studio 2012

Fresh off of the press, Microsoft has announced the availability of SSDT for Visual Studio 2012. This means you can now build SSRS, SSAS, and SSIS BI projects within Visual Studio 2012, allowing you to abandon VS 2010 for SQL 2012 BI work. For more details see the official announcement here. You can download the […]

Read more
SSIS 2012 – Catalog Indexing Recommendations

2013-11-26 – UPDATE – SQL Server 2012 CU 7 -or- SQL Server 2012 SP1 CU4 addresses the indexing recommendations. See KB 2829948 for more details. I’ve been sitting on this content for about a year now, and due to external pressure (Thanks Matthew!) I’ve decided to put this into writing. One of the reasons I’ve […]

Read more