Tag Archives: sql server

String or binary data would be truncated

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?

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

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

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

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

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

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

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

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

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