My Evening With SQL Tool Service
Hello!
I’ve been writing a PowerShell Module that will handle deploying SQL Server Agent Jobs by using the Agent namespace in...
2017-07-13
247 reads
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,155 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,637 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,132 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
296 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
163 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
124 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
458 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,750 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,337 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Trigger isn't working
Hi, I have a trigger, that works fine elsewhere but is not working at...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers