Latest Blog Posts
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, 108 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
With the ability to find the metadata for deployed session, events and actions firmly under the belt, the natural progression would lead one to find the metadata for the target(s) attached to a session.
Exploring the metadata for the core components of Extended Events Sessions can be an extremely fruitful… Read more
Forgot to post the next day and now missing details! Notes:
- Rained the entire drive up (and back)
- Not a bad drive for me, about 2 hours
- You know it’s a strange day when you turn left at Wackos to get there
- Location is a restaurant/bar/grill. Had to look twice,…