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

A Historical Account of the Professional Association of SQL Server (PASS), Part 1: Foundation

A Historical Account of the Professional Association of SQL Server (PASS), Part 1: Foundation from Kevin Kline. Click HERE to read more … [Read more...]

Webinar Follow-Up: Setting SQL Server Performance Baselines and Alerts

Kevin Kline shares the Q&A from our recent "Setting SQL Server Performance Baselines and Alerts" webinar and highlights additional resources you can reference on the topic of baselining and alerting. Click HERE to read more … [Read more...]

DBTA – Machine Learning and the Microsoft Data Platform

If you're into data and databases and you have not heard the term "machine learning," may I suggest that you're not reading enough? This technology is hot and hyped, largely because it is the secret ingredient in many successful Big Data projects. Click HERE to read more … [Read more...]

SQL Sentry Essentials: Powerful Database Performance Monitoring for 5 or Fewer SQL Server Instances

SQL Sentry Essentials is now available. SQL Sentry Essentials is a new SQL Sentry edition that provides essential performance monitoring for up to 5 database instances. Click HERE to read more … [Read more...]

DBTA – Dynamic Data Masking and Row-Level Security Features on the Way in SQL Server 2016

In addition to StretchDB and AlwaysEncrypted, there are two more exciting features in the works for SQL Server 2016: dynamic data masking and row-level security. In the case of these two features, they'll be released first to the cloud platform (Azure SQL Database) and, later, to the on-premises version of SQL Server. Click HERE to read more … [Read more...]

Webinar Follow-Up: Top 4 Data Technology Trends for DBAs in 2019

Kevin Kline shares the Q&A from our recent webinar, The Top 4 Data Technology Trends Every DBA Should Know About in 2019. Click HERE to read more … [Read more...]

DBTA – Stronger Security Via Always Encrypted in SQL Server 2016

Prior to SQL Server 2016, currently in CTP, your main method for encrypting a SQL Server application was to use a feature called Transparent Data Encryption. TDE provides strong encryption, but with some shortcomings. First, you have to encrypt an entire database. No granularity is offered at a lower level, such as encrypting specific tables or certain data within a table. Second, TDE encrypts only data at rest, in files. Data in memory or in-flight between the application and server are unencrypted. Enter Always Encrypted. Click HERE to read more … [Read more...]

Webinar: Preventing SQL Server Performance Problems Before They Hit Production

Kevin Kline describes a new Webinar featuring Sabin IO. If you're a DBA who must remedy poor performance on a SQL Server then you'll want to check this out. Click HERE to read more … [Read more...]