2019-11-28
86 reads
holiday
2019-07-04
104 reads
Create bank holidays table
Do you know what happens if a holiday falls on a weekend? This script will help you.
2012-01-16 (first published: 2011-12-14)
2,126 reads
Blogs
Error message: http://System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value ‘NULL’ to data type int.
I love this error. Primarily because it demonstrates two very important things. Errors matter....
New Power BI Report Design Pre-Con in 2020
I’m excited to announce that I will be offering a full-day pre-con about Power...
Resetting an Azure SQL Database Admin Password
By Steve Jones
This is likely something that most people know, but it was a bit confusing...
Forums
Deadlocks
Looking for some ideas so to prevent deadlocks. I have captured queries that constantly...
Lengthy query response times
I'm dealing with a strange problem that started today. A simple query that will...
Query runs for days when upgrading to 2017
We upgraded our datawarehouse sql server from 110 to 140, RTM - CU17. In...
Ask SSC