Missing Indexes in the Query Store
I’ve shown before how to use the DMVs that read the plan cache as a way to connect the missing...
2019-03-22 (first published: 2019-03-11)
2,368 reads
Blog Posts
Secure Travel
Traveling in today’s age of technology is a lot easier than in the past. You can start your journey in...
2019-03-22 (first published: 2019-03-08)
1,993 reads
SQL Server Data Pages on Linux
One of the new phrases coming out of Microsoft is that “SQL is just SQL” regardless of what operating system...
2019-03-22
457 reads
Thinking about Setup and Installation
I’m working the first section of a basic administration course, and the first part of this is installing SQL Server...
2019-03-22
479 reads
Toolbox - Exporting SSMS Results to Excel
I was working on another post when I found myself needing to dump out query results to a grid format...
2019-03-22
699 reads
Webinar: Change Detection in SQL Server
Change detection is a critical component of any system that moves data from one structure to another. Most data movement mechanisms are designed to move a subset of the...
2019-03-22
8 reads
Webinar: Change Detection in SQL Server
Change detection is a critical component of any system that moves data from one structure to another. Most data movement...
2019-03-22
398 reads
Microsoft Azure – How to create the Azure Active Directory (AD) using Azure Portal
Microsoft Azure Active Directory (AD) is a cloud based service to handle the identity and access management. It has the...
2019-03-21
526 reads
SQL Server 2017 Reporting Services: The Basics Part 5
We’re now on Part 5 of our SQL Server Reporting Services Basics Series. In this installment, we’ll learn how to...
2019-03-21 (first published: 2019-03-09)
3,421 reads
There is Now A Delete Activity in Data Factory V2!
Data Factory can be a great tool for cloud and hybrid data integration. But since its inception, it was less...
2019-03-21 (first published: 2019-03-07)
1,908 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers