Sqlserverpedia - sqlserverpedia.com
General Information:
Latest News:
Security Questions: Differences between “Grant” and “With Grant?” 23 May 2013 | 10:00 pm
As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s, I received a large number of questions that there wasn’t time to a...
I’m presenting at the PASS Summit! 23 May 2013 | 08:00 pm
I am fortunate enough to have been selected to give a presentation at the PASS Summit 2013 in Charlotte, NC on October 14-18. It’s amazing to think that, although I have been in IT for 25 years, I fi...
Using Scoped Assignments To Show Calendar and Financial Year-To-Date Values In The Same Calculated Measure 23 May 2013 | 07:27 pm
I’ve had a lot of requests for more MDX content on my blog, so here’s something I’ve been meaning to write up for a long time: a worked example of how to use scoped assignments to implement two differ...
Business Objects on Linux and SQL Server 23 May 2013 | 06:30 pm
This is just a quick post to share a lesson learned while I was on an engagement where the client’s reporting environment was using SAP Business Objects (BO)running on Linux for reporting. We were doi...
Is Your Code an English Garden or Ikebana? 23 May 2013 | 05:30 pm
Erika loves having fresh flowers around the house. Every Saturday morning, I pick up a bouquet at a farmer’s market or grocery store and put it in a vase for her. I’m slowly upping my game by learning...
The Journey is the Reward: Speaking for SQLPass, where do you start? 23 May 2013 | 03:45 pm
I'm heartened by the numbers of people who are expressing an interest in speaking at events. In particular, I understand that SQLPass had record numbers of people submitting to SQLPass Summit in Charl...
Big Data for the Business Intelligence Professional SQLPass Summit Preconference Day 23 May 2013 | 03:37 am
I'm delighted to announce that Allan Mitchell (blog ¦ twitter) and I are giving a Big Data for the Business Intelligence Professional preconference session at SQLPass Summit 2013 in Charlotte, NC. Wh...
Database index design and optimization: Some guidelines 22 May 2013 | 11:56 pm
Well-designed indexes are an important part of database optimization because they are the key factor in achieving optimal query performance and response time. In the meantime, poorly designed indexes,...
SQL Server Transactions and Locking (Part 1) 22 May 2013 | 11:39 pm
In many situations, data modification requires several steps. For example, you may need to change the values in two separate tables. You can use transactions to complete these two operations as a un...
Designing and Implementing Online Analytical Processing (OLAP) Architecture (Part 1) 22 May 2013 | 11:33 pm
The well-designed online analytical processing (OLAP) solution is fundamental to organizations analysis capabilities. That is why, when designing the OLAP solution for your organization, you must ensu...
