Finding orphaned database users
Database users can become orphaned for a few reasons. For example, a database restore to another instance or deleting the...
2011-10-29
1,615 reads
Blog Posts
Updatable Subscriptions Deprecated in SQL Server 2012
After spending some time looking at SQL Server 2012 CTP3, it appears as if Transactional Publication with Updatable Subscriptions will...
2011-10-29
4,035 reads
Updatable Subscriptions Removed in SQL Server 2012
After spending some time looking at SQL Server 2012 CTP3, it appears as if Transactional Publication with Updatable Subscriptions will...
2011-10-29
2,005 reads
A Thought on Career Decisions
One of the many conversations I had at the PASS Summit was about whether to pursue Direction A or Direction...
2011-10-28
643 reads
Convert comma separated string to table and vice versa
I know that this subject has been blogged about numerous times but I thought I'd post an alternative way of...
2011-10-28
9,130 reads
Displaying blank sub report
Recently I had to convert a stand alone report into a sub-report. That report was very simple… it had two...
2011-10-28
1,041 reads
How to hide Calculated Members in MDX SSAS
With some calculated members in MDX it only makes sense to see the calculation if a certain Hierarchy is used....
2011-10-28
2,517 reads
I/O Error On TempDB
I was running a DBCC CHECKDB on a database when I got an error that says:
Msg 0, Level 11, State...
2011-10-28
1,966 reads
PASS Summit 2001 In Review…WOW!!!
It has been a couple of weeks and I have had time to get back in the groove at a...
2011-10-28
1,703 reads
Play the Bob Ross Game
I was in a meeting a few weeks ago, deadlines looming and everyone feeling the stress some. We hit a...
2011-10-28
797 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
Bagaimana Cara Reschedule Tiket Batik Air
Reschedule tiket Batik Air dapat di lakukan menghubungi Call Center resmi Batik Air di...
Bagaimana Cara Refund Tiket Batik Air
Refund tiket Batik Air dapat di lakukan menghubungi Call Center resmi Batik Air di...
BCA Finance Kelapa Gading Layanan Mobil Tlpn/wa0853.7373-7551
Tlpn/wa0853.7373-7551 Ruko Mall Of Indonesia Blok B 32-33, RT.18/RW.8, Klp. Gading Bar., Kec. Klp....
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers