Tag Archives: sql server

How Do You Setup Your Instances?

Posted on September 14, 2018 by

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

Posted on August 16, 2018 by

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

Posted on July 17, 2018 by

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

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 ,

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 ,

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