Archives: September 2013
I must admit… Denver is my favorite town in this country. The outdoor things to do, the wide variety of locals and transplants, and the thin air all are favorable to me. I’m looking to move here someday soon. With that said, this year’s SQL Saturday #190 in Denver was… Read more
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of things I find interesting. While these links aren’t the answer to life, the universe, and everything, they do share a few… Read more
You may or may not have noticed, but every single week day for the month of September, I’ve put up a blog post. Some were short little blurbs linking to some other person’s blog or an article that I decided to comment on. Some were the… Read more
The 6th cumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 6 contains all the hotfixes released since the initial release of SQL Server 2012 SP1.
Those who are facing severe issues with their environment, they can plan to test CU6 in test environment… Read more
What the heck? Even indexes have WHERE clauses these days. I can’t remember what I was reading when I saw this but it completely flabbergasted me. If you go look at MERGE in BOL you will see what I mean. So does this mean you can’t restrict data in a… Read more
If you are using the templates for MDX calculation built into SSAS 2008 you might run into some strange issues. In the image below you can see the calculation is working for all years except for 2008.
My first thought was data issue. After querying the table and finding no…
Carolina Technology Conference:
To start things off, I'll be speaking in the morning at the Carolina Technology Conference. I have a 40 minute slot from 10:05 - 10:45 AM Eastern. I'm shooting for a 30-35 minute presentation with 5-10 minutes of questions. Here's the information on the talk:
0 comments, 1,895 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 30 September 2013
Fires, SAN failures, tornados, and car accidents all came up today, yet it was a very good day at work. I just started my job two weeks ago and made a list of questions to go through with them. After asking the one about when they last pulled an offsite… Read more
Statistics contain information about the data. How the data is distributed inside the table. They are representation of a table. They represent the table in the sense that optimizer refers to the statistics to generate a plan rather than scanning the whole table for plan generation. These stats are… Read more
In Chapter 1 of the book MDX with SSAS 2012 Cookbook, in the first recipe “Putting data on x and y axes”, I have given a simple example to show how easy it is to use the CROSSJOIN function to "combine" more than one hierarchy into the COLUMNS and… Read more
We live in a Dilbert age.
If you are a DBA and have worked in organizations of any size you are guaranteed to have seen things that are so insane they just simply can not be made up.
Thanks for attending! If you attended my talk, shoot me some feedback here: http://speakerrate.com/william.assaf
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information that I need to solve a problem or answer a question. It’s that whole “cha-ching” – buried treasure! feeling. That’s kind of the aim of this blog post. To provide… Read more
We just received word of a bunch of new functionality over at Scott Guthrie’s blog. Not a lot of stuff for data pro’s… unless you work with Oracle. Yeah, you can now create Oracle VMs. See the image below:
I swear, I can’t tell you why this gives… Read more
I hope you were able to attend my free webinar on Understanding Microsoft Self-Service BI on September 26, 2013. If you weren’t you can now download the recording here.
Because I covered new material all the way to the end of the webinar i thought I’d also answer some… Read more
Last Monday, I presented a session for Pragmatic Works Training on the T’s on the Microsoft’s Parallel Data Warehouse. In the session, titled Recognizing the Parallel Data Warehouse (PDW) Workload, I discussed the role for MPP and PDW in the enterprise and the types of workloads that it can… Read more