Latest Blog Posts
There is a wealth of information within Extended Events. Throughout this series, I have been working on exposing that wealth of information. A good bit of this information happens to be the metadata for Extended Events, and another bit of this information is tied to the metadata for deployed Sessions.… Read more
Well I’ve done it. I’ve spoken at an event. I’ll discuss how I felt about it and what I learned along the way a bit later. But in the mean time I promised I would make the PowerPoint for my SQL Server Security Basics session available on my blog and… Read more
Im not doing a tremendous amount of public speaking this year and concentrating on more professional matters, however im pleased to say that on Friday 5th December i will be presenting a day long pre-con on Query Processing and internals at SQL Saturday 467 in Southampton.
We will be spending…
Introduction to Atomic CommitIn my previous post, we have discussed how to view and analyze SQLite BLOB data and know why BLOB data is important in SQLite database. Now, in this blog section we will know the role of atomic commit in SQLIte multiple files. SQLite has become the…
It’s been a long time since I wrote about my workspace, however I made a change recently. This was the "short term test" situation I set up a couple years ago:
Working on my third year of “Speaker of the Month” posts now. The good news, I haven’t run out of people to award it to. Most months, if I’ve been able to go to a community event or two, I have three or four candidates. Same this month.
Speaker of… Read more
Having covered the core concepts of deployed session metadata (events, actions, targets, predicates), there is one more topic to cover. This is more of a subset of those concepts in that this applies to more than one of the core concepts, but it isn’t really a stand-alone topic. This is… Read more
In the series of step by step SSIS tutorial this is another post. In this post we will see Aggregate Transformation. I am pretty much sure you are aware of aggregation. Although , Just wanted to share that aggregation operation in generally memory expensive operation.
So,… Read more
0 comments, 128 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 1 October 2015
It’s been a while since my last pre-con, in fact it’s been a while since my last SQL Saturday with both of these events happening in Exeter a few months back. At that time I did a joint pre-con with Mark Pryce-Maher called Performance Troubleshooting for the (Accidental) DBA which… Read more
October is going to be a very busy month for me! Three conferences and a pre-con are on the agenda.
This weekend I’ll be traveling to Kansas City, Missouri for their annual SQL Saturday. Normally, I would just drive to this event. However, I’m no longer living in Omaha so this year it’s a plane for me.
One of my favorite things about this event is that every year the… Read more
SQL Server Days 2015 is over and it was a blast. Met a lot of people from the #sqlfamily, too many to mention, and I saw some interesting sessions. My favorites were David’s session about loading data faster and Catherine’s session about BIML (yes, both are related to SSIS). I… Read more