|
|
|
|
Latest Blog Posts
-
|
This post is part of a Methodology discussion - other posts will follows. I will be happy to get your feedback! One interesting question is “How do you measure the complexity of a BI solution?” If we need to decide whether a specific technique is suitable...
|
-
|
In the last years I spent most of my time working on BI solutions based on the SQL Server platform. I had experiences with other architectures but I mostly used Kimball's methodology to design relational databases feeding SSAS cubes. However, Kimball...
|
-
|
An observant person has probably noticed that SQL queries requiring disk reads not only have longer duration but also higher CPU times. It is not hard then to deduce that disk access (for both HDD and SSD), which involves the OS performing an IO call,...
|
-
|
This thread on MSDN forums asks seemingly easy question – given a multiple selection of elements in the parent-child hierarchy – how to find lowest common ancestor among them ? While it is fairly easy to do using stored procedure, it turned out to be...
|
-
|
Context switching can be hard to understand and measure. As it turns out, you can use the PerfMon counter System >> Context switches/sec to count all of the switches occurring in and managed by SQLOS, regardless of the application(s) where it originated....
|
-
|
Only one slot left for the SQLBLOGGERS league.... To join, visit http://football.fantasysports.yahoo.com/f1 League ID: 540668 Password: rssfeed ALSO - We need at least 4 teams for this league, we have three right now.... It has to be an even number of...
|
-
|
My friend Steve Fibich has published a small series on examining DTExec processes to determine which SSIS packages they're running. He uses WMI and PowerShell. Really cool stuff - check them out! dtexec.exe what are you doing? dtexec.exe what are you...
|
-
|
Ok, this could be partially off topic, but if you work on BI it is not. I will be a speaker at the Microsoft Sharepoint Conference 2008 in Milan (Italy) on 2 and 3 October 2008. I have one speech about building digital dashboards using SharePoint, Reporting...
|
-
|
Drillthrough is a great feature of Analysis Services, but it has a limitation – only cells without calculations covering them can be drilled through. This automatically rules out drillthrough for calculated members in general and calculated measures in...
|
-
|
If you check my schedule , you'll see my summer and early Fall are spent mostly close to home. This is a good thing, because I have a book to write! But starting in October, I'll be gone at least every other week, with two trips to Europe and one to the...
|
-
|
Fellow RD and Solid Quality colleague Ken Spencer posted a little while back that he was having good success loading VPC images off flash drives. I thought it was time to try it myself. The first concept is that not all flash drives are created equal....
|
-
|
SQL Down Under show 39 featuring Kent Tegels is now available for download from www.sqldownunder.com . In the show, Kent discusses the spatial data type in SQL Server 2008. Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live...
|
-
|
I realize probably no one reads Books Online cover to cover, so there are probably lots of little details that easily slip by you. I was introduced to one of the hidden 'features' just last week. Here it is: CHECKPOINT can take a parameter! It's right...
|
-
|
Kevin describes a possible problem scenario when monitoring SQL Server memory using Windows Task Manager....
|
-
|
I recently (2 weeks ago) took a class from my friend Kalen Delaney on SQL Server Internals . It was 5 days and she really packed the material in there. I really like in depth training because it makes me think harder and I excel faster for some reason...
|
-
|
You might have read an earlier blog entry about my problems to remove a Data Collector (DC) information in SQL Server 2008. I still haven't found any info on how to do this, but my questions in the MVP group triggered some activity. Bob Ward looked into...
|
-
|
First up, my article Hierarchy ID has been published in MSDN Magazine. Its also available on the MSDN Web Site at http://msdn.microsoft.com/en-us/magazine/cc794278.aspx . Second, my recent interview with Dr. Greg Low and his world famous "SQL Downunder...
|
-
|
Let me start by saying that the contents of this post is not very advanced. If you have read the excellent paper "Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005", http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx...
|
-
|
I fell for this one this week. If you execute the following code in SQLCMD mode, what would you expect the output to be? : SETVAR PrincipalServer WINSTD2K8BASE : SETVAR MirrorServer WINSTD2K8BASE\SQLDEV02 : SETVAR WitnessServer WINSTD2K8BASE\SQLDEV03...
|
-
|
You've seen the Olympic torch relay. Well PDC has a brain relay with the PDCnoggin. The Regional Directors are an awesome bunch of people that I'm really honoured to be part of. Many get together for the PDC each time it's held. Our RD lead Kevin Schuler...
|
-
|
Introduction A few months back I received an email from a nice lady who was beginning to work with SSIS. She was trying to use SSIS to automate metadata collection in her enterprise and she had made a good start in the package she attached to the email....
|
-
|
This post is inspired by recent post by Mladen Prajdić. Mladen had found out (as many did before him - hanging around in blogs and communities, I see questions about this issue from time to time) that name resolution works for temporary tables differs...
|
-
|
As of today there is at least one hotfix available for SQL Server 2008, and it involves Itzik Ben-Gan's reported foreign key validation problem with the new MERGE command. You can read about the bug here: http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=357419...
|
-
|
I just received a mail from Adam Machanic that pointed me to this bug (I would call it a performance issue) about the construction of SQL statements generated by the LINQ to SQL engine. The issue: every string passed as a constant in the query will be...
|
-
|
Today I solved an issue for a customer that was a little bit unexpected, at least for me. The scenario: a table with a few records is periodically updated: a few records are inserted (with a bulk insert) and a few records are deleted (the older ones)....
|
|
|
|
|
|