(Chris Shaw) This article is part 10 in a series on the top 10 most common mistakes that I have seen impact SQL Server Performance and Resiliency. This post is not all-inclusive.
Tag: sql server
SSIS: An Item With The Same Key Has Already Been Added
(Nicky van Vroenhoven) Recently I was working on a new project and was trying to deploy my SSIS project with several packages to the catalog for the first time. I received the error when trying to build the project:
Maintaining T-SQL Code Quality Using SQL Code Guard
(Lukasz Swiatkowski) Sometimes you need some functionality in your database build process that isn’t quite available. Visual Studio Database projects don’t have great ways of reviewing SQL code for potential errors, but is it possible to adapt a good command-line tool like SQL Code Guard that does t
Importing character columns containing binary zeros into SQL Server
(Daniel Farina) You have a SQL Server Integration Services package to import a text file, but it contains binary zeros 0x00 instead of spaces and the strings get truncated. In this tip I will show you a workaround for this issue.
Shrinking Database Data Files
(Steve Hood) Normal DBAs will sum up shrinking a database data file in one word: NO!
Exploring SQL Server 2016 Dynamic Data Masking – Part One – Creating a Table that uses Dynamic Data Masking
(Greg Larsen) In this article about exploring SQL Server 2016 features I will start investigating a new feature known as Dynamic Data Masking. By using data masking you can obscure the real value of a data column with a masked value. In this article I’ll be exploring the different features of how t
Misunderstandings about the COPY_ONLY backup option
(Tibor Karaszi) The COPY_ONLY option for the backup command never ceases to cause confusion. What does it really do? And in what way does it affect your restore sequence? Or not?
SQL SERVER 2016 – InMemory OLTP support for Foreign Key
(Pinal Dave) When InMemory OLTP was introduced in SQL Server 2014, there were a number of limitations that restricted customers to effectively use the capability. One of the most commonly asked capability was around the ability to create Foreign Keys.
OPENQUERY – Linked Server error ‘Deferred prepare could not be completed’
(Larry Leonard) If you’re using OPENQUERY and get this error:
Minimum Permissions for SQL Server TRUNCATE TABLE
(K. Brian Kelley) I have read over the Books Online entries for the SQL Server TRUNCATE TABLE command and I’m confused. On the one hand it sounds like if the user has ALTER permissions on the table, that’s sufficient to successfully issue the command. However, it also sounds like only being a member