Tag Archives: sql server

String or binary data would be truncated

Posted on June 28, 2018 by

Microsoft, please fix this. This issue is still out there, and once again, it’s the top voted on item for SQL Server. Everytime I see this: Msg 8152, Level 16, State 13, Line 1 String or binary data would be truncated. I’m … Continue reading →

Posted in Editorial | Tagged | Leave a comment

How Far Back?

Posted on May 30, 2018 by

At the Redgate SQL Privacy Summit recently, there was panel I hosted that I thought was really interesting. At one point someone asked a question and there was a bit of a discussion about the right to forget in the … Continue reading →

Posted in Editorial | Tagged , | Leave a comment

Update Oddness for SQL Server

Posted on May 22, 2018 by

I’ve been meaning to patch some of my development instances. With a little spare time while doing other work, I started the process the other day. My first step was to patch SQL Server 2016 with SP2. This went as … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Reasons to Upgrade

Posted on May 3, 2018 by

I ran across a good article from Glenn Berry about reasons to upgrade to SQL Server 2017. In the piece, Glenn talks about the fact that SQL Server 2008 and 2008 R2 will fall out of Extended Support in 2019. That’s … Continue reading →

Posted in Editorial | Tagged , | Leave a comment

The Best Ever

Posted on April 10, 2018 by

Every few years, or every year now, we see a new version of SQL Server proclaimed as the best ever. A few weeks ago, I saw a number of people leaving hte MVP Summit, rating it as the best ever … Continue reading →

Posted in Editorial | Tagged

Predictions for the Future

Posted on March 6, 2018 by

There is no shortage of predictions that we all make every day. Long before PREDICT and the popularity of Machine Learning/R/Python and more, each and every one of us has regularly made guesses about what will happen in our world. Some of … Continue reading →

Posted in Uncategorized | Tagged

Decouple the Tools

Posted on March 5, 2018 by

For years, SQL Server included a complete set of add-ons with the main product. We got SSIS, SSRS, and more as part of an integrated installation. This also included things like Books Online and various tools, such as Profiler, bcp, … Continue reading →

Posted in Editorial | Tagged , ,

Brush Up on Your ETL Skills

Posted on February 21, 2018 by

Many of us that work with data will find requests and demands to import or export data at some point. Plenty of us have regular processes that perform these actions, and we may regularly troubleshoot or enhance these activities. In … Continue reading →

Posted in Editorial | Tagged ,

Template Configuration

Posted on February 16, 2018 by

One of my goals this year is to really spend some time learning more about Extended Events (XE). I’m somewhat embarassed that almost a decade after their introduction in SQL Server 2008, I have a fairly rudimentary grasp of the … Continue reading →

Posted in Editorial | Tagged , ,

Getting Your SET Options

Posted on February 6, 2018 by

Have you ever used @@options? I haven’t typically needed this, but there are times that you might wonder what options are set for a session. You can check in SSMS, look for defaults, etc., but there’s an easy way. SELECT … Continue reading →

Posted in Blog | Tagged , , | 3 Comments