Data About Execution Plans
If you look at the Properties for the first operator of a graphical execution plan, you get all sorts of great...
2017-01-23
537 reads
Blog Posts
Datediff: We’ve Been Doing It Wrong
One of the most common mistakes people make when writing T-SQL is using a function in the where clause, and...
2017-01-23
2,250 reads
Error While running PowerShell code from SQL Agent job – “Path Does Not Exist”
Issue: When I am running code from PowerShell console its running fine but when I execute it through SQL agent...
2017-01-23
1,052 reads
How to Exclude Entire Sections in VS Schema Compare
Right now I am so excited, and a little embarrassed. After using Visual Studio (VS) for database projects for the...
2017-01-23
6,263 reads
Monday Coffee 2017-01-23
I like to think of myself as a fairly hardworking, motivated person. However I recently met someone who regularly gets...
2017-01-23
318 reads
Notes from the January 2017 oPASS/MagicPASS Meeting
This was a good meeting. About 50 attendees showed up at Nova (we use their space for joint meetings) to...
2017-01-23
382 reads
Power BI Subscriptions
Newly added to the Power BI Service is a much awaited feature called Power BI Subscriptions. If you’ve worked in...
2017-01-23 (first published: 2017-01-17)
2,292 reads
SQL Server 2016: JSON integration
Abstract
This article helps to explain the application of JSON data and the use of new SQL 2016 constructs that enable...
2017-01-23
5,416 reads
Useful #SQLPrompt Tips
One of the tools that Redgate write is SQL Prompt. This might be my favorite product, and I’m constantly impressed...
2017-01-23
712 reads
Using Extended Events Telemetry Session
You are probably wondering what this is, quite honestly I was wondering too. Well it is an extended events session...
2017-01-23
1,940 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers