CREATE SCHEMA can do what?!?!?
So I was studying for the 70-451 and ended up reading the BOL entry for CREATE SCHEMA. I honestly can’t...
2013-05-21 (first published: 2013-05-15)
4,138 reads
So I was studying for the 70-451 and ended up reading the BOL entry for CREATE SCHEMA. I honestly can’t...
2013-05-21 (first published: 2013-05-15)
4,138 reads
In the same vein as Steve Jones’ series on Customizing SSMS this is a fairly basic trick, but one that...
2013-05-16 (first published: 2013-05-13)
3,855 reads
I was reading through Stackoverflow today and saw an interesting question. SQL inner join vs subquery. The user was comparing...
2013-05-08 (first published: 2013-05-03)
5,922 reads
2013-05-08
1,361 reads
Did you know that the GO command isn’t really part of T-SQL? It’s what’s called a batch separator. And in...
2013-05-06
918 reads
So I am now an MCITP Database Developer for SQL 2008. This is a big milestone for me. A few...
2013-05-01
809 reads
I spend a reasonable amount of time looking through various forums, answering some questions and reading the answers to others....
2013-04-29
2,616 reads
I’ve occasionally had the problem of trying to put “smart” logging messages into a process. You know the ones, you’re...
2013-04-24
802 reads
I’ve been thinking recently about who writes the best documentation. Not including a professional technical writer (although they actually do...
2013-04-22
814 reads
This one is basic but still something that can catch you unawares if you aren’t careful. Most DBAs and developers...
2013-04-15
1,423 reads
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...
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
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