Temporal Tables in SQL Server 2016

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. READ MORE... Originally Posted June 09, 2016 … [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...]

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

Learn More About the SQL Server Cardinality Estimator

COOL FEATURES OF SQL SERVER 2014: IMPROVED CARDINALITY ESTIMATES With all the cheerleading and the steady drumbeat of new features being released to Azure, it's easy to lose track of the many cool and valuable new features released in the on-premises version of SQL Server. One of the crown jewels of SQL Server, the cardinality estimator (CE), underwent a large redesign for SQL Server 2014 to improve performance. Cardinality estimates are an extremely important part of query processing. In a nutshell, cardinality estimates are what the relational engine predicts for the number of rows affected … [Read more...]

My Best Blog Posts from 2015

ALWAYS LEARNING About mid-way into August of 2015, I learned some important new factors in Search Engine Optimization (SEO) that caused me to make some big changes to the way in which I blogged. Namely - simply reposting a slight variant of a given blog post could hurt your overall SEO rankings for any of the given posts. Now you might be saying to me "Kevin, those aren't new factors. They've been around for a long time, you idgit". And I would say in response "Ok then. But I had other things on my mind". (Of course, if you have other recommendations for improving one's blog performance, … [Read more...]

SQL Injection – Why the Heck Does this Keep Happening?!

  I'm decidedly old-school in a few of my habits. My morning routine, barring anything out of the ordinary, is one such example. Typically, I'll get up between 6:30 to 7:00 am, grab my first cup of coffee, and then chat with my daughters for a few minutes before seeing them off to school. Next, I make a bowl of oatmeal (a great choice for diabetics like me), pour a second cup of coffee, and browse the local paper, The Tennessean, while I have breakfast. On the morning of August 5, I had the added pleasure of spewing said coffee and oatmeal all over my morning paper when I read the … [Read more...]

DBTA – Tools to Evaluate Viability of Database Platforms

As the manager for enterprise architecture in a very large IT organization, the C-suite executives frequently posed the question, "What database platform is best for this application today and for the future?" Implicit in that question was the idea that some platforms, for the application and for the database, might be more than adequate today but be trending in a direction that didn't match with our executive's goals. So what's a person supposed to recommend under those dynamics? Read the rest of the article … [Read more...]

DBTA – Cloud Computing Enhancements in SQL Server 2014

  There’s no doubt that cloud computing is growing due to the strong cost benefits, simplified management, and reduced hosting complexities.  So it’s only fitting that we cap this series on the new features of Microsoft’s upcoming SQL Server 2014 (SQL2014) release of their flagship database by going over the highlights for SQL2014’s new cloud computing features. Here’s what SQL2014 will do for you with regards to business cloud computing: Read the rest of this article … [Read more...]