SQL Server Reporting Services 2016 Unplugged

Definitely excited about the new features and, in general, about Microsoft’s commitment to improving their BI stack.  http://m.demo.sqlmag.com/reporting/reporting-services-2016-unplugged Advertisements

Posted in Uncategorized

Customizing SQL Server Management Studio (SSMS)

Here are the customization changes I make when setting up SSMS. You can find all of these settings by going to Tools, then Options… Environment > Keyboard > Keyboard This is a safety issue…unprogram Ctrl+E and Alt+X as shortcuts for executing a query. I use F5

Posted in Uncategorized

SSIS Send Mail Task does not support HTML as a message format

I do not use the SSIS Send Mail Task often and either never noticed, noticed and forgot, or never actually needed it myself but this topic came up on a Forum earlier and it caught me off-guard. SSIS has been around

Posted in SSIS

Importing data in a MySQL database into a SQL Server database

Let me start by saying this did not turn out to be as easy as I originally thought. I started with a giant assumption that I think many may have in the past: With SSIS, Microsoft’s integration tool shipped with

Tagged with: , ,
Posted in SQL Server, SSIS

Implement explicit installation and uninstallation options for xp_cmdshell

Implement explicit installation and uninstallation options for xp_cmdshell Up-vote this Connect item if you would like to be able to control the availability of xp_cmdshell on your instances more than simply enabling or disabling it via sp_configure.

Tagged with: ,
Posted in Uncategorized

SQL Training

I had the pleasure of attending a 5 day SQL Server 2012 Internals and Query Tuning class led by Kalen Delaney the week before last. I had a head start going into the class because I had already read SQL

Tagged with: ,
Posted in Uncategorized

Article Published on SQL Server Central

My sixth article was published on SQLServerCentral.com yesterday: Loginless Database Users and Dynamic SQL

Posted in Uncategorized