Denial of Service Attack on SSRS?

SSRS 2014 limits the number of simultaneous connections from one user to prevent DDoS, and confuse me… Continue reading

SQL Jobs Writing to the Event Log

Here’s a little tool that can update all SQL Jobs on one or more servers to make sure they send notifications to the event log if they’re not already configured to do so. Continue reading

Thoughts on PowerShell and Installing SQL Server

What I learned from working with PowerShell in-depth for the first time to automate the installation and configuration of SQL Server 2014 Continue reading

Encrypt SQL Server Connections

How to create and configure a self-signed certificate for use in testing SSL encrypted connections to SQL Server Continue reading

Matrix in a Matrix

How you can use a tablix within a tablix to create a contact list report that is clean and flexible. Continue reading

Why Won’t my Toolbar Customizations Stick in SSMS 2012?

After upgrading SQL Server Management Studio to 2012 my toolbar customizations would not stick. Argh. Turns out the fix is simple… Continue reading