SQL Server Community

SQL Server Blog

Denny Cherry
Follow /1 Jan 2018 at 4:00pm / SQL Server Blog

Happy New Year, Welcome to 2018

It’s 2018 and welcome to it.  Here’s hoping that 2018 is a easier year than 2017 was. For me, that means no brain tumor this year.  Hopefully that’s a easy bar to hit. Denny The post Happy New Year, Welcome to 2018 appeared first...
169 0 /
Denny Cherry
Follow /26 Dec 2017 at 8:00pm / SQL Server Blog

When does it make sense to upgrade?

There’s a lot of versions of SQL Server available today.  I’ve seen clients deploying new services on SQL Server 2015, SQL Server 2016, SQL Server 2017 (yes we have a client on SQL Server 2017 already) and SQL DB.  But if you’re deploying...
148 0 /
Denny Cherry
Follow /19 Dec 2017 at 4:00pm / SQL Server Blog

What does SQL encrypt by default?

For the purposes of this, we’re ignoring SQL Server 7.0 and below. Out of the box, SQL Server will encrypt some things by default to protect you and your data.  Out of the box, SQL Server will encrypt the passwords which are sent up from the client...
142 0 /
Denny Cherry
Follow /11 Dec 2017 at 4:00pm / SQL Server Blog

Be sure to thank the sponsors

Conferences, no matter the size all have one thing in common, they all require the same thing to run from Br eakfast until Dinner for the day (or multiple days) that the event runs. That thing they need to run on is cash. The less expensive the event...
160 0 /
Denny Cherry
Follow /27 Nov 2017 at 4:00pm / SQL Server Blog

Should I be blocking outbound ports in Azure by default?

The short answer is that yes there are ports that you’ll want to block outbound by default.  There’s a variety of amplification attacks that you have the possibility of being a member of. These attacks aren’t against your systems, but...
202 0 /