MDX Functions: TopCount
The MultiDimensional eXpressions, or MDX, language is used to query the data in a multidimensional in an OLAP database. In the...
2012-03-12
2,257 reads
Date Dimension Script with Fiscal Year
One dimension you can be positive will always make it’s way into your data warehouse is the Date dimension. Over...
2012-03-06
4,152 reads
Introduction to SharePoint BI Webinar Tomorrow
Tomorrow at 11AM Eastern time I will be presenting a FREE webinar for Pragmatic Works (website) on Introduction to SharePoint...
2012-03-06
624 reads
Speaking At SQL Saturday #110 in Tampa
I got word this week that one of my sessions for the upcoming SQL Saturday #110 in Tampa, FL was...
2012-02-10
431 reads
The Windows Search Engine Is Currently Disabled
If you have ever gotten this error message you may have been left scratching your head wondering why…kinda like me.
The...
2012-01-16
3,875 reads
Check Version of SharePoint 2010 Currently Installed
There are several ways to check the version of SharePoint 2010 currently installed in your environment. That about sums up...
2012-01-11
1,743 reads
The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.
You may fire up the SharePoint 2010 Management Shell (which allows you to run PowerShell commands to do cool SharePoint...
2012-01-05
2,235 reads
SharePoint 2010 Your Backup Is From A Different Version Of Microsoft SharePoint Foundation
Restoring a SharePoint site collection can be a pretty easy task. If your interested in how to do that check...
2012-01-04
1,563 reads
VirtualBox – Cannot Register the Hard Drive Because a Hard Drive with UUID Already Exists
Virtualization is awesome! It really helps when you are a developer. On my laptop I don’t even have SQL Server...
2011-12-21
5,393 reads
Mark a Disk Partition as Inactive
If you are like me then you like to reinstall Windows on your laptop every few months to keep things...
2011-12-20
897 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers