SQL in the City Back in London
It’s just a couple weeks until the SQL in the City Summit comes back to London. This is our second Summit this year in London, and I’m honored to...
2019-10-17 (first published: 2019-10-11)
216 reads
Blog Posts
SQL in the City Comes Back to Seattle
This year at the PASS Summit, Redgate is holding our SQL in the City Summit as one of the pre-con events at the conference. You can add this in...
2019-10-17
14 reads
Workshop Report: Overcoming Obstacles on the Journey to Continuous Delivery for Databases (video with transcript)
I am living the dream, y’all: yesterday I was finishing up my workday and needed to record a video, but realized that our puppy had spent enough time in...
2019-10-17
6 reads
Azure Fundamentals 12th December
Certified Microsoft Azure Fundamentals - AZ-900 1 day Web based Course - 12th December 2019
Its been a big few of weeks here at gethynellis.com. We've been accepted onto the UK...
2019-10-16 (first published: 2019-10-11)
363 reads
SQLCover 0.5 - Fixes, smaller features and an exciting surprise
It has been a little while but I have updated SQLCover to include a number of fixes and small features, the majority of which are improvements to the html...
2019-10-16
6 reads
Upcoming SQLpassion Online Trainings
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2019-10-16 (first published: 2019-10-10)
251 reads
Using indexed views? What is an imprecise or non-deterministic convert?
After last week’s post about using WITH (NOEXPAND) to query indexed views even on SQL Server Enterprise Edition, this week is a short but interesting side-road into deterministic values,...
2019-10-16
31 reads
Are Stored Procedures Faster Than Stand-Alone Queries?
Watch this week's video on YouTube
A few months ago I was presenting for a user group when someone asked the following question:
Does a query embedded in a stored procedure...
2019-10-15
6 reads
Are Stored Procedures Faster Than Stand-Alone Queries?
Watch this week's video on YouTube
A few months ago I was presenting for a user group when someone asked the following question:
Does a query embedded in a stored procedure...
2019-10-15
12 reads
Dynamic Column Level Security with Power BI and SSAS
Last week I was asked to tackle a requirement by a customer adopting Analysis Services to enable data exploration and ad hoc analysis by their users. One of their...
2019-10-15 (first published: 2019-10-09)
807 reads
Blogs
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers