“Should I install SQL Server 2017 now? Or wait until SQL Server 2019?” One of our Remote DBA clients recently asked me that question. They have a set of aging SQL Server 2008 R2 instances used for production, test, and development. SQL Server 2008 and 2008 R2 Extended Support ends July 9, 2019, and the…
Read more
Just when we thought that most cybersecurity attacks came via social engineering, we see this. Attacks on IIS, Microsoft’s web server, increased from 2,000 in Q1 2018 to over 1.7 million in Q2 2018. That’s a mind-boggling 782x increase! This is according to an esentire Security Advisory released last week. Hackers go-to tool of choice? PowerShell was the most commonly…
Read more
How much data can a DBA manage? According to a 2010 Forrester Research article, it’s around 5 TB of data. Since that article was written, the amount of data companies collect and store has exploded so I suspect the figure today is closer to 10 TB of data. Of course, that’s painting with broad strokes…
Read more
Today’s Braves fans have it easy. When I was a kid, being a Braves fan was hard. It was a character building experience. Young Braves fans in the 1970’s learned to become optimists and to see the silver lining in even the darkest of clouds. We had to. The team didn’t give us much to…
Read more
Last month my oldest son was in a minor fender-bender. Fortunately, no one was hurt. “I’m sorry to hear that, but what does this have to do with upgrading SQL Server 2008?” Bear with me; I’m almost there. Driving with Old Technology My son was driving with his wonderful girlfriend in his 2006 Toyota Avalon…
Read more
“The nice thing about standards is that you have so many to choose from,” quipped renown computer scientist Andrew Tanenbaum. In the SQL Server world, we have industry best practices. These are guidelines that most every knowledgeable database professional will agree is a good idea or a good baseline. Sure there are exceptions, specific tweaks…
Read more
Music City Tech, One of the premier technical training conferences in Nashville, is May 31 through June 2, 2018. If you are unfamiliar with the event, there are three mini conference is within the broader event. Music City Code focuses on topics for software developers like Building a Blockchain, Test-Driven Development, and Entity Framework Core…
Read more
For years, Music City Code has been recognized as one of the premier events in Nashville’s technology scene. It has consistently drawn attendees and speakers from around country. Primarily focused on software and website development, the event has been attracting a growing number of data professionals who work closely with software developers. This year,…
Read more
You’ve probably heard about the most recent security vulnerability that affects not only Windows Servers but other Operating Systems like Mac OS, Linux, and even Chrome. It’s called “speculative execution side-channel attacks” and affects processors made by Intel, AMD, and ARM. Here’s the Microsoft Advisory about the vulnerability. Microsoft has also released some guidance specific for…
Read more
Recent Comments