T-SQL Programming

Joe Celko in T-SQL Programming

BETWEEN the two of us

BETWEEN can be used in a SQL WHERE clause to filter on a range. Joe Celko explains the history of...

15 November 2021 11 min read

Learn SQL Server

Greg Larsen in Learn SQL Server

Using SQL Server sequence objects

SQL Server sequence objects have several properties that control how they behave. Greg Larson explains the options of using SQL...

15 November 2021 14 min read

Security

Robert Sheldon in Security

Ransomware: A world under threat

Ransomware has threatened many organizations over the past few years. In this article, Robert Sheldon explains the history of ransomware...

01 November 2021 12 min read

Learn SQL Server

Greg Larsen in Learn SQL Server

Introduction to SQL Server sequence objects

SQL Server sequence objects can be used in place of identity columns. In this article, Greg Larsen explains how to...

25 October 2021 15 min read

BI

Sanil Mhatre in BI

Text Mining and Sentiment Analysis: Data Visualization in Tableau

Tableau is a popular visualization tool used by organizations around the world. In this article Sanil Mhatre demonstrates sentiment analysis...

18 October 2021 19 min read

Performance

Edward Pollack in Performance

Automating SQL Server Extended Events: Permanent Tables and Scheduled Collection

Automate SQL Server Extended Events data collection: store event XML in permanent tables, build a stored procedure to manage the...

04 October 2021 19 min read

Security

Robert Sheldon in Security

Cybersecurity threats

Not a week goes by without news of a new cyberattack. In this article, Robert Sheldon explains the cybersecurity threats...

30 September 2021 12 min read

CI/CD

Sebastian Meine

Liz Baron in CI/CD

How to successfully deploy databases with external references

Database objects often have references to external databases which makes continuous integration problematic. In this article Liz Baron and Sebastian...

29 September 2021 8 min read

Learn SQL Server

Greg Larsen in Learn SQL Server

Working with SQL Server identity columns

SQL Server identity columns are easy to add to a table, but you must understand how they work to use...

24 September 2021 12 min read

PowerShell

Greg Moore in PowerShell

Building an ETL with PowerShell

There are many ways to load data into a SQL Server database. In this article, Greg Moore demonstrates how to...

22 September 2021 11 min read

Database Administration

Edward Pollack in Database Administration

SQL Server Extended Events: Creating Sessions, Events, Actions, Filters, and Targets

Build a SQL Server Extended Events session from the ground up - choosing events, attaching actions, applying filters, selecting targets...

14 September 2021 15 min read

T-SQL Programming

Kathi Kellenberger in T-SQL Programming

LAG in SQL Server: Performance vs Self-Join, CTE, APPLY, and Cursors Benchmarked

Benchmarked comparison of the SQL Server LAG function against eight alternative techniques for including a column from a previous row:...

07 September 2021 13 min read

Azure

Robert Sheldon in Azure

The Azure SQL portfolio

Microsoft provides many ways to run SQL Server in Azure, but which do you choose? In this article, Robert Sheldon...

01 September 2021 14 min read

BI

Sanil Mhatre in BI

Text Mining and Sentiment Analysis: Oracle Text

Oracle has built-in functionality to analyze text. Sanil Mhatre demonstrates how to perform a sentiment analysis on data stored in...

30 August 2021 12 min read

Learn SQL Server

Joe Celko in Learn SQL Server

A UNIQUE experience

A properly designed table must have a key to uniquely identify each row. In this article, Joe Celko explains unique...

23 August 2021 14 min read

Learn SQL Server

Greg Larsen in Learn SQL Server

SQL Server identity column

The SQL Server identity column is used to populate a column with incrementing numbers on insert. In this article, Greg...

23 August 2021 13 min read

Performance

Fabiano Amorim in Performance

SQL Compilations/sec: What This Metric Really Means

Why the standard SQL Compilations/sec guideline is misleading for ad hoc workloads. Covers plan cache behavior, auto-parameterization, forced parameterization, and...

29 July 2021 25 min read

Database Administration

Greg Larsen in Database Administration

Improving performance with instant file initialization

Instant file initialization can speed up database creation, file growth, and restores. Greg Larsen explains how to configure it and...

23 July 2021 12 min read

Performance

Edward Pollack in Performance

Collecting SQL Server performance monitor data

SQL Server provides information for troubleshooting performance. Ed Pollack demonstrates collecting SQL Server performance monitor data.…

20 July 2021 20 min read

SQL Server

Priyanka Chouhan in SQL Server

SQL Server High Availability and Disaster Recovery: Always-On AGs, Log Shipping, Failover Clusters, and DR Planning

Complete SQL Server HA/DR guide covering terminology (RTO, RPO, RLO), high-availability options (Always-On Availability Groups, failover clusters, database mirroring), disaster...

14 July 2021 27 min read