Understanding SQL Server Query Optimization – Part 2
An execution plan is the sequence of operations SQL Server query optimizer performs to run the statements. The SQL Server...
2013-12-14
1,280 reads
SQL Server Encryption Options
Many database servers store confidential data, which must be protected from unauthorized access when it’s transmitted across the network and...
2013-12-14
689 reads
Bulk Transfers: Some guidelines
Bulk transfers are a common way of importing large amounts of data into, or exporting large amounts of data out...
2013-12-14
561 reads
Understanding Triggers
A trigger is a specialized stored procedure that activates (executes) in response to an event. There are two basic trigger...
2013-12-14
705 reads
Possible ways to secure SSIS Packages
SQL Server Integration Services (SSIS) security is based around several layers that provide a rich and flexible security environment. These...
2013-12-14
726 reads
T-SQL Tuesday #49: Wait For It Roundup
A huge round of applause and my thanks to all of the participants and spectators for this month’s edition of...
2013-12-14
1,670 reads
Enabling High Performance Power Plan via PowerShell
One of the projects I’ve been working on recently was to automate our production SQL Server installs including our standard...
2013-12-13
1,971 reads
Android Annoyances
I wrote last week that I had switched back from Android to iOS, but I didn’t list out specific gripes...
2013-12-13
894 reads
Using Power Query to Parse your Inbox
One of the nice new features that was added to Power Query with the latest update in December is the...
2013-12-18 (first published: 2013-12-13)
2,689 reads
Reblog: December 6 to December 12
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-12-13
490 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