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.
When Do We Worry About Scalability?
Steve has a few thoughts on the tradeoff between getting work done quickly and producing well performing code.
Auditing SQL Server – Part 4 – Database Configuration Audit
This continues my series on auditing SQL Server. The fist parts covered discovery and documentation, server level hardware audits and SQL Server engine level audits. This section examines database configuration audits.
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
CMS server query & temp tables
I am annoyed. We have a CMS server that has hundreds of servers saved...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers