Email Validation Simplified with Web API and SSIS
Email based validation is more than just a simple RFC check, this is where Melissa's Global Email Verification with a web-based API and SSIS delivers valuable data to SQL Server Professionals.
What is a Data Catalog?
A data catalog allows an organization to discover and record the facts about its data, where that data is held and how it used. William Brewer explains the details.
More On Column Order Indexes – Part 2
Continued analysis of index architecture with revised clustered index. Part 2 of Column Order Indexes
Reflections
Today is a day for reflections in Steve's life, looking back at the incredible year of 2020.
Database Updates: Rolling Back and Fixing Forward
Phil Factor's take on the best ways to reverse or accelerate your way out of the problems caused by a failed database update.
SQL Developer – A great tool and better ways to use it
SQL Developer is a popular free tool for working with Oracle databases. In this article Srinivasan Suresh explains several features of SQL Developer that can make you more productive.
Data Sovereignty Issues
As legal requirements grow and change, cloud computing might require a new consideration: where we physically store data.
Scheduling PowerShell Using Jenkins
Introduction PowerShell is a task-based command-line shell and scripting language; it is designed specifically for system administrators and power-users, to rapidly automate the administration of multiple operating systems (Linux, OSX, and Windows) and the processes related to the applications that run on those operating systems. For system administrators (DBAs\Wintel Admins), creating PowerShell scripts is a […]
Blogs
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers