|
|
|
|
Latest Blog Posts
-
|
In one my recent MDX classes, a student asked about automation of MDX queries for the purposes of testing query performance, so today I’ll answer that question and draw your attention to a few resources available. Get the ASCMD Utility If you’re running...
|
-
|
I'm not one to whine. Really. I'm totally not a whiner. However, I'm going to sound like one with this statement... I fricken HATE iTunes. There, I said it. I'm already starting to feel better. Playing on Elisebeth Barrett Browning and her fantastic poem,...
|
-
|
I recently wrote an article about how to implement a Process Add on a table in a Tabular model . This is an area where there is a lack of documentation by Microsoft, especially if you want to use a custom binding query for every Process Add command, which...
|
-
|
Over the past year or so I have written at length about the SSIS Catalog that will be provided in the upcoming version of SQL Server Integration Services (SSIS 2012) and the capabilities that it will bring; one of the biggest benefits (in my opinion)...
|
-
|
I took the MCM lab a couple of weeks ago and passed. I still don’t believe it - it’s been quite the journey. There have been many decisive moments in my career; one of those was back in 2010 when I decided I would work on obtaining the certification after...
|
-
|
I recently joined Chris Webb , Jen Stirrup and Alberto Ferrari as PASS Data Warehouse and Business Intelligence Virtual Chapter for Europe. We will increase the number of virtual sessions delivered in a comfortable European time zone and we are looking...
|
-
|
(As with all of these types of posts, check the date of the latest update I’ve made here. Anything older than 6 months is probably out of date, given the speed with which we release new features into Windows and SQL Azure) I don’t normally...
|
-
|
Overall, SQL Server has become a very capable and mature product, with a very powerful engine and sophisticated query optimizer. Still, every now and then, a certain query structure throws the optimizer for a loop resulting in an execution plan that will...
|
-
|
I think I can say that we all agree that SQL Server 2012 brings with revolution in our database world, since the number of new feature and new possibilities, IMHO, is comparable to what SQL Server 2005 brought several years ago. Interesting enough, even...
|
-
|
Lately I've been very busy with client work, and one of my projects is to capture the history for SQL Agent jobs across all their servers so they can evaluate when to schedule jobs. (Yes, I know SQL Sentry has an excellent product for this, but right...
|
-
|
The ever alert Jonathan Kehayias ( Blog | Twitter ) sent me a question recently asking about the Extended Event UI used for showing predicates. In particular, he was wondering about the predicate for the wait_info event that is defined in the system_health...
|
-
|
Hooray – we’re ready to announce the details of the 24 Hours of PASS event that’s coming to an internet connection near you on March 21st! Read on for the day’s schedule, some of my thoughts on the 24 Hours of PASS concept, information about the platform,...
|
-
|
Almost two months have passed since my last blog post. And while it’s true that I’ve had (much) longer breaks, I do have a good reason now. All the time that I would normally at least in part spend on preparing new blog posts is now reserved for preparing...
|
-
|
Two quick notes from our friends over at INETA : Component Code Challenge Ever had these two distinct thoughts - "I have a good idea for an application, however what can I get for it?" and "I would love to go to a big conference DevConnections or Tech·Ed,...
|
-
|
I am excited to co-present A Day of SSIS at the Atlanta SQL Saturday #111 13 Apr 2012! The SQL Saturday event will be Saturday 14 Apr 2012, but the precons (there are three!) will be Friday 13 Apr 2012. Matt Masson ( Blog | @mattmasson ) is co-presenting....
|
-
|
SQLTeach (Part of the DevTeach Conferences in Canada) has enjoyed success for many years. I enjoyed the opportunity to speak at and attend SQLTeach at various times over the years. Since SQLTeach is part of DevTeach, the "feel" of the event is very different...
|
-
|
There are multiple ways to store data in a cloud provider, specifically around Windows and SQL Azure. As part of a “Data First” architecture design, one decision vector – assuming you’ve already done a data classification of the...
|
-
|
I am honored to present “Building Your First SSIS Package in SQL Server 2012” at the NJ SQL Server User Group Tuesday, 21 Feb 2012 starting at 6:00 PM! If you read this blog and will be in the area, please stop by and introduce yourself! I’m the fat guy...
|
-
|
This story didn’t actually take place on Valentine’s Day but it is appropriate to tell on Valentine’s Day. How far would you go for someone you love? When our first born child was a toddler, something made of glass fell to the floor. One of us quickly...
|
-
|
This is not the big announcement that I’ve promised about 24 Hours of PASS (which starts in five weeks from now!) – that’s coming later this week (and for those of you who haven’t picked up on it – 24HOP is the portfolio I’ve been given since becoming...
|
|
|
|
|
|