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

DBTA – SQL Server 2016: The Cool is in the Tool (SSMS that is)

As a heavy user of other RDBMS data platforms, I have long appreciated the extra effort that Microsoft put into their data management and administration tool, the SQL Server Management Studio (SSMS). While SSMS is an outstanding administration and T-SQL programming tool, it does have its minor qualms and quibbles. Click HERE to read more … [Read more...]

DBTA – Powerful ETL Technologies in the Microsoft Data Platform

Microsoft first truly disrupted the ETL marketplace with the introduction of SQL Server Integration Services (SSIS) back with the release of SQL Server 2005. Microsoft has upped the ante yet again by bringing to market powerful ETL features to the cloud via the Azure Data Factory, which enables IT shops to integrate a multitude of data sources, both on-premises and in the cloud, via a workflow (called a "pipeline) that utilizes Hive, Pig, and customized C# programs. Click HERE to read more … [Read more...]