No, Binary Collations are not Case-Sensitive
Quite often people will use, or will recommend using, a binary Collation (one ending in “_BIN” or “_BIN2“) when wanting...
2017-07-13
2,146 reads
Default reports in SSMS
As DBAs our stock in trade is information and there is certainly an impressive amount available. The diagnostic views are...
2017-07-27 (first published: 2017-07-13)
2,632 reads
Point Counterpoint: Why Virtualize a SQL Server?
I get asked all the time – “why virtualize SQL Server if I’m content with my physical servers today?” The normal...
2017-07-24 (first published: 2017-07-12)
3,125 reads
LocalDB DSC Script
Hello!
So, there are many different product SKUs of SQL Server available, and generally when developing it’s probably best to use...
2017-07-12
293 reads
Be Wary of Date Formatting in T-SQL
Today’s public service announcement is a reminder to be wary of date formatting in SQL Server. On a recent mailing...
2017-07-12
156 reads
I’m Speaking! Evansville Technology Group
SQL Server user group is a backbone of the SQL Server community. I currently help run the Louisville SQL Server...
2017-07-12
122 reads
I’m Speaking! Evansville Technology Group
SQL Server user group is a backbone of the SQL Server community. I currently help run the Louisville SQL Server...
2017-07-12
457 reads
Azure Cloud “Fear” Busting #1 – Security
So here we go, the first installment of my cloud blog series. From my experience this concern is a common...
2017-07-26 (first published: 2017-07-12)
1,747 reads
Create a Staging Load with Biml
When designing the ETL architecture for new or changing systems, one of the more common needs is to create a...
2017-07-25 (first published: 2017-07-12)
1,334 reads
SSRS Report Deployment Made Easy – 700 times Faster
Back in October 2016, Microsoft started a new GitHub repository – ReportingServicesTools – an open source PowerShell module to manage SQL Server...
2017-07-12
3,946 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