SQL Server Tips and Tricks
In this article I will be listing the tips and tricks to work like
a Pro.
So let's get started –
Important keyboard...
2017-02-20
289 reads
Blog Posts
I’m a VMware vExpert
To add to an already amazing year, recently I was named a VMware vExpert for 2017. I’m honored, humbled, and...
2017-02-19
161 reads
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
627 reads
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
812 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,913 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
345 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
812 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,775 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
608 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
651 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