Maybe It Is DNS (2021-10-23 DBW)

Maybe It Is DNS

There are jokes about how often DNS is a problem. There are stickers, shirts, and mugs you can buy. There's a classic haiku, which leads into a rant about the struggles of sysadmins. I will admit that I know a little about DNS, but I find myself confused at times and usually seek assistance from others when something doesn't work. The old days of a single MX record and a few A records to map names to IPs has grown into a much more complex system.

DNS usually works. In fact, it's lower on my list of things to check these days, though I do often get a quick DNS check when I ping an address. There are some failures, and these days when large companies have issues, it can affect a lot of people. Akamai had an issue and knocked off a large chunk of the Internet. When Facebook had an issue recently, it not only affected customers, but the engineers that were trying to fix things. Some couldn't even get into buildings. I guess relying on a single domain might be a bad idea.

Most of us rely on DNS in our organizations, which means that a rising level of DNS based attacks is disconcerting. These are still behind the issues we have with ransomware and DDoS attacks, but when DNS doesn't work, a lot of stuff shuts down. I could see a lot of people that work inside a company's domain for most of their work being unable to accomplish anything.

I tend to use a number of domains for my daily work. Evernote and Dropbox are essential, but if one were down, I could still do things with local copies. Red-gate.com is certainly important, but as long as SQL Server Central is up, I can do something different. Actually, if both were down, I could still write or create questions. I'm more bothered by slowness in my connection or machine than losing any particular service.

I haven't every been too worried about DNS security, but I left sysadmin work when it was a simpler time. These days, I suspect many organizations might want to be sure they are paying attention. If they use a lot of services connected to one domain, I might think about having a secondary domain connected to a few. If I were in charge, a sqlservercentraladmin.com might be one I'd set up.

Steve Jones - SSC Editor

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

Although it is easy to get started with Flyway, there are times when real-life can trip you up. Discover the fastest ways to restore the previous version of the database, to recover from a failed Flyway migration that leaves the database in an indeterminate state, and then how to adapt your database development process to avoid these problems.

Two key findings from Redgate’s recent State of Database Monitoring Survey of over 2,500 IT professionals were that 79% of respondents reported using either a third-party or in-house monitoring tool and the satisfaction rate with third-party monitoring tools is at an all time high of 86%. But when should you use an in-house tool, and when should you take the plunge and invest in a third-party monitoring tool like SQL Monitor?

Flyway Teams has an Undo facility that enables you to roll back one or more migrations. This article demonstrates how it works and explains how Undo migrations make testing migration scripts easier and branch-based development simpler.

Yes! After more than 10 years, scikit-learn released its 1.0 version on 24 September 2021. In this post, I'd like to point out some personal highlights apart from the release highlights.

Much has been written about struggles of deploying machine learning projects to production. As with many burgeoning fields and disciplines, we don’t yet have a shared canonical infrastructure stack...

Question: I have seen new database in my server. that was created nearly 45 days back. I have tried to check using standard report but no luck. SQL version: SQL server 2017 enterprise. Is it possible to find who created database.

In this article we look at how to get the correct ...

When we query for data, we don’t always think about the magic that goes into efficiently returning results. One vital piece to this magic is statistics. Statistics in SQL...

Lots to think about when it comes to a SQL Server 2019 upgrade

Let’s imagine a scenario. It’s one that I’ve been through and I suspect it’s one that some reading this post have been through as well. You come in on...

Learn how to customize the drillthrough experience in Excel PivotTables connected to Power BI datasets or Analysis Services databases.

This is an updated version of the presentation I did earlier in the year which I recently presented for the Minnesota Data Saturday 13 event this past weekend. Here...

In this article, we will learn how to create dashboards using the data that is typically processed using notebooks in Azure Databricks. Introduction In this article, we will learn...

It’s possible to query blob storage using SQL, b...

Lately I’ve been doing some exploratory performance testing on Azure SQL Managed Instances in preparation for a migration to that platform. This blog post documents some storage testing results...

Out of the box, Azure Data Lake Storage Gen2 provides redundant storage. Therefore, the data in your Data Lake(house) is resilient to transient hardware failures within a datacenter through automated replicas.

I haven’t done much blogging in the last 6 months. My last article was posted in January, on Data Governance in the Covid era. After changing jobs in March,... The...

Last week, Steve Jones (@way0utwest), Grant Fritch...

When I was presenting at the dataMinds Connect conference, I called on someone in the audience. At the time, I called on someone raising their hand and said something... The...

Microsoft Cloud Workshops are free, step-by-step guides for implementing solutions in Azure. As part of the work I do with Solliance, I’ve assisted in creating and maintaining several MCWs in...

In this article we cover technical skills and soft skills that are typically found in successful BI developers.

To celebrate the holiday season, we give back to those who spend their entire year giving back in their own communities. We go looking for data professionals who make...

With the advent of Internet of Things (IOT) and th...

Did you know that Jupyter Notebooks can be automat...

In the ever-growing field of big data, Apache Kafka has become a widely adopted distributed streaming platform. From message queuing to event streaming, Apache Kafka delivers on a wide range of use cases. Its high throughput, scalability, and fault tolerance make it the clear-cut choice as an open source event handler.

Troy Hunt, Information Security Author & Instructor at Pluralsight, Microsoft Regional Director, and Founder of Have I Been Pwned joins Steve Jones to discuss the critical and complex role of monitoring in organizational data security and compliance.

Succeeding as a data professional is all about pla...

As we all know there is already a lot of information available about SQL Server related topics in English. But I’m also dealing more and more with customers who... The...

I’ve got a project I’m working on at the momen...

This is part of the series Finding Ghosts in Your Data. For the inaugural post in this series, I want to spend a few moments on terminology. What’s the...

This post has been on my backlog for about a year,...

Last month, we invited you to envision education by sourcing some compelling data related to schools, academia, or learning and producing a visual that makes the “so what?” clear....

Aaron Bertrand sticks up for NULL: A long time ago, I answered a question about NULL on Stack Exchange entitled, “Why shouldn’t we allow NULLs?” I have my share...

Click to learn more about author John Pocknell. In today’s competitive enterprise landscape, having a proper DataOps strategy in place correlates with better data intelligence and optimization within an organization –...

Runbot is a bespoke continuous integration (CI) solution developed specifically for Databricks’ needs.

GraphQL is a platform-independent, language-neutral query language and may be used to run queries and retrieve data. Joydip Kanjilal explains how to use GaphQI in an ASP.NET Core 5...

As simple as this question sounds, we get this question a lot. So we decided to write a post on finding the version of Hadoop and […] The post How...

Back in my day, we stored SQL Server Integration S...

Experiencing a disaster is one of the worst possible events for both businesses and their IT departments. However, there is one worse event – failure to recover from the...

So how about flooding or hurricanes? I live in the United States Pacific Northwest, about as far away from Florida as you can be in the lower 48 United...

The Surface brand is full of products that tried s...

With its new processors and devices, Apple is aiming squarely at the high-end chips that Intel has provided for the MacBook Pro and other top-end Macs for about 15...

Learn various ways to concatenate strings in Power...

DAX is simple, but it is not easy. Watch the video...

The Binary DAX data type is used in the data model to store images or other non-structured types of information. https://dax.guide/dt/binary/

The Windows 10 November Update, or 21H2, is now av...

Use The Force I had a RABID FAN ask me an interesting question about a query. I can’t use theirs, but I can repro the question. The question was: if using...

Temptables I was helping a client troubleshoot a scalability issue recently, where during one point in their workload tempdb went out of control. What was puzzling them was that nothing in...

Tableau is a popular visualization tool used by organizations around the world. In this article Sanil Mhatre demonstrates sentiment analysis with Tableau and Oracle data.

Last year I blogged about handling multi-select scenarios for dynamic M parameters. Since then support for “Select All” has been added (see here) but since a regular slicer with...

Azure Purview, which recently became generally ava...

Flyway baseline migration scripts are a simple and fast way to deploy new copies of a database, at a specific version, for testing work, or to create a new...

During the development cycle, the mechanics of reliable delivery must not be allowed to dominate the design work. With script callbacks in Flyway Teams, many of the development tasks...

Mastering Kafka Streams and ksqlDB: Building real-time data systems by example by Mitch Seymour I’m fascinated by the duality between streams and tables, the mixing of data at rest...

Microsoft.Data.SqlClient 4.0 Preview 3 has been re...

A new set of security tools is built to assess ris...

Unsupervised Learning is a common approach for discovering patterns in datasets. The main algorithmic approach in Unsupervised Learning is Clustering, where the data is searched to discover groupings, or clusters, of data. Each of these clusters contain data points which have some set of characteristics in common with each other, and each cluster is distinct and different

In this article we look at how to generate different types of pie charts using Python and SQL Server.

So you want to train your knowledge on irregular verbs or your child is learning all forms of the verbs or you are getting prepared for post-covid travel a...

Plot() function is R’s most generic function for plotting different types of graphs. And making a animation of sample graphs with is as useless as it can be useful...

We choose this photo for the cover because this wa...

Roger Grimes on why multifactor authentication isn...

Response and recovery have significant impact on 5...

WellSpan Health employs a large number of external vendors and workers, creating security challenges. Here's how the health system improved third-party security.

Someone has been hacking telecommunications networks around the world: LightBasin (aka UNC1945) is an activity cluster that has been consistently targeting the telecommunications sector at a global scale since at...

Research by ThycoticCentrify shows a majority of organizations experienced a ransomware attack, while 93% are allocating special budget to fight growing threats.

Password managers, single sign-on, and multifactor authentication each offers its own methodology and unique set of benefits — and drawbacks — to users.

The Missouri governor wants to prosecute the reporter who discovered a security vulnerability in a state’s website, and then reported it to the state. The newspaper agreed to hold off...

I talk about NULLs in SQL Server, the logical issu...

In this article we compare performance differences when splitting comma separated strings using TVPs, TVFs, openjson, string_split and more.

In this article, we will learn how to use SQL LEFT function with straightforward examples. What is the SQL LEFT function? Most of the time we need to work...

I was chatting with Jeff (b|t) on my team yesterday and the context escapes me but I had this thought: “Can you Group By the beginning characters, or a... The...

After seeing multiple people switch from STRING_SPLIT() to OPENJSON() to deal with multiple parameters, I decided to explore whether that is a change in the wrong direction.

In our continuing adventures with the TOP operator...

Updated this stored procedure I wrote a decade ago to search for a string in procedure bodies, object names, job steps, and more...

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw a post on using STRING_SPLIT() with... The...

Kicking off another earnings season, Intel is once again leading the pack of semiconductor companies in reporting their earnings for the most recent quarter. As the company gets ready...

So why don't all rocket engines have giant nozzles?

This article explains upgrading SQL Server Management Studio (SSMS) and Azure Data Studio (ADS) to their latest version with a single installation. Introduction SQL Server Management Studio, aka SSMS,...