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...]

History of PASS, Part 2: Assembling the Original Board of Directors

Kevin Kline shares more about the history of PASS and the assembling of the original board of directors. Click HERE to read more … [Read more...]

DBTA – Microsoft on the Ascent in Business Intelligence and Data Science

Microsoft has been on a tear for the past couple of years. It has been pushing forward with a very steady stream of powerful new features and capabilities, even entire product lines, within its Data Platform business. But while Microsoft has been hard at work on this deluge of new technologies, it would be completely forgivable if you haven't noticed. The reason it's OK is that Microsoft is advancing on multiple fronts, both in the on-premises product line and even more dramatically with the Azure cloud-based products. Click HERE to read more … [Read more...]

Azure SQL Data Warehouse Delivers a Win-Win on Price-Performance

With Azure SQL Data Warehouse and SentryOne, migrate to Azure with confidence and receive breakthrough cloud analytics performance at the best price. Click HERE to read more … [Read more...]