SQL Server Community

SQL Server Blog

Denny Cherry
Follow /18 Jun 2018 at 8:29pm / SQL Server Blog

JSON documents in Azure and IF/THEN blocks

If you do any work in Azure you’ve probably done deployments using JSON scripts. Originally JSON in Azure didn’t support much, you could create objects, but if you put it in the JSON script, it would be created. Thank thankfully isn’t...
158 0 /
Bert Scalzo
Follow /21 May 2018 at 10:54pm / SQL Server Blog

What Happened to My Database?

Every DBA has at some point asked: “What the heck happened to my database?” In this blog, we’ll review some of the more common scenarios where some little detail slips through the proverbial crack and that often results in some kind...
109 0 /
Denny Cherry
Follow /7 May 2018 at 7:00am / SQL Server Blog

It’s getting all cloudy in here

Not all cloud providers are the same. Some are flexible and will grow and shrink with your needs and business (Azure, Amazon, Google Cloud), and some will not (IBM, Rackspace, Other Bare Meta l clouds). The whole goal of using a cloud provider is to be...
125 0 /
Bert Scalzo
Follow /6 May 2018 at 12:38am / SQL Server Blog

TEMP is A Four Letter Word

It’s not uncommon to observe rampant over reliance of database application code on TEMP tables, most often as a SQL language programming crutch. I have a theory as to why. Programmers are chiefly taught record oriented or “record at a time...
125 0 /
Denny Cherry
Follow /23 Apr 2018 at 5:00pm / SQL Server Blog

PASS Summit 2018 Here I Come

I’m thrilled to be able to say that I’ll be presenting a precon at the PASS Summit 2018.  This year I’ll be giving a precon on database security.  In this session we’ll be going over the various security features within Microsoft...
153 0 /