(Brady Upton) Just released in SQL Server 2016 CTP 2.4 is a new feature that will allow us to compare execution plans. The main purpose of this feature is to provide a side-by-side comparison of two execution plans.
Tag: sql server
#0369 – Visual Studio Solutions – SSIS and Coded UI projects – encounter ‘System.ArgumentNullException’ and tests do not build successfully’
(Nakul Vachhrajani) Recently, we undertook a project to write a couple of automation tools for the utilities that we use to move data around.
Exploring SQL Server 2016 Always Encrypted – Part 4 – Encrypting Existing Data
(Greg Larsen) As with most new technology it is not only intended for new development, but it is also targeted at fixing existing issues with current applications. This is also true with the new SQL Server Always Encrypted feature.
SQL SERVER – FIX: Msg 3169, Level 16, State 1 – The database was backed up on a server running version. That version is incompatible with this server.
(Pinal Dave) At this rate, I think I am going to exhaust the whole error set available inside SQL Server. I am glad that I am able to get into unique situations and then resolve them too. And this is more of a diary of the error messages I am getting into.
Why You Should Use a SSDT Database Project For Your Data Warehouse
(Melissa Coates) In this post, I will try to convince you that using SQL Server Data Tools (SSDT) Database Projects is a really good idea. Recently during a project I’ve been advocating that it indeed is worth the effort. Since I’m a BI architect, I’m framing this conversation around a data warehous
Sparse Columns in SQL Server : Impact on Time & Space
(Erin Stellato) SQL Server 2008 introduced sparse columns as a method to reduce storage for null values and provide more extensible schemas. The trade-off is that there is additional overhead when you store and retrieve non-NULL values. I was interested in understanding the cost for storing non-NULL
Tip # 8 – Default TempDB Settings
(Chris Shaw) This article is part 8 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is not all inclusive.
MSDTC Requirements for SSIS Transactions
(Kenneth Fisher) MSDTC is frequently required when using transactions within SSIS. And not just when you are connecting to two SQL Server instances.
TempDB memory leak?
(Steve Hood) I found a bug where I’m seeing TempDB use more memory than it should on multiple versions of SQL Server, especially on servers set up with common best practices. There’s a workaround that has a profound affect on server performance, adding to my belief that this is a legitimate bug and
Hidden GUI Gems
(Jason Brimhall) The GUI for Extended Events offers some power to help you get started with trying to work with Extended Events. As I have shown over the past few articles, some of this power comes with a bit of cost and may in fact not be as powerful as just using a script.