Reliably Drop A Database With CLR Stored Procedure
After I read Greg Low’s post and my initial try, I kept on thinking that I need to come up...
2014-01-22 (first published: 2014-01-20)
2,344 reads
Jeffrey Yao
Reliably Drop A Database With CLR Stored Procedure
After I read Greg Low’s post and my initial try, I kept on thinking that I need to come up...
2014-01-20
420 reads
Reliably Drop A Database In T-SQL Script
I read with interests about Greg Low’s post “Reliably Dropping a Database in a T-SQL Script is Too Hard”, I...
2014-01-07
1,111 reads
Reliably Drop A Database In T-SQL Script
I read with interests about Greg Low’s post “Reliably Dropping a Database in a T-SQL Script is Too Hard”, I...
2014-01-07
411 reads
Thoughts About MS Advanced Certification
Now MS has decided to cancel all its advanced certifications. I am here to share some of my thoughts on...
2013-09-16
730 reads
Thoughts About MS Advanced Certification
Now MS has decided to cancel all its advanced certifications. I am here to share some of my thoughts on...
2013-09-16
384 reads
Agile Database Administration
I first heard the word “agile <something>” about 10 years ago, I do not have profound experience to what “agile...
2013-06-12
1,301 reads
Agile Database Administration
I first heard the word “agile <something>” about 10 years ago, I do not have profound experience to what “agile...
2013-06-12
345 reads
Database Administration KPIs – 2/2
In my last post, I discussed about the quantitative KPIs which, to me, are useful for “outsiders”, i.e. non-DBAs, to...
2013-05-10 (first published: 2013-05-04)
5,196 reads
Database Administration KPIs – 2/2
In my last post, I discussed about the quantitative KPIs which, to me, are useful for “outsiders”, i.e. non-DBAs, to...
2013-05-04
914 reads
Blogs
Getting SQL Server 2025 RTM Running in Containers on macOS
SQL Server 2025 RTM is here, and if you’re running Docker on macOS, you...
The PASS Data Community Summit 2025 Recap
By Steve Jones
It’s Monday. I’ve been home since Fri night, but with a busy weekend, I’m...
Microsoft Post-Quantum Crypto APIs Are Now Generally Available
By Brian Kelley
I mentioned this in my talk on Quantum Computing at the PASS Data Community...
Forums
SQl Server 2014 linked server remote server
Hello all, I have a linked server created on an instance which only has...
Find all the tables in a database containing particular column value
Hi, I want to find all the tables name under a database where tables...
The Ending Substring
Comments posted to this topic are about the item The Ending Substring
Question of the Day
The Ending Substring
In Azure SQL Database and SQL Server 2025, if I run this, what is returned?
SELECT '[' + SUBSTRING('Steve Jones', 7) + ']' See possible answers