Azure Data Studio (ADS) is a lightweight IDE built...

Bad Data and Dirty Databases

by Additional Articles

SimpleTalk

Database Design and Implementation

Many years ago, my wife and I wrote an article for Datamation, a major trade publication at the time, under the title, “Don’t Warehouse Dirty Data!” It’s been referenced quite a few times over the decades but is nowhere to be found using Google these days. The point is, if you have written a report using data, you have no doubt felt the pain of dirty data and it is nothing new.

The PASS Data Community Summit Session Schedule is LIVE!

by Additional Articles

PASS

Uncategorized

Join over 170 global data experts offering more than 150 sessions designed for all skill levels. Explore the schedule to plan your days on-site, secure your ticket, and book your travel before prices increase.

AI Is Great and Tech is Failing

by Steve Jones

SQLServerCentral

Technology

Steve is a little disappointed in technology that didn't work well after a security incident.

Stairway to Advanced T-SQL Level 9: Compare, Modify, Derive and Validate Date and Time Values

by Gregory Larsen

SQLServerCentral.com

When you build applications that store data in SQL Server you will most likely have to store dates and times, and you’ll call functions to do date manipulations. It is important to understand the different date and time data types, and when to use one data type over another. In this level I will be exploring the different date and time data types and discussing when each type is appropriate.

Raising the Cost Threshold for Parallelism (CTFP) Affects SQL Server Missing Indexes

by Additional Articles

MSSQLTips.com

This article explores how raising the Cost Threshold for Parallelism (CTFP) affects missing index recommendations in SQL Server along with examples.

GIT Configuration and Automated Release for Azure Data Factory

by Sucharita Das

SQLServerCentral

Learn a step-by-step method to save your ADF pipelines in Git and automatically release new changes to test and production.

No Backdoors

by Steve Jones

SQLServerCentral

Governments want backdoors built into encryption software, which Steve thinks is a bad idea.

EsProc SPL and SQL, Complimentary , But Different Technologies

by Additional Articles

SimpleTalk

Uncategorized

Have you ever surfed the internet and felt overwhelmed by personalized advertisements that appear to know your every desire? Have you ever been amazed at how accurate some weather forecasts can be? These actions are based on data processing. EsProc SPL and SQL (note, SPL stands for Structured Processing Language and SQL stands for Structured Query Language). SQL is a major language widely encountered and used for data manipulation within relational databases. While EsProc SPL is another effective tool for data processing, especially suited for complex computations and in-memory operations, it is less commonly encountered.