All authors

All authors

Blogs

Error message: http://System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value ‘NULL’ to data type int.

By

I love this error. Primarily because it demonstrates two very important things. Errors matter....

New Power BI Report Design Pre-Con in 2020

By

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

This is likely something that most people know, but it was a bit confusing...

Read the latest Blogs

Forums

Query runs for days when upgrading to 2017

By askcoffman

We upgraded our datawarehouse sql server from 110 to 140, RTM - CU17. In...

Connections during AG Failover

By J-M.L

Hello everyone, I am playing with Availability Groups for the first time (a bit...

How to grant CREATE TABLE but deny DROP TABLE?

By webrunner

Hello experts, We have an application that creates new lookup tables on the fly....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Database Backup Types

See possible answers