Re-writing MDX calculated members as DAX measures
I have been working on re-creating some logic in a tabular cube that was originally implemented in multidimensional. This involved...
2013-01-21
1,364 reads
My view isn’t reflecting changes I’ve made to the underlying tables.
Problem: You’ve added columns to the base table of one of your views, but the view isn’t reflecting the change.
Over...
2013-01-29 (first published: 2013-01-21)
3,856 reads
Important Update for SQL Server 2012 SP1
One of the challenges we faced this week was a high CPU usage on one of our SSAS Cluster boxes when there was very little activity, plus some errors...
2013-01-21
9 reads
Photo cataloguer
If you are anything like me, by know you will have a few thousand digital images spread across multiple directories...
2013-01-20
733 reads
Got "Cannot generate SSPI context" error message after changing sql service account
Today I changed a sql server service startup account during testing, then when I tried to connect sql server with...
2013-01-19
12,480 reads
Good Bye 2012 and welcome 2013
Hey Everyone….. from quite some time I have not written Blogs due to some personal and transiting from my old company...
2013-01-19
741 reads
Variable Scope in SQL Server
The way variable scoping works in SQL Server has been well documented on MSDN, but I have seen related issues...
2013-01-18
2,839 reads
Reblog: January 11 to January 17
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-01-18
593 reads
New Year Aspirations – Mark Broadbent – SQLSaturday
I’ve known you for quite a while now through Twitter and later at SQLBits (your mum was right kids, don’t...
2013-01-18
1,123 reads
2013 Polar Plunge #SQLPlunge
Next month… on March 2… I’m going to jump into a lake in Minnesota. Now it’s cold in Minnesota. In...
2013-01-18
646 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers