Blog Archives

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

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