Healthcare workers are some of the many heroes working bravely in the face of the Covid-19 pandemic. To protect themselves and their patients, they must wear face masks during their entire shifts. This causes a great deal of ear irritation, so a strap was designed to make wearing the masks easier and alleviate pressure on […]
2020-04-18
127 reads
Azure Data Studio (ADS) is a cross-platform tool that you can use to run T-SQL queries much as you have done using SQL Server Management Studio. No, the databases do not need to be hosted in Azure; the tool works fine for on-premises SQL Servers as well. I’ve started using ADS more as I teach […]
2020-03-21
178 reads
I can’t remember a time when I was not involved in side-projects, usually as a volunteer but also writing books or creating courses. New projects are like bright, shiny objects, and it’s easy to get involved in too many of them.
2020-03-16
2020-02-14
871 reads
2020-02-10
993 reads
2020-02-07
1,106 reads
2020-02-03
1,128 reads
2020-01-24
270 reads
January 1st is the beginning of a new year thanks to Julius Caesar and Pope Gregory XIII. This date is somewhat arbitrary, and many religions and cultures celebrate their own beginning of a new year at different times. Even though these celebrations don’t fall at the same time, I think the sentiment is similar. The […]
2019-12-28
109 reads
It’s rare to get a call from a customer telling you that the application is fast today and thanks for taking such good care of the database. Instead, you are more likely to hear complaints when things go wrong like slow running queries and timeouts. There is a lot to consider when trying to figure […]
2019-11-30
557 reads
I posted on Terraform and Azure SQL last year but wanted to see what...
By Kevin3NF
As a SQL DBA, what do you do when a vendor application has performance...
A couple of days ago I was doing some cleaning on some Azure SQL...
Comments posted to this topic are about the item The On-Call Load
Comments posted to this topic are about the item Two Table Hints
Comments posted to this topic are about the item Database Dashboards in Azure Data...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers