New Job -> Week 4 -> Set Up Auditing
This is part of a series of new job blog posts. You can find them all here. The main goal for week 4: set up auditing for all Azure...
2023-04-19 (first published: 2023-04-06)
238 reads
This is part of a series of new job blog posts. You can find them all here. The main goal for week 4: set up auditing for all Azure...
2023-04-19 (first published: 2023-04-06)
238 reads
(2023-Apr-10) Yes, Azure Data Factory (ADF) can be used to access and process REST API datasets by retrieving data from web-based applications.To use ADF for this purpose, you can simply...
2023-04-19 (first published: 2023-04-10)
355 reads
This is part of a series of new job blog posts. You can find them all here. Week 5 goal: set up Ola index maintenance for all Azure SQL...
2023-04-18 (first published: 2023-04-17)
24 reads
It is common to see high worker count issue on the production server and it can have a range of negative impacts on SQL Server performance and stability, potentially...
2023-04-17 (first published: 2023-03-31)
507 reads
Hello Dear Reader! Last week was a really busy week with an even busier weekend. We will get to the show recap's in a moment but first let's dive...
2023-04-17
2 reads
While I always configure transaction log backups for every database in non-simple recovery model, and to compliment it I also have monitoring in place if transaction log doesn't get...
2023-04-17 (first published: 2023-03-31)
655 reads
There’s a video of Bill Gates taking a drive in an autonomous car around London. I’ve been to London dozens of times, ridden and cabs and Ubers, and even...
2023-04-14 (first published: 2023-03-31)
209 reads
xp_cmdshell is an extended SQL stored proc that allows users to run Windows command prompt commands from within SQL. Sound scary? It might, but is xp_cmdshell really a security...
2023-04-14 (first published: 2023-04-12)
22 reads
A few months ago, I wrote a post on how I use voice technology to continue working with my ALS condition. Since that post was written, Microsoft released a...
2023-04-14 (first published: 2023-03-28)
140 reads
A while back I posted a blog on how to recover data with crash consistent snapshots. Snapshots are pretty handy in certain situations so I thought I’d show you...
2023-04-14 (first published: 2023-04-11)
14 reads
This is part of a series of new job blog posts. You can find...
By SQLBalls
Hello Dear Reader! Last week was a really busy week with an even busier...
By Steve Jones
In the last post, I created a baseline marker for Flyway in each database....
Getting the following error: Implicit conversion from data type sql_variant to varchar is not...
Trying to connect from sql express 2022 to the azure data studio and to...