Latest Blog Posts
A few months ago I followed an introductory course about the data vault modeling technique for data warehouses at a local training provider. As part of the training, I received the book Modeling the Agile Data Warehouse with Data Vault written by Hans Hultgren who also is an instructor… Read more
You need to run the following query and it will give you the date of your SQL Server Installation.
SELECT @@SERVERNAME SERVERNAME, CREATE_DATE ‘INSTALALTIONDATE’
WHERE SID = 0X010100000000000512000000
SID 0X010100000000000512000000 is belongs to user "NT AUTHORITYSYSTEM". This user create at the time of installation only.
If you liked… Read more
Regardless of the type of development (application or reporting) that you are performing on SQL Server. There are 5 items within SQL Server that I consistently use to help me design and troubleshoot solutions.
SP_Who is a system stored procedure that returns information on what is currently running on… Read more
About two months ago, after 2.5 years, I left Microsoft.
Microsoft is an amazing place to work for. It’s conformable, balanced, challenging and educating. I feel like the factors of my maturity and interests, the challenges I had to face and the people I worked with, combined perfectly to make… Read more
This is a reprint with some revisions of a series I originally published on LessThanDot. You can find the links to the original blogs on my Series page.
In the final installment of my series on SQL window functions, we will explore using analytic functions. Analytic functions were introduced… Read more
I have a lot of books on my shelves dealing with business intelligence, data warehousing, master data management, and consulting. Below are my favorites:
Data Warehouse Books:
Most SQLSaturday’s do ok when it comes to finding speakers, the results of an incredible speaker mailing list and a lot of reasons for speakers to participate – I’d say a combination of a chance to learn in addition to presenting, the chance to spend time with other speakers,… Read more
I did an online presentation about PCI and Credit Card Security for BSSUG last night and it went pretty well, with one minor pain point – at very points in the presentation I was hearing myself on about a 1 second (or it seemed) delay. I was using my phone… Read more
Here’s the latest update on our registrations. We’re still ahead of all our previous events, that’s good, and we’re 2 weeks (or less) from announcing our schedule and I expect that to mark the beginning of the standard spike upward. Looking at this I realize that I don’t know what… Read more
When I was in college and taking programming classes (back in the days when “a T-Rex ate my 5.25 inch floppy” was a reasonable excuse) we were taught that since the compiler didn’t really see white space we should use it to format our code. And that is absolutely correct.… Read more
As a part of designing an Analysis Services cube you must define how each dimension is related to each measure group in your cube through the Dimension Usage tab. The Dimension Usage tab is found when editing the cube in the cube designer. The screenshot below shows dimensions on rows… Read more
PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in order to attend one of these event, you must register. Please register soon as seating is limited, and let friends and colleagues know about the event. Most… Read more
I wouldn’t say it’s common knowledge that you should look at execution plans when tuning queries, but it’s not exactly uncommon knowledge either. But, people tend to get focused on just looking at the graphical part of the plan and there’s just not enough information there. Let’s take a look… Read more
- Had our second planning meeting, still trying to complete the email template and realized we had not clearly defined two tasks for this week; finish the template and send out the first promo for the seminars. Easy to get it jumbled on a call, should have caught it in the…
During a bit of work I’ve been doing this evening for SQLRelay 2014 I used something I have in my arsenal of PowerShell scripts which I thought I’d share because I love it’s simplicity :) It’s nothing big and fancy but something that is extremely useful. Tasked with merging a… Read more
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 previous whistle stops and why they are called whistle stops here.
Suffice it… Read more
If you work with colleagues that aren’t as interested in growing and learning as you are, I hope you’ll read Infect Your Colleagues with the Learning Bug. It’s both a how-to and a caution against pushing too hard. It’s an interesting topic, I’ll be curious to see the tone… Read more
Every SQL Saturday leaves a mark of some sort. This time around, the folks in Sacramento have really helped leave a BIG mark.
That’s right, this last weekend was SQL Saturday in Sacramento Ca. You might have seen my announcement about it here.
This event had a lot of… Read more
Blacklist vs Whitelist
I think just about everyone is familiar to some degree with the concepts of a blacklist and whitelist.
If not, the easiest way I can summarize them is as follows:
A blacklist is a list of what can not access something you… Read more