Seeks Aren’t Always Better Than Scans
So I was doing a little performance tuning of a query for a company recently and we were getting hammered on the IO for the query. The query was in a stored procedure which wasn’t all that complex (ignore the crap code for now). ALTER PROCEDURE [dbo].[iu] ( @p uniqueidentifier, @as int, @t datetime ) […]
SQL PASS 2013 Webcast Recording
The SQL PASS 2013 Webcast Recording which I did today is available for download and viewing. It’ll be viewable in Windows Media Player. You may need to download and install the GoTo Meeting Codec. This video is sponsored by Denny Cherry & Associates Consulting Thanks, Denny
SQL PASS Summit 2013 1st Timers Webcast is TODAY!
Just a reminder that TODAY is my SQL PASS Summit 1st Times Webcast for the 2013 PASS Summit. The webcast is at 1pm PST / 4pm EST. I’ll be using GoToMeeting this year, and the URL for the webcast is https://attendee.gotowebinar.com/register/4906797491661003009 (THIS URL HAS BEEN CHANGED). Just sign in at the meeting time (or just before) […]
SSL VPNs and Certificates
I end up VPNing into a lot of different companies networks, and the thing that I see that always kills me is when I VPN I’m given an SSL URL to connect to in order to get connected, but before the site appears I get a security warning that the SSL certificate isn’t trusted for […]