If you’ve been reading these Database Fundamentals posts, you’ve already seen the WHERE clause because of your use of it when manipulating data with DELETE and UPDATE statements. It’s...
2019-10-21 (first published: 2019-10-14)
618 reads
My great organization, Redgate, is doing things a little different this year at PASS Summit. Instead of hosting our own event, we’ve decided to host a pre-con at the...
2019-10-08
56 reads
I’ve been teaching a lot more about SQL Injection lately (including blog posts). I’ve been doing this because, despite this being a 21 year-old problem with well defined solutions,...
2019-10-07
187 reads
While the CROSS JOIN is not used much, and, depending on the size of your data it can be dangerous, there are some uses for it. For example, you...
2019-10-03 (first published: 2019-09-23)
1,040 reads
Today Grant reminds us to not only think about the things we can do better, but remember the good things that we accomplish.
2019-09-28
191 reads
I’ve received several notes of thanks over the last couple of weeks. I’m not sure exactly what’s prompted this sudden outpouring because it’s all been about stuff I’ve done...
2019-09-27
39 reads
Grant takes a moment to thank the SQL Saturday organizers that put on these amazing events.
2019-09-27
124 reads
I’ve always felt responsible for making such a big deal about the differences between estimated and actual plans. I implied in the first edition of the execution plans book...
2019-09-18 (first published: 2019-09-09)
550 reads
I love going to SQLSaturday events because I’m always asked questions that make me think. I was just at SQLSaturday Indianapolis (a great event, if you weren’t there, you...
2019-09-09 (first published: 2019-08-19)
325 reads
You only have a few more weeks to sign up for one of my favorite events, Techorama. This year is the second time the event will be held in...
2019-09-03
14 reads
By SQLPals
SQL Server gMSA: Why DBAs Still Aren't Using It in 2026 ...
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
We have performed a side-by-side upgrade, from SQL Server 2016 to 2022 Developer Edition,...
Comments posted to this topic are about the item Automating OSM Data Refresh in...
Comments posted to this topic are about the item Database Mail Configuration
If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?
See possible answers