(2021-Mar-22) I had an interesting Azure Data Factory (ADF) case last week while pulling a list of files from an Azure Storage account with the help of [Get Metadata] activity....
2021-03-31 (first published: 2021-03-23)
1,458 reads
This is part two in a five part series this week, Moving into Consulting 101.
Today's consulting topic is friendly advice on how to handle yourself in front of clients,...
2021-03-31 (first published: 2021-03-23)
950 reads
A quick PSA on the behaviour of Serverless Azure SQL DB space reporting in the Azure Portal. I recently had to shrink a large Azure SQL DB for cost...
2021-03-31
31 reads
Have you ever run across an issue that made you take a step back and scratch your head? Recently, I had this exact situation hit my Inbox. One of...
2021-03-31
446 reads
I’ve been doing SQLskills training recently, and Paul Randal (blog | Twitter) reminded our class that zeroing out a transaction log file does not use zeroes (0x00). Well, not...
2021-03-31
42 reads
I 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...
2021-03-30
61 reads
One of the things that numerous clients have some to Redgate about is allowing a team of developers to work on a single shared database without creating conflicts. While...
2021-03-30 (first published: 2021-03-22)
194 reads
Introduction to this blog series
After being laid off by a Great Recession-era mortgage company in 2007, I entered into consulting. I made that switch from in-house DBA to consulting...
2021-03-30 (first published: 2021-03-22)
1,388 reads
As technology products grow, it’s important to evolve. We’ve updated WordPress.com’s interface to make it more coherent and logical, allowing everyone to use it more intuitively.
2021-03-30
12 reads
I’ve never used the FETCH or OFFSET commands for pagination, but I have heard of them. I ran across them recently and decided to experiment a bit. One note:...
2021-03-29
311 reads
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Every organization I talk to has the same problem dressed up in different clothes....
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Comments posted to this topic are about the item The day-to-day pressures of a...
ashes over you, making you forget the relentless sun outside. Instantly, your energy lifts,...
Comments posted to this topic are about the item Creating a Simple and Flexible...
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers