On the Road at SQL Bits
I may try to blog, but I know this is a busy week. I’m leaving today for England and SQL Bits. Actually I fly to London and then spend...
2023-03-13
12 reads
I may try to blog, but I know this is a busy week. I’m leaving today for England and SQL Bits. Actually I fly to London and then spend...
2023-03-13
12 reads
Recently I had to read some REST API data using an Azure Logic App. The data itself comes from AFAS, a Dutch SaaS ERP company. In general, the process...
2023-03-13 (first published: 2023-02-26)
227 reads
Did you know that you can restore AWS RDS databases to a SQL Server 2022 instance running locally using native backup and restore? Well you can. Let’s talk about...
2023-03-13
9 reads
Hello Dear Reader! Last week was an incredible week. We dropped new content on Monday, Tuesday had the Community Round Table, Wednesday MS Tech Bits, and released YouTube Shorts...
2023-03-13
15 reads
Recently I needed to add a computed column to a table and realized that I didn’t remember the syntax. This short post show how to do this. Another post...
2023-03-10 (first published: 2023-03-01)
210 reads
Today’s coping tip is to notice three things you find beautiful in the outside world. I haven’t been outside a lot lately. It’s been cold and I’ve been busy...
2023-03-10
10 reads
This past weekend, I had the pleasure of attending and speaking at SQL Saturday Atlanta! If you’re in the area, I highly recommend connecting with the local user group...
2023-03-10 (first published: 2023-02-27)
154 reads
Today’s coping tip is set an intention to live with awareness and kindness. One of the best things about these coping tips is that I have learned to be...
2023-03-09
9 reads
As I mentioned in my Data Mesh, Data Fabric, Data Lakehouse presentation, the data lakehouse architecture, where you use a data lake with delta lake as a software layer...
2023-03-09
6 reads
This blog post summarizes the type of technical questions I would ask candidates for a Microsoft SQL Server data platform administrator and database developer role.Hopefully this helps both candidates...
2023-03-08 (first published: 2023-02-28)
1,020 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