Public Role Permissions – Back to Basics
If you are being serious in your role, then the amount of times you grant permissions to the public role should either be a) never, b) when you want...
2019-07-01 (first published: 2019-06-17)
358 reads
Blog Posts
Scalar Valued Functions in SQL Server 2019
(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-07-01 (first published: 2019-06-18)
1,626 reads
SQL Homework – July 2019 – Table Size
In general this homework series is meant to give you ideas of things to play with that most if not ... Continue reading
2019-07-01
137 reads
Weekly reading #20
Being MVP for the #11 straight year is something unique! Thank you! The first week of July has just started. So oficially we have started vacations and the team...
2019-07-01
24 reads
Thanks for Joining us at SQLSaturday Pensacola!
Thanks for joining us at #SQLSatPensacola!The 8:30am Careers in Technology panel featured lots of talk about Twitter, so might as well mention that the panelists were (in audience's order,...
2019-06-30
15 reads
Powershell script to find SQL Server instances on remote servers
This is actually part 2 of a process I am creating to automatically discover SQL Server instances in an Active Directory domain. So there will be a series of...
2019-06-28
7,591 reads
T-SQL Tuesday #115 – Dear 20-Year-Old Self
This month’s T-SQL Tuesday blog is brought to us by Mohammd Dorab (b | t) and this month topic is about what you would tell your 20-year-old self now...
2019-06-28 (first published: 2019-06-11)
308 reads
T-SQL Tuesday #115 – Notes to 20 year old Wayne
There’s a lot that goes on in June. From the 75th anniversary of D-Day, Fathers Day, to the official start of summer (though it feels like it already!)....
2019-06-28 (first published: 2019-06-11)
245 reads
Detail Job History – Back to Basics
With this script, I have the ability to quick show which step is failing, what the command is for that step, what kind of process is running on that...
2019-06-27
10 reads
Detail Job History – Back to Basics
With this script, I have the ability to quick show which step is failing, what the command is for that step, what kind of process is running on that...
2019-06-27
94 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers