The Tech & Gear of PASS Summit 2017
Continuing my series of posts about my PASS Summit 2017 experience. This is about gadgets/gear I brought & software I used, the gadgets I saw around the convention center,...
2017-11-13
9 reads
Adaptive Query Processing and Automatic Tuning - Introduction - 1
SQL Server 2017 and Azure SQL Database are being touted as the self learning, artificial intelligent database. One of the...
2017-11-12
544 reads
Top 5 Reasons Why I think SQL Server on Linux is Legit
Here are my top 5 reasons why I thing SQL Server on Linux is Legit!
SQL Server on Linux is Fast – Earlier this year SQL Server on Linux posted...
2017-11-12
6 reads
Top 5 Reasons Why I think SQL Server on Linux is Legit
Here are my top 5 reasons why I thing SQL Server on Linux is Legit!
SQL Server on Linux is Fast – Earlier...
2017-11-12
874 reads
Login failed for 'NTAUTHORITY\ANONYMOUS LOGON' - the fix you probably haven't tried yet
Just a quick one today. TL;DR: Remove yourself from some unnecessary AD groups.
If you've ever received the message "login failed...
2017-11-24 (first published: 2017-11-12)
3,374 reads
Dealing with disquiet
Last week I listened to a podcast from one of my best friends in the sql community – Kendra Little. In...
2017-11-23 (first published: 2017-11-11)
1,974 reads
Finding Input Parameters in an Execution Plan
The query execution plan is a map of work which SQL Server is going to perform to execute a query....
2017-11-22 (first published: 2017-11-11)
7,143 reads
AWS – No Password? No Problem! Generating Redshift Credentials via IAM Authentication
I know we are living in a world where phones and other devices with advanced biometric authentication have been increasingly...
2017-11-10
321 reads
Presentation Files for my Webcast on Troubleshooting Connection Problems
Thanks to everybody who attended my webcast Troubleshooting SQL Server Connection Issues yesterday. If you missed it, the recording will...
2017-11-10
621 reads
Comparing Agent Jobs across Availability Group Replicas with PowerShell
On the plane home from PAS Summit I was sat next to someone who had also attended and when he...
2017-11-27 (first published: 2017-11-10)
1,554 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers