During a recent development and testing session of SQL Agent Insight, connections to my local SQL test instances were taking over 10 minutes to connect, regardless of the version or edition, and to be honest, it was pissing me off.
Hey Folks, I wanted to keep everyone up-to-date with the planned changes that are coming to version 0.17 of SQL Agent Insight (see below), letting you know that the product is still actively being developed. I’m hoping to release 0.17
After the successful installation of SQL Server 2016 Developer Edition (which is now free), you are more than likely going to want to install SSMS to manage the recently installed instance. You can get the latest build of SSMS here.
Recently I had to do some maintenance on an EqualLogic PS6210XS array in which I had to connect to the serial port on the back of the device. After plugging in the USB-Serial adapter, firing up PuTTY, I was shocked
Recently I had to do some performance tuning for a client and needed to see which indexes in a specific database were missing to validate a problem query that was taking too long to execute. The following script assisted in that
The built-in procedure sp_spaceused can provide some useful information, especially when an object name is specified; great for showing the finer details of that object.
Here’s an issue that stumped me for a few hours, and finally, the problem has been resolved! The end goal was to display the entire contents of the SQL agent log in a datagridview (dgv) control. While getting the data
Well, here is an odd error message that had me looking in the wrong direction for a few minutes. While attempting to resolve an asynchronous database mirroring issue on a SQL Server 2012 Enterprise instance running on Windows 2008 R2
The following script when run on your SQL Server instance will show all schedules that are disabled but more importantly will show those schedules that have jobs associated with them.
Brentec has revamped its blog site using something a little more current and relevant, WordPress.