Tag Archives: sql server

How Do You Setup Your Instances?

I’ve set up a lot of SQL Server instances in my career. I’ve gone from manual only setup in SQL Server 4.2 to more automated means in the latest versions. The easiest was actually in Azure where I only need … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Getting the Role Permissions–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. If you are wondering what permissions a role has, and don’t want to spend time searching and digging through … Continue reading

Posted in Blog | Tagged , , | Leave a comment

The End of Support

With the accelerating pace of development and more frequent releases, we are seeing a bunching up of SQL Server support milestones. From 2008 through 2016, we had a new version every two years. Last year we saw another version, which … Continue reading

Posted in Editorial | Tagged | 2 Comments

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 ,

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 ,

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 , ,