Rotating Header Image

Posts under ‘SQL Server’

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 […]

PASS Summit 2014 – I’m Speaking!!!

Good Morning!! With all the huzzah of PASS announcing the speakers and topics recently I thought I would wait a bit before doing the standard “I’m Speaking” blog post 🙂 As always it’s an honor to be selected to speak anywhere but the PASS Summit has and always will have a special place in my […]

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