DBTA – HIPAA: DBAs, Data, and the Law

With all of the hype around data being "the oil of the 21st century" and the rise of "the algorithm economy," it seems reasonable to make it a priority to learn more about how laws affect our lives as DBAs. The first law that I have targeted is probably the best-known data law in the U.S.—HIPAA, the Health Insurance Portability and Accountability Act of 1996. Click HERE to read more … [Read more...]

Expert Q&A: Consolidating Your SQL Server Environment to the Cloud

In this blog post, Kevin Kline answers questions from our webinar “Consolidating Your SQL Server Environment to the Cloud.” Click HERE to read more. … [Read more...]

DBTA – SQL Server Drill Down: Containers and the World of OS-Level Virtualization

If you haven't been paying a lot of attention, you might have missed the rise of a new form of virtualization, based at the operating system level, called "containers." While there are many specific software programs, by far the most prominent is Docker. So, from here on out, consider "Docker" and "container" to be synonymous. Click HERE to read more … [Read more...]

DBTA – SQL Server 2016 is Simply Faster… A Lot Faster

I had the pleasure to spend some time with my old friend Mark Souza, a general manager in the Data Platform team at Microsoft, while speaking at the SQL Saturday event in Dublin, Ireland. Now keep in mind that Mark and I have known each other since the 1990s when SQL Server was just being ported to a brand new operating system called Windows NT. Mark and I were having a laugh and more than a twinge of nostalgia about how much SQL Server has improved over the decades and now sits atop the heap on most analysts' "best database" reports. This isn't just two old-timers sharing a few war stories … [Read more...]

Consolidating Your SQL Server Environment On-Premises: Q&A

In this blog post, we answer questions from our webinar “Consolidating Your SQL Server Environment On-Premises.” Click HERE to read more. … [Read more...]

DBTA – SQL Server Drill Down: DBAs Keep Asking: “Will I Have a Job in the Long-Term?”

Will the DBA disappear? No, far from it. But specific skills needed by DBAs and certain job roles fulfilled by DBAs will certainly change as we move to the cloud. Click HERE to read more … [Read more...]

DBTA – U-SQL and the Azure Data Lake

There's a new buzzword on the loose, the data lake. At first glance, a data lake could be easily mistaken for a data warehouse. The two big data concepts have a common focus on analytics and they may, in certain situations, produce roughly equivalent output. But that's about where their similarities end. Click HERE to read more … [Read more...]

Webinar Follow-Up: Top 5 SQL Server Challenges Automated with PowerShell

In this webinar recap, Kevin Kline shares the Q&A portion of the SentryOne webinar: Top 5 SQL Server Challenges Automated with PowerShell. Click HERE to read more. … [Read more...]

DBTA – SQL Server Drill Down: What’s New in the Microsoft Data Platform, Build 2019 Edition

Microsoft directly hosts a handful of big conferences every year, with the developer-oriented Build conference and infrastructure-oriented Ignite being to two that I pay the most attention to. The Microsoft Build 2019 conference just wrapped up and we have a couple important new announcements for the those of us working with the Microsoft Data Platform. Click HERE to read more … [Read more...]

DBTA – Temporal Tables in SQL Server 2016

While temporal data support is something that has existed in the past within other database platforms, it is a newly available feature with the RTM version of SQL Server 2016. In case you haven't heard of temporal data values (or for some, "bitemporal"), here is a brief explanation. Click HERE to read more … [Read more...]