An All Star Lineup for EightKB
An online conference is coming on June 17, 2020 that is full of high level content. It’s the type of event that I think contains information relatively few people...
2020-06-03
77 reads
Blog Posts
Approaches to running Databricks ETL code from Azure ADF
Databricks is fantastic, but there is a small issue with how people use it. The problem is that Databricks is all things to all people. Data scientists and data...
2020-06-03
195 reads
Approaches to running Databricks ETL code from Azure ADF
Databricks is fantastic, but there is a small issue with how people use it. The problem is that Databricks is all things to all people. Data scientists and data...
2020-06-03
2 reads
BlitzFileStats custom module available for Inspector V2
BlitzFileStats is the latest addition to our custom module collection for reporting on data logged to tables using the First Responder kit, We created a new project where we plan on...
2020-06-03
21 reads
Daily Coping 3 Jun 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-06-03
4 reads
How should I store currency values in SQL Server?
On Twitter, Michael Dyrynda writes: ?? Never ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever...
2020-06-03
315 reads
Lock your Azure SQL Database
So you have many databases in Azure, you accidentally deleted one which can happen and has happened to me because in my situation they had very similar naming conventions...
2020-06-03
144 reads
Refresh databases that belongs to Availability Group using dbatools
Few days ago I was surfing on Twitter when dbatools asked about how it’s PowerShell module changed the way people work. We're looking to highlight how dbatools has changed...
2020-06-03 (first published: 2020-05-20)
1,368 reads
Step-by-Step: iSCSI Target Server Cluster in Azure
I recently helped someone build an iSCSI target server cluster in Azure and realized that I never wrote a step-by-step guide for that particular configuration. So to remedy that,...
2020-06-03 (first published: 2020-05-20)
272 reads
What happens if your SQL Server editions are out of support? – a MinionWare snippet
The more your SQL Server is out of date, the more things become vulnerable, broken and unfixable, limited in features, and expensive.
The post What happens if your SQL Server...
2020-06-03
168 reads
Blogs
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
Forums
SQL Server 2025 Jobs
Hello SQL Server 2022 16.0.4212.1 running on a Windows Server 2025 Std,V 24H2, SO...
how to optimise whole database full of table and sp in one go using githubcopilo
i have subscription of github copilot which i can access in vs 2022 comunity...
Password Guidance
Comments posted to this topic are about the item Password Guidance
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers