Access Analysis Services via T-SQL?
It occurred to me the other day that it might be interesting to manage aggregates in an SQL Server database...
2010-03-22
861 reads
Blog Posts
Be Responsible in your blogging and posting
I have been awarded the MVP award from Microsoft a few years in a row and it’s an honor, but...
2010-03-22
671 reads
Don't Throw Something New In At Production Deployment
This post comes from a conversation I had with a developer last week as well as my experiences over the...
2010-03-22
1,807 reads
Free Events – It’s All About Expectations
Isn’t free enough? If you go to a free event do you have a right to complain? Or, if you...
2010-03-22
977 reads
More Thoughts on Certification
After a great response to my last post on Certification, I need to post my thoughts on 70-450 PRO: Designing,...
2010-03-22
577 reads
PASS BI Virtual Chapter
Did you know that PASS has virtual chapters, allowing members to participate in virtual meetings that are geographically agnostic? One...
2010-03-22
1,219 reads
SP_SPACEUSED & SP_MSTABLESPACE
Take a look two SP inside the sys Procedure in SQL Server 2008 (included also in the SQL Server 2005),...
2010-03-22
4,532 reads
SSWUG Ultimate vConference Discount Code
The SSWUG Ultimate Virtual Conference is coming up on April 7, 8, and 9th. This is three days of very...
2010-03-22
833 reads
Why UniqueIdentifier is a Bad Choice for a Clustered Index in SQL Server
I had a question today about why it was “bad” to use a UniqueIdentifier as the data type for a...
2010-03-22
9,330 reads
I’ve Moved and So Should You
After blogging on Live Spaces for a couple of years, I’ve made the difficult decision to move to my own...
2010-03-21
522 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