Tag Archives: sql server

How Do You Setup Your Instances?

Posted on September 14, 2018 by way0utwest

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 , | Comments Off on How Do You Setup Your Instances?

Getting the Role Permissions–#SQLNewBlogger

Posted on August 16, 2018 by way0utwest

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 , , | Comments Off on Getting the Role Permissions–#SQLNewBlogger

The End of Support

Posted on July 17, 2018 by way0utwest

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 way0utwest

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 | Comments Off on String or binary data would be truncated