Are IT Certifications Still Relevant?
Steve talks about certifications today, after watching a video that showcases the benefits of why they are good for your career.
Stairway to SQL Server Security Level 7: Security Across Databases with Cross-Database Ownership Chaining
Sometimes you need to reach outside a database and access data and objects from multiple databases, which raises some security issues and increases the complexity of data access. In this stairway level, you’ll learn about cross-database ownership chaining so that you can reach across database boundaries securely.
SQL Server Filtered Index Essentials Guide
Learn about using filtered indexes for SQL Server tables and some of the potential issues you might be faced with when using a filtered index.
Ingest and Retrieve data from an ADX Cluster Using Python
Learn how to query data in Azure Data Explorer using Python.
The DBAccountant
Are DBAs going to be responsible for financial accounting for cloud resources as a part of their job? Steve has a few thoughts today.
Snake draft sorting in SQL Server, part 2
In my previous post, I showed how to borrow a snake draft concept from fantasy football, or a packing technique from the shipping industry, to distribute different portions of a workload to run in parallel.
Take Care
The world seems to be proceeding through some stuff at the moment. IT and our industry as a whole, equally seems to be going through some stuff. As such, allow this oldster to offer some advice: Take care of yourself. I know, I'm the same, you may have responsibilities for others. You need to take […]
Database Dashboards in Azure Data Studio
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I've written a few articles on how the tool works, and this one continues the series. In this article, I want to look at the database dashboards and how you can customize them. The other articles in this series on ADS works […]
The On-Call Load
Today Steve asks about on-call responsibility for you and how you view this as part of your job, or in your job search.
Managing Failed Pipeline Runs in Azure Data Factory
In this article, we look at how to setup different ways to handle pipeline failures and notifications when working with Azure and Azure Data Factory.
Blogs
Degrees and Trade Schools
By Kevin3NF
Can we normalize a couple of things? 1 – Trade Schools. Back in the...
Unlock the Power of Your Data: From Basic to Advanced Data Analysis
Data isn't just about numbers and spreadsheets. It holds stories, patterns, and the answers...
Attacking the Weakest Link
By Brian Kelley
When I look at a system and think about its security model, the first...
Forums
plugging a repo version number into the tabular model
hi we run 2019 std. we saw this week that someone hid 3 important...
The "ORDER BY" clause behavior
Comments posted to this topic are about the item The "ORDER BY" clause behavior
Are IT Certifications Still Relevant?
Comments posted to this topic are about the item Are IT Certifications Still Relevant?
Question of the Day
The "ORDER BY" clause behavior
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