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

DBTA – The Top 10 Mistakes Made by SQL Server DBAs

The SQL Server world has its own set of challenges when it comes to database administration. One of the biggest challenges is that there are never enough skilled DBAs. Consequently, many people who are not true DBAs are pressed into service, perhaps a Windows SysAdmin or the lead developer on an application using a SQL Server back end, so-called "accidental DBAs." That means that people doing DBA work on SQL Server frequently do not know the fundamental technical details or the processes and practices commonly used by experienced enterprise DBAs. What are the Top 10 Mistakes of SQL Server … [Read more...]

Data Pro, What’s Your Groundhog Day Flashback?

Kevin Kline asks data pros what their Groundhog Day moments are--the things in their career as a data professional that keep popping up over and over again, like a bad dream. Click HERE to read more … [Read more...]

DBTA – Managing ‘Noisy Neighbors’ in SQL Server 2014

If you've been managing databases for any length of time, you've probably had to contend with the "noisy neighbors" scenario. In this scenario, you have several applications, each with their own database residing on a single instance of SQL Server, which don't share the resources of the server nicely. To deal with this issue, you might want to investigate Resource Governor as an alternative. Click HERE to read more … [Read more...]