Since switching to dual 27 inch screens, I don't get migraines anymore.  My keyboard is a Microsoft SideWinder.  The most important part of it is the programmable keys. Single keystrokes...

I agree Ben.  Small systems usually have limited resources on hardware.  Joining 6 tables instead of 10 gives you quite a performance increase.  Also, and I know many people will...

For me the first mistake is that there should be an OUTER JOIN with sales with ISNULL(SL.SaleDate, GETDATE()) AS SaleDate, because not all stock are sold yet.  (It never is...

I am sorry Steve, but truncating data without the user knowing is an error.  It is frustrating that the source and target schema don't match, but it is still an...

Cat among the pigeons:  If you use TRY_CONVERT on a string, you as developer deliberately did so.  So then I would want a value to be returned if possible.

There is nothing wrong having to use SQL logins to do what you want to do.  I also misread this post as : Do NOT use SQL logins, do not...

So TRY_CAST is a new function.  Maybe you should specify the version. 🙂

If your app uses the AD account to determine the user's role in the application (no login and password to enter) and an encrypted config file (SQL Authentication) to connect...

The devils advocate in me just thought of something:  If the court rules that data in another country is inaccessible, then me as a crime boss, can keep my data...

We used a product called PureCM, because it was the cheapest.  At home I use it too, because the first two licenses are free. Simple, easy to install with merge...

I would like to point out something that the younger people do not think about, well not yet anyway.  When the wide screen was introduced, the physical character size on...

Why not CUD without lying?  I stood up many a time saying I don't pretend to understand everything right now, but anything is possible and it sounds like an x...

Sorry, not such a good question. 🙁

All of the above, but robustness must come with the ability to just continue, even if the network was down for x hours or the destination was wiped or the...