Azure Databricks – The Notebook
Data engineers, pipe line developers, general data enthusiasts will be spending most of their time within a notebook. Here you develop your code, nice visualisations and commentary boxes are...
2020-10-14
28 reads
Data engineers, pipe line developers, general data enthusiasts will be spending most of their time within a notebook. Here you develop your code, nice visualisations and commentary boxes are...
2020-10-14
28 reads
I have spent many long weekends getting stuck into Azure Databricks, plenty of time to understand the core functionality from mounting storage, streaming data, knowing the delta lake and...
2020-10-06
158 reads
When it comes to database backups for IaaS based Azure SQL Servers you have 3 options. Automated Backups, both V1 and V2 depending on the SQL Server version. Azure...
2020-09-16
14 reads
Warning, this is a longer post from me than usual. The title is a mouthful and so is this post. In the past I have linked to blog posts...
2020-09-09
305 reads
Last month I gave a presentation to The PASS Hybrid VG https://hybrid.pass.org/. Now is a good time to become “cloud ready” as a DBA and my presentation gives a...
2020-09-03
38 reads
One of the main benefits of configuring active geo-replication for Azure SQL Database is leveraging the read-only endpoint, a good technique to split away read only activity from OLTP...
2020-08-25
129 reads
A quick 2 minute overview video (from me) about ADS – Advanced Data Security. The unified package from Microsoft providing the ability to discover / classifying sensitive data, mitigate...
2020-08-19
14 reads
Recently I found out that I passed the BETA exam for Azure Database Administrator Associate qualification. I wanted to share with you my thoughts on the exam and if...
2020-08-11
23 reads
About 1.5 years I wrote about MAXDOP setting within Azure SQL DB, more specifically the fact that the default setting being 0. (https://blobeater.blog/2018/09/12/maxdop-and-azure-sql-db/) Now, you should be aware that...
2020-08-10
285 reads
I thought being an Azure Data/Database blogger I would share some amazing content from Microsoft, an Azure SQL Fundamentals learning path. Following this training you will “Learn how to...
2020-08-05
49 reads
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
By Kevin3NF
Can we normalize a couple of things? 1 – Trade Schools. Back in the...
Data isn't just about numbers and spreadsheets. It holds stories, patterns, and the answers...
Hi, I have two tables: one for headers with 9 fields and another for...
We're trying to understand how quick new versions of SQL server can be. Obviously...
hi we run 2019 std. we saw this week that someone hid 3 important...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers