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,334 reads
DBA Philosophy
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
414 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,105 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
408 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
726 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
383 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,290 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
342 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,194 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
913 reads
Blogs
A Conversation That Refused to End: What We Learned from Our First Event in Zurich
On May 8, 2025, we hosted our first official event in Switzerland at Prime...
A DevOps Workshop Tomorrow in Atlanta
By Steve Jones
Tomorrow is the Redgate DevOps Day in Atlanta. You can still sign up, so...
Stop Wasting Time Rebuilding Indexes Every Night
By Kevin3NF
Too many IT teams run index rebuild jobs on autopilot. Every night. Every index....
Forums
CAST(VARCHAR(n)) resolved performance issue?
Hi, I would love to hear if anyone can tell me why a CAST...
isnull, coalesce overhead
hi, one of our sister division's erp extract view is going thru at least...
is there an elegant way for agent notification to show failure if any step fails
hi our corp dw load sqlagent job goes to the next step on the...
Question of the Day
The Internals of Writing a Page
In SQL Server, when the buffer manager write pages to disk, page protection is added to the pages. There are two types of protection: torn page protection and checksum page protection. What happens with regards to concurrency with page protection during writes?
See possible answers