How to Increase Query Speed With a Little Communication
How my former boss solved a performance issue by changing the business rules, instead of query optimization.
2010-07-14
27,365 reads
Stephen Hirsch
Beauty is in the Eye of the Beholder
Is dynamic SQL good or bad? We've had lots of arguments over the years in the forums and articles on both sides of the coin, though with most of the opinions being that dynamic SQL is bad. Stephen Hirsch brings us his own view that beauty is in the eye of the beholder.
2006-09-19
5,679 reads
What is XML?
The use of XML is growing all the time and if you listen to the media, XML is a technology you cannot do without. New author Stephen Hirsch brings us a look at XML from more of a skeptic's point of view.
2006-07-24
10,951 reads
Blogs
Azure SQL Training
By Arun Sirpal
I thought being an Azure Data/Database blogger I would share some amazing content from...
Managing virtual machine drives on ESXi
Recently I migrated my home lab from a SuperMicro SYS-E300-8D to something a little...
Thinking About the 2021 PASS Summit
By Andy Warren
I know that we don’t yet know how the 2020 Summit will turn out,...
Forums
Mobile DBA Tool for Android
Has anyone used Brain Box SQL app for Android in the google play store?...
Loading ODS strategies
Hi everyone, Just curious on others' approaches on this. So I'm developing a data...
THROW vs RAISERROR with bubbling up
Hi all, I know THROW is newer and recommended but I'm wondering if one...
Ask SSC