AI Is Great and Tech is Failing
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
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
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
Learn a step-by-step method to save your ADF pipelines in Git and automatically release new changes to test and production.
No Backdoors
Governments want backdoors built into encryption software, which Steve thinks is a bad idea.
EsProc SPL and SQL, Complimentary , But Different Technologies
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.
Bad Stored Procedures
Stored procedures can be poorly written, but Steve prefers them over embedded code.
Calculating Elapsed Times (SQL Spackle)
Calculating elapsed time between time values can be an interesting problem that is easily solved even when data anomalies are present.
Setup Excel as Front End Application for SQL Server
In this article, we walk through how to set up a simple Excel interface to work with SQL Server data to insert, update, delete, and select data.
Blogs
SQL from A to Z: Your Path to SQL Mastery this Fall
I'm excited to tell you about the "SQL from A to Z" learning track....
Introduction to Advanced Analytics
The post Introduction to Advanced Analytics appeared first on Joyful Craftsmen.
A New Word: Feresy
By Steve Jones
feresy – n. the fear that your partner is changing in ways you don’t...
Forums
The Cloud Security Problem
Comments posted to this topic are about the item The Cloud Security Problem, which...
Report server errors
http://servername/reports/browse/ could not load folder contents http://servername/reportserver The server principal "NT SERVICE\SQLServerReportingServices" is not...
Migrating standalone database to always-on cluster.
I am planning to migrate a currently standalone database to SQL Always On. This...
Question of the Day
AUTO_DROP Statistics
In SQL Server 2022, what does this statement do?
CREATE STATISTICS CustomerStats1 ON DimCustomer (CustomerKey, EmailAddress) WITH AUTO_DROP = ONSee possible answers