Surprising but True: the Basics are Still Difficult

SURPRISING BUT TRUE: THE BASICS ARE STILL DIFFICULT I always look forward to new research from Unisphere Research, a division of Information Today, Inc., publishers of this magazine and other great products for data professionals. The latest report which you should read is "SQL Server Transformation: Toward Agility & Resiliency 2017; PASS Database Management Survey." READ MORE... Originally Posted April 07, 2017 … [Read more...]

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

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. READ MORE... Originally Posted December 02, 2015 … [Read more...]

SQL Server Named DBMS of the Year

SQL SERVER NAMED 2017 DBMS OF THE YEAR Way back in the summer of 2014, I told you about how I used DB-Engines to determine the popularity of various data management tools and vendor platforms. At that time, I explained how I used DB-Engines.com and Google Trends to see where the overall trends that I'm interested in are headed. Staying up with the trends isn't just for fashionistas! READ MORE... Originally Posted March 02, 2017 … [Read more...]

Tomorrow: Learn about SQL Server on Vmware

SQL Server Running on Vmware. A Common Scenario. I have the honor of presenting a webinar, tomorrow, on Thursday, October 12th, 2017 2:00 pm - 3 pm EDT, with Mr. Charles Kim. We'll be talking about SQL Server running on Vmware, with me taking the SQL Server part and Charles taking the Vmware part. Charles is the Founder of Viscosity North America and his accolades are many and manifold: Oracle ACE Director, Oracle Certified DBA, a Certified RAC Expert, Certified Exadata Implementation Specialist, VMware vExpert, and a VMware Certified Professional. Charles specializes in RAC, Exadata, … [Read more...]

Introducing the SQL Server Database Experimentation Assistant

INTRODUCING THE SQL SERVER DATABASE EXPERIMENTATION ASSISTANT There's a very handy new tool from Microsoft called the Database Experimentation Assistant (DEA). The DEA makes it very easy to conduct A/B testing for SQL Server upgrades, providing quantitative insight into the performance differences across two versions of a database workload on SQL Server. Learn more! READ MORE... Posted February 08, 2017 … [Read more...]

Stronger Security Via Always Encrypted in SQL Server 2016

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. READ … [Read more...]

Major Feature Reconfiguration For SQL Server 2016 Service Pack 1

MAJOR FEATURE RECONFIGURATION FOR SQL SERVER 2016 SERVICE PACK 1 One of the long-standing differentiators between SQL Server's Enterprise Edition (EE) and Standard Edition (SE), besides price, were the large number of features available only in EE. This is also true for other lower editions of SQL Server such as Web Edition and Express Edition. But there's big news in the air! READ MORE... Original Posted January 03, 2017 … [Read more...]

Don’t Miss the Biggest Annual SQL Server Conference, PASS Summit

I'm thrilled to be presenting once again at this year's PASS Summit, coming up in October in Seattle. I've got two regular sessions, one technical and one profession, as well as two community sessions. I hope you can join me. In case you don't know, the PASS Summit connects you with industry experts and THOUSANDS of global data professionals in a unique learning environment that empowers you with the practical knowledge you need to excel in your career. If you've never been before I strongly encourage you to consider attending. It can be a career-altering (and improving) experience! In … [Read more...]

New Releases for the Microsoft Data Platform

NEW RELEASES FOR THE MICROSOFT DATA PLATFORM The Microsoft data platform team is on fire! It is delivering more updates and features faster and more thoroughly than ever before. If you're a data professional and you're using the Microsoft stack, this is a really exciting time to be involved. Here's a look at the top new capabilities in SQL Server 2016 Public Preview, SSIS Feature Packs For Azure, and Azure SQL Data Warehouse. READ MORE... Originally Posted July 08, 2015 … [Read more...]

How Can the SQL Server Resource Governor Help You?

MANAGING ‘NOISY NEIGHBORS’ IN SQL SERVER 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. READ MORE... Originally Posted in DBTA Magazine in June 09, 2015 … [Read more...]