Determine Referenced Objects in the Stored Procedures
It is very common to see in a relational database that stored procedures are using many Tables, Views, Sequence Object,...
2018-05-01
1,858 reads
PoshSSDTBuildDeploy Updated - Now With Install .NET!
Hello!
I’m currently working on a project that requires building and deploying SSDT-based projects. So it’s been a great opportunity of making use of PoshSSDTBuildDeploy and work through any issues....
2018-05-01
29 reads
SQL Server Removing Outliers With Standard Deviation
When running aggregations for reporting in some situations outliers can throw out the numbers.
For example lets say we have a...
2018-04-30
382 reads
Guide for Setting up Telegraf to Monitor InfluxDB
Problem
If you been reading this series you are used to looking at Windows and SQL Server but who knows what...
2018-04-30
210 reads
Guide for Setting up Telegraf to Monitor InfluxDB
Problem
If you been reading this series you are used to looking at Windows and SQL Server but who knows what...
2018-04-30
1,814 reads
Security: Create and view Audit Logs
It is important to have a secure environment, enforcing the least privilege principle in your servers and databases, but this...
2018-04-30
5,428 reads
Automating Automatic Indexing in Azure SQL Database
I’ve been in love with the concept of a database as a service ever since I first laid eyes on...
2018-05-07 (first published: 2018-04-30)
1,955 reads
SQL and Azure Maze
Something fun for the end of the month. Here are a handful of mazes for you to enjoy. I found...
2018-05-08 (first published: 2018-04-30)
1,963 reads
Shiny Tech Syndrome
This is the name I give to anyone who, whilst learning a new technology, suddenly thinks it’s the best thing...
2018-04-30
373 reads
A Perfect Solution to Resolve SQL Server Error 211
SQL Server Schema is basically a collection of SQL Objects that includes the tables, related columns, its entries, or other components. Due to this, it becomes easy for a...
2018-04-30
28 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers