SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: October 2018

String or binary data would be truncated: get the full picture in SQL Server 2017

SQL Server 2019 Preview (CTP 2.0) introduced a long-awaited improvement to an error message that’s been around in SQL Server for many years, but was unhelpful: [crayon-5c6a9b685058a434753964/] Thanks for nothing, error message. Which table? Which column? What data? This is how the error message looks now: [crayon-5c6a9b6850590062173168/] Notice how the… Read more

13 comments, 451 reads

Posted in Born SQL with Randolph West on 31 October 2018

Steps to Create an In-Memory table for SQL Server

Creating a table to be in memory compared to standard tables that use the files on disk can have several performance benefits for high transaction databases.

In memory tables store data in server memory compared to disks and can help eliminate locks and latches on objects.  In memory tables were… Read more

0 comments, 3,697 reads

Posted in vitamindba on 31 October 2018

How Much Will Compression Really Gain Me?

Did you know compression can gain you more than just space on a disk, it can allow you to fit more data into the buffer pool? That means queries have faster and more efficient reads which can help reduce I/O. It is a performance tool I highly recommend you consider… Read more

1 comments, 2,406 reads

Posted in SQLEspresso on 31 October 2018

Zombie SQL

It Halloween so time for a scary SQL story. Ok, maybe not that scary. Ok, not scary at all, but still a bad practice. It’s Zombie code so it seemed like something fun to talk about on Halloween. But what is it?

Zombie Code

Code that is left in…

Read more

2 comments, 2,759 reads

Posted in SQLStudies on 31 October 2018

Speaking at PASS Summit

The title says it all, this year I have been selected as a speaker at the world’s largest Microsoft Data Platform conference: PASS Summit!

I will be presenting on one of my favourite topics: In-database analytics inside Microsoft SQL Server (www.pass.org/summit/2018/sessions/details.aspx?sid=76976). So if you happen to be at… Read more

0 comments, 216 reads

Posted in DotNine SQL Server and more on 31 October 2018

PASS Summit, SQLTrain and My First US SQL Saturday

Next week is the week when I used to dread looking at Twitter and especially the #PASSsummit hashtag, watching all of those folk having a great time in great sessions and doing all of the networking. Last year I was lucky enough to attend for the first time and take… Read more

1 comments, 220 reads

Posted in SQL DBA With A Beard on 31 October 2018

How to create DACPAC file?

In this post I will explain what the DACPAC is and how to create it. In previous post in DevOps series I described how to create new, empty database project in Visual Studio. One of the ways how to import an existing database (from a server) was import database from… Read more

0 comments, 93 reads

Posted in SQL Player Blog on 31 October 2018

SQLCLR vs SQL Server 2017, Part 9: Does PERMISSION_SET Still Matter, or is Everything Now UNSAFE?

(last updated: 2018-11-01 @ 00:50 EDT / 2018-11-01 @ 04:50 UTC )

SQL Server 2017 introduced a new security restriction for SQLCLR in the form of a system configuration option named, “CLR strict security”. So far, this series – SQLCLR vs SQL Server 2017 – has mostly focused on the… Read more

2 comments, 2,997 reads

Posted in SQL Quantum Leap on 31 October 2018

Is your SQL Server environment ready for GDPR? Part 2

In my previous blog post of this topic, I talked about the definition of what GDPR is and also described the first two phases of Microsoft’s recommended workflow in order to be in compliance with this data regulation.

The Discovery and Manage phase was about discovering where the sensitive data… Read more

0 comments, 3,186 reads

Posted in DBA Mastery on 30 October 2018

Signing Stored Procedures That Access Multiple Databases

A while back I wrote a post, Digitally Signing a Stored Procedure To Allow It To Run With Elevated Permissions

Recently Manish Kumar asked an interesting question, what do you do if your proc accesses multiple or even all the databases on the server?

So, instead of giving him a… Read more

1 comments, 2,443 reads

Posted in SQL Undercover on 30 October 2018

The 5 Scariest Moments for a SQL Server Developer

While families and friends are scaring each other this Halloween week with stories of ghosts and ghouls, I thought it’d be way scarier to talk about truncate tables and source control.

Accidental Data Deletion

You’ve spent all morning loading millions of records into your tables.  Some of that data was… Read more

4 comments, 4,853 reads

Posted in Bert Wagner on 30 October 2018

Email Alerts with SIOS DataKeeper

Over the past few weeks I wrote a 3-part series on how to configure email alerts based on Perfmon Counters, System Event Log Entries and a specific Windows Service Start or Stop Event. While these guides are relevant to any environment all of my examples were geared towards monitoring… Read more

0 comments, 23 reads

Posted in Clustering for Mere Mortals on 30 October 2018

Append Variable activity in Azure Data Factory: Story of combining things together

(2018-Oct-29) There are only a few sentences in the official Microsoft web page that describe newly introduced activity task (Append Variable) to add a value to an existing array variable defined in Azure Data Factory - Append Variable Activity in Azure Data Factory But it significantly improves your ability to…

Read more

2 comments, 1,875 reads

Posted in Data Adventures on 29 October 2018

Using MAXDOP to fix a performance problem

As DBA’s we are sometimes put in a rock and hard place when it comes to database performance.  This situation recently happened with a production application and some nasty production performance issues one particular query was having.

We get a call regarding slow performance on a stored procedure that was… Read more

0 comments, 4,174 reads

Posted in vitamindba on 29 October 2018

Step-by-Step: How to Trigger an Email Alert when a Specific Windows Service Starts or Stops on Windows Server 2016


In my last post. Step-by-Step: How to Trigger an Email Alert from a Windows Event that Includes the Event Details using Windows Server 2016, I showed you how to send an email alert based upon specific Windows EventIDs being logged in a Windows Event Log. While that works… Read more

0 comments, 22 reads

Posted in Clustering for Mere Mortals on 29 October 2018

Explicitly Drop Temporary Tables Or Wait For Cleanup?

I was recently asked if we are going to see performance differences if we explicitly drop temporary tables. I couldn’t remember the specifics, but I said it actually didn’t matter. However, that answer has bugged me, so I set up a quick test. Explicitly Drop Temporary Tables We could make… Read more

14 comments, 3,912 reads

Posted in The Scary DBA on 29 October 2018

Free Training: Videos from Tim Mitchell

I’m always on the looking our excellent training, especially free training. Tim Mitchell, Microsoft Data Platform MVP, (twitter | website) has a number of great videos available on YouTube around SSIS and ETL. Definitely spend some time checking them out!

Tim Mitchell’s YouTube Channel

Tim is a great… Read more

0 comments, 232 reads

Posted in Databases – Infrastructure – Security on 29 October 2018

Blogger Questions: What if I get a mean/rude comment?

There is a fear that almost every blogger has to overcome. I’ll be honest, it pops up almost every time I hit schedule on a post.

What if my post sucks? What if someone tells me it sucks?

After 6 years of blogging, I finally got one! (Yes, I was… Read more

10 comments, 282 reads

Posted in SQLStudies on 29 October 2018

T-SQL Tuesday 108 Invitation- Non SQL Server Technologies

I am proud and honored to be hosting T-SQL Tuesday again. This monthly blog party started by SQL Guru Adam Machanic since 2009 has completed 100 months this year and am the lucky host of event #108. If you are participating in this month’s party (kindly coordinated by my dear… Read more

10 comments, 273 reads

Posted in Mala's Data Blog on 29 October 2018

A lack of foreign keys – a bad culture example.


One of the things that I’ve been seeing more often than I would like to lately is large databases with no foreign keys – or minimal foreign keys (and often with those minimal set of keys disabled)

By large databases I’m roughly meaning databases with several hundred tables, and… Read more

5 comments, 3,099 reads

Posted in measure twice, cut once. on 28 October 2018

Older posts