Query Store and Optimize For Ad Hoc

I love presenting sessions because you get so many interesting questions. For example, what happens with Optimize for Ad Hoc...

Utility function: dbo.JobName(@job_id)

As often as I have to pull a job’s name based on its job_id in the MSDB system tables, I’m truly...

SQL Nexus in Copenhagen

The Nordic SQLNexus conference is taking place in Copenhagen on May 2-4. I’ve never been to the event, or the...

Why you shouldn’t use SELECT *

I answered an interesting question on SE today (ever notice how many posts come from stuff I read on forums?)...

Using PowerShell to set Extended Events Sessions to AutoStart

When you look after more than a few SQL Servers you will need to perform the same actions against a...

The Future of the User Groups (SQLPort)

With SQLPort approaching it’s 6th birthday (21st of April), I have to admit that the works on the user group...

SQL Bite-Size Podcasts are live!

Well, after many late nights I have finally produced a set of podcasts – Bite size style – therefore called SQL Bite...

Most common interview questions

1.  Tell me about yourself.

Answer - Give summary of your past education and work, skills, and achievements and include your strong...

Getting ready for interview

Interview is a three stage process. Before => Interview => After

A. Before Interview -

1. Most important, ready your Resume/CV. Be confident about...

Happy Dance!

I’m all like:

Because I saw this on an eval:
I’ve been trying to ramp up to take advantage of my MSDN...