SQL Cruise 2017 – Western Carribean – my experience
As some readers may know, I am a regular attendee on SQL Cruise s for 8 years now. SQLCruise is...
2017-02-19
616 reads
Blog Posts
CLR Stored Procedure Cannot Be Marked as System Object?
It is an open secret that in SQL Server, we can “create a system object” by using an undocumented stored...
2017-02-17
788 reads
Deadlock priority
Everyone deals with deadlocks from time to time. But sometimes we need to control who’s the deadlock victim and who...
2017-02-17 (first published: 2017-02-08)
2,902 reads
Friday Reading 2017-02-17
Is it me or is February dragging? Anyway, mixed in with this crazy week I’ve been reading: –
SQL Server vs...
2017-02-17
341 reads
Gartner Magic Quadrant for BI 2017 Top 3 Rankings
This is a different spin on the top three vendor rankings visualized in Power BI. According to the placement of...
2017-02-17
808 reads
Missing Checkbox for Security Filter in Power BI Desktop
Just a quick blog post so that other people don’t waste 15 minutes of their life looking for a missing...
2017-02-17 (first published: 2017-02-09)
2,754 reads
The Costs of Hiring Cheaper Consultants
From time to time, I see posts in forums from people complaining about how much some consultants charge. A really...
2017-02-17
590 reads
vCenter Server fails to start, Purge and Shrink Vcenter SQL Database
One of my client vCenter Server fails to start as below shown error in event logs.Could not allocate space for...
2017-02-17
649 reads
Deadlock on ALTER DATABASE
I had an interesting problem recently. A database was stuck in single user mode. How exactly was it stuck you...
2017-02-16
1,416 reads
Dynamically Changing Shapes in Power BI – Alternatives
NOTE: the DAX presented in this blog post is written in my locale (nl-BE). This means that semicolons are used...
2017-02-16 (first published: 2017-02-08)
1,706 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers