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
Day 16 of 31 Days of Disaster Recovery: Disaster Recovery Gems From Around The Net
It’s day 16 of my series 31 Days of Disaster Recovery. I’ve seen a lot of great DR related posts...
2013-01-18
914 reads
Blogs
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...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers