In a recent article on SSG, I discussed how to use Extended Events to function in a Profiler like fashion. You can read about that here. I recommend reading that article first because it helps […]
Category: SQLServerPedia Syndication
Last Execution of a Proc
SQL Server is full of good stuff. There are plenty of features to be used. Plenty of applications to help it. And there is even plenty of metadata within SQL Server to help you better […]
Security as a Fleeting Thought
Today we have another installment in what is known as TSQL Tuesday. This month we have an invitation and topic given to us by the infamous Kenneth Fisher ( blog | twitter). Today, the invitation […]
Las Vegas UG This week
What a fun week we have tuned up for the folks in Las Vegas. It is the first full week of January and there is this huge convention going on near the strip. And as […]
Effects of Max Mem on Plan Cache
Some effects on plan cache and max memory settings
Happy Holidays
Quick and simple for today. Happy Holidays to you!
Murder in Charleston
I am about to set sail on a new venture with my next official whistle stop. This year has been plenty full of whistle stops and I plan on continuing. You can read (in full) about […]
Audit Database File Size Changes
If you just so happen to be running on SQL Server 2012 or later, you will need to change your event sessions that were tracking file changes. It is a bit of an exercise to make the change and can be frustrating, but it is well worth it. The improved data that can be captured is going to help better control and oversee the environment.
TSQL Tuesday #60: Something Learned This Way Comes
It is once again time to come together as a community and talk about a common theme. This monthly gathering of the community has just reached it’s 5th anniversary. Yes, that’s right. We have been […]
Summit 2014 – Next Impressions
As Summit 2014 begins to wind down, it is time for some more impressions from the week. The week has been good so far. It has been very busy and also can be quite a […]