Rotating Header Image

Posts under ‘Benchmark IT Consulting’

And the Emmy Award Goes To……

Yup…. Something I didn’t know was even on my bucket list just got crossed off (that’s how bucket lists work right? lol). I won an Emmy Award! (OK so it wasn’t just me that won an Emmy but the company that I contract out to) Invidi Technologies won an Emmy for “System for Executing Targeted […]

Just Keep Googling, Just Keep Googling…. SQL Agent Job Scheduling (Past and Future)

So I needed a script where I could provide a start and end date that could go into the past and into the future to determine all the job schedule executions that should have or will happen between the given dates. I found bupkis My Google-Fu was weak and couldn’t find anything so I pinged […]

Hey #SQLFamily Where Do You Go?

OK so this video came out like 7 years ago which is pretty well how long it’s been since I’ve blogged. I miss blogging and the #SQLCommunity #SQLFamily #SQLHelp #SQLPASS…. basically all the hashtags that have anything/everything to do with SQL. I turned on Tweetdeck for the first time in a LONG time and said […]

Do You Even Blog Bro? (Stats, Execution Plans, Indexes, and crazyness)

Have you ever worked with a piece of software for like 15-20 years and ended up doing something with that product that you haven’t or can’t remember doing ever before?   This happened to me quite recently and although I wont have a bunch of sexy scripts for you to reproduce the problem I will […]

Microsoft…. Y U NO FIX??

  I would like…. if I may… it take you on a strange journey…. Consider this: A SQL Server database with ALLOW_SNAPSHOT_ISOLATION set to true A stored procedure that creates a #temp table in tempdb and subsequently drops it Multiple calls of this stored procedure (running in Snapshot Isolation mode) happening at the same time […]

Twitter links powered by Tweet This v1.6.1, a WordPress plugin for Twitter.