Back to Basics

This week I saw a post from Randolph West that covers binary and hexadecimal. It seemed basic and simple to me, but I'm old. I started learning about binary and hex in high school, where we used to tap our fingers to count in binary. Up was "0", and down was "1", and with one hand, you count to 31 (from zero). At the time, I thought it was important to know binary and hex to work with computers.

These days, I've rarely had to deal with binary and hex. They aren't useless in programming, but they are much less used in these days of GB of memory and large data structures. We don't encode things as often as we used to. Usually now hex just means I'm dealing with varbinary and need to cast it (or render it in some other way).

During the last few years, I've seen some efforts to get back to basics and publish more information that helps people get started or fill in gaps for areas that someone might have missed. Years ago Ed Leighton-Dick started the SQLNewBlogger challenge. I participated, and continue to write some basic posts every week or two. Grant had his database fundamentals series, and SQLServerCentral has published the Stairway Series for some time, giving people a way to get started in some new area of the data platform.

I think it's important that we continue to cover the basics in all aspects of the data platform, as well as other areas. The world of technology is so wide, and new people are always starting their journey in their industry. Even for those of us that have worked with SQL Server or some other area for a long time don't know everything about the platform. We often have as need to learn more about some niche and need some basics to help us. I think Azure Data Factory as a perfect example of this. Many people who worked with SSIS for years might need a few primers on the differences with ADF to understand a slightly new paradigm. Much of cloud computing needs basics, and constant updates to those pieces.

I know that the basics are always popular at SQL Saturdays and other conferences. The basics often get the most reads as articles, and I am hopeful that we will continue to see those with knowledge remembering that the basics are often the most important part of learning to build better software and systems for the future.

Steve Jones - SSC Editor

Join the debate, and respond to the editorial on the forums

The cloud migration tools and processes that will help you move a database to the cloud, from planning, implementation and validation through to extending existing development and deployment processes to the new cloud platform.

Maintain your favorite SQL snippets and queries centrally, using PowerShell to save and update each snippet collection, in JSON, and then converting them into SQL code snippets for SQL Prompt.

Would you like the chance to win a DevOps book bundle? Redgate is giving away your choice of DevOps books and Redgate goodies in their latest competition. To enter, visit the Redgate Forums and answer the question: ‘How is SQL Change Automation helping you?’

From the same company that brought you services li...

Have you ever opened the SQL Server Error Log and wondered, “where are all the errors?” Digging through the Error Log to find what you need can be a... The...

Ever need to set your web server a specific protocol version of TLS for web servers and need a quick way to test that out to confirm? Let’s check... The...

How to use SORT_IN_TEMPDB to increase your for in...

            There are two ways to connect to the Azure Cosmos DB. You need to specify the way you want to connect to Azure Cosmos...

It is a pretty common use case to find the list of duplicate elements or rows in a Spark DataFrame and it is very easy to do with a groupBy() and a count()

When creating a linked server over a private endpoint from a Azure SQL Managed Instance to an Azure SQL DB database there’s one very important think to keep in...

Serverless Synapse SQL pools enable you to read Parquet/CSV files or Cosmos DB collections and return their content as a set of rows. In some scenarios, you would need to ensure that a reader cannot access some rows in the underlying data source.

In my role as a consultant, it’s rare that I go ...

Azure technologies evolve so fast sometimes we lose track of what’s happening. One day, a simple technology is created, on the next day, it becomes something huge, in a...

Building on the legacy of the PASS Summit conference, we’re pleased to share that this year’s free online PASS Data Community SUMMIT conference will be taking place November 8 - 12. Connect, share, and learn with a global network of data experts, covering today’s most challenging data platform topics. Sign up today to get the latest event updates and notifications.

On 23 June, Redgate Streamed brings you organizations who have implemented the latest database technology trends and will share their success stories and tips for embracing technology changes. Our fantastic speaker line-up includes expert John Martin, JQM Consulting, who will give you practical insights into estate management with SQL Monitor. And be the first to hear about the key findings from this year’s State of Database Monitoring survey!

GroupBy Conference is coming back May 25-26 for it...

See how Redgate’s SQL Data Catalog and SQL Provision tools enables you to keep sensitive data safe and stay compliant, without slowing your development down.

Dallas DBAs is proud to be sponsoring the May 2021 GroupBy Conference, Americas DBA track GroupBy is a different sort of conference as it has been online since it...

Writing to the screen is a really basic debugging technique. That said, since I’m really new with Powershell this is ... Continue reading The post #PowershellBasics: Writing to the screen...

Total: 4 Average: 4.8From a certain point in my career, I started to play around with PowerShell. But I never imagined that it would become such an essential thing...

Up until now, we’ve talked about various ways to...

I’ve talked about SQL Server comments before and...

Figuring out how to group the output of your Peste...

In part 3 of our "Better Together" blog series, I will recap my presentation from a series of BlueGranite Tech and Career Talks conducted in partnership with BDPA (formerly...

Senators reintroduce bill as scrutiny of social me...

In today’s post, we’ll talk about how you can use simple text to communicate numbers. You may be familiar with the following visual of our most commonly used visuals:...

An extension of a scatterplot, a bubble chart is commonly used to visualize relationships between three or more numeric variables.

Database systems have powerful features built right in that can ensure the integrity of data. In this article, Joe Celko discusses keys and constraints.

Reading Time: 4 minutes In this post I want to sh...

I work as Director at ThoughtWorks in the database and DevOps space. I’ve been here for 20+ years and I vaguely remember my first project at ThoughtWorks in 1999...

How to exploit the branching and merging capabilit...

Data flows are where we do the bulk of transformations and data cleansing. In this session, lets go ahead and create Data flow and run it. Open the ADF,...

There are advantages and disadvantages to both ETL and ELT. To understand which method is a better fit, it’s important to understand what it means when one letter comes...

H20 benchmarks well, but real-world performance and price remain to be seen.

CALENDAR: Returns a table with one column of all dates between StartDate and EndDate. https://dax.guide/calendar/ CALENDARAUTO: Returns a table with one column of dates calculated from the model automatically....

I got asked recently to help with a DAX measure for an interesting problem in the inventory domain. The requirement is to generate a chart showing the count of the last known State of a given number of items. Here is a walkthrough of what I was able to come up with, along with an explanation along the way.

REMOVEFILTERS: Clear filters from the specified tables or columns. https://dax.guide/removefilters/

Internet Explorer lives on in Edge IE Mode, LTSC W...

Using sequences when scaling up with Oracle RAC presents more issues with contention. In this article, Jonathan Lewis explains how to avoid the problems.

You’re Gonna Miss Me I deal with blocking proble...

Paul White concludes his series on starting parallel plans, summarizing how additional parallel tasks cooperate to complete plan execution. The post How Parallel Plans Start Up – Part 5 appeared...

We OPTIMIZE PERFORMANCE on a lot of models for Pow...

This is an update to an article that I wrote back in 2019. This time around I created a video to go along with the written explanation and documentation below. You can jump straight to the video below if you prefer that medium.

Original Post: Feb 2017 Updated: May 2021 I first wrote this article back in Feb 2017 to be a definitive list of the top reasons you should consider using...

Here's a twist on dynamically filtering visuals by...

Following on from my last post, another SQLBits session of mine I wanted to highlight was “Advanced Analytics Features In Power BI”. The subject is a bit outside my...

At the Microsoft Business Applications Summit 2021, a ton of new features for Power BI where announced. Below is my list of top ten new features, but there were... The...

How to save all your different types of SQL code snippets in a central library of JSON Snippet Collections, where you can search and edit each collection and then...

Rejoice! A new R release (v 4.1.0) is due on 18th May 2021. Typically most major R releases don’t contain that many new features, but this release does contain some interesting and important changes.

Correlation analysis, correlation is a term that is a measure of the strength of a relationship between two variables.

Total: 1 Average: 5 SQL Server Transactional Replication is one of the most common Replication techniques used to share, copy, or distribute data to multiple destinations. In this article,...

Investigation shows threat actors began probing SolarWinds' network in January 2019, according to Sudhakar Ramakrishna.

FragAttacks let hackers inject malicious code or c...

This seems to be a new tactic: Emsisoft has identified two distinct tactics. In the first, hackers encrypt data with ransomware A and then re-encrypt that data with ransomware B....

President Joe Biden’s infrastructure proposal includes billions of dollars tied to improving cybersecurity, an area of intensified interest after the ransomware attack on the Colonial Pipeline.

Google Duplex will soon navigate the "change password" interface of websites.

Researchers find watering-hole attack targeting water utilities.

Doctors left unable to access patient records afte...

Stopping payments would go a long way to stopping ...

Employee mistakenly sent the link when replying to a records request.

Welcome to part eighteen of the plansplaining series. Like the previous posts, this one too focuses on temporal tables and their effect on the execution plan. After looking at...

This is part 2 of a 14 part series on TSQL Basics. You will first gain an understanding of the differences between each of these types of joins, and...

A few years ago, I wrote that a CPU is “a hot mess of on-off switches.” There’s more to it than that when you get into the weeds of... The...

Total: 1 Average: 5 Cartesian product in SQL is a term from the set theory of mathematics. However, we can also find this term in SQL database manuals. What...

Transcription: What we’re going to be using is we’re going to be using Venn diagrams. So if you can see in this screen, we have two tables, table one...

It’s hard to set absolute rules about, “Feature X should absolutely never be used.” However, there are some features that set off alarm bells when I see them. Usually,...

Story time. Let’s say a database server is receiving a new release that include a change to a stored procedure. All of the databases are supposed to get the...

On May 10, 40 advocacy groups sent an open letter ...

WarnerMedia and Discovery to merge, and standalone AT&T will focus on broadband.

This article is all about declarative database development using Azure Data Studio for both beginners and professionals who are new to it.

Several times over the last few weeks I’ve gotten a request to create a new work database. The individuals from ... Continue reading The post Creating a configurable SSMS script...

A crazy error message The 'Ssms2017LoaderPackage' ...

I’ve been interested (obsessed?) with running SQL Server in containers for a while now, ever since I saw how quick and easy it was to spin one up. That...