Index Fragmentation in Azure SQL Database
Index Fragmentation in Azure SQL DatabaseFEBRUARY 4, 2015
Recently, I read the articles Stop Worrying About SQL Server Fragmentationand When Does...
2019-08-09 (first published: 2015-02-03)
13,505 reads
Blog Posts
Life Support 2008 – Audit Logons
Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep work involves auditing your server for any users that may still be using the instance.
Related...
2019-08-09 (first published: 2019-07-17)
270 reads
Salaries in Job Ads
Hiring at Basecamp is interesting. I caught this interview and think it’s a good look at a process most of us have gone through, but perhaps not thought about....
2019-08-09
29 reads
Setting Up Alerts in Azure SQL Database
Setting Up Alerts in Azure SQL DatabaseSEPTEMBER 8, 2015
Introduction
If I've learned one thing with my on premise versions of SQL...
2019-08-09 (first published: 2015-09-08)
3,749 reads
SQL Azure has T-SQL Jobs - Well Almost
SQL Azure has T-SQL Jobs - Well AlmostJUNE 25, 2015
Introduction
One thing that has been lacking in Azure SQL Database is the...
2019-08-09 (first published: 2015-06-25)
2,836 reads
Using AzCopy in a SQL Job to Upload Files to Azure Blob Storage
Using AzCopy in a SQL Job to Upload Files to Azure Blob StorageNOVEMBER 11, 2015
Introduction
In my next series of posts,...
2019-08-09 (first published: 2015-11-10)
7,199 reads
Validating Replication (All or Just One Article)
You may sometimes have reports or other processes that are dependent on transactional replication being current. If that is the case, you will probably need a mechanism to check...
2019-08-09
14 reads
Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 1
I have read quite a bit about “the death of Big Data” recently. To be
honest I’ve never liked the term Big Data. It has always skewed people’s
thinking...
2019-08-08
242 reads
Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 1
I have read quite a bit about “the death of Big Data” recently. To be
honest I’ve never liked the term Big Data. It has always skewed people’s
thinking...
2019-08-08
21 reads
Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 1
I have read quite a bit about “the death of Big Data” recently. To be
honest I’ve never liked the term Big Data. It has always skewed people’s
thinking...
2019-08-08
17 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers