Skip to content
Thomas LaRock
  • About
  • Work With Me
    • Author
    • Speaker
    • Data Expert
  • Blog
  • Contact Me
  • Resources
    • Portfolio
    • SQL Server Upgrades
    • SQL Server Books
    • Someday…
    • Blogger Disclosure

SQL Server 2016

How To View Always Encrypted Data in SQL Server Management Studio

October 20, 2016 by Thomas LaRock

One of the shiny new features in SQL Server 2016 is Always Encrypted. Here’s how you can view the plain text data inside of SQL Server Management Studio.

Categories Database Design, MSSQL, SQL MVP Tags Always Encrypted, SQL Server 2016 2 Comments

SQL Server Trace Flags

June 22, 2016 by Thomas LaRock
sql server trace flags

Nobody likes surprises when it comes to upgrading or migrating SQL Server instances. Trace flags get set and forgotten. I’m hoping that this post will help people to remember.

Categories MSSQL, SQL MVP, SQL Server Performance Tags SQL, sql server, SQL Server 2016, trace flags, upgrade 1 Comment

HOW TO: Restore the Master Database in SQL Server 2016

June 8, 2016 by Thomas LaRock

The same holds true for when you restore the master database in SQL Server 2016.

Categories MSSQL, SQL MCM, SQL MVP, SQL Server Performance Tags database, master, restore, SQL Server 2016 3 Comments

SQL Server 2016: It Just Runs Faster

August 21, 2018June 1, 2016 by Thomas LaRock
SQL Server Record Breaking Performance

If you still don’t believe that SQL Server 2016 is full of unicorns and rainbows then I would encourage you to try it for yourself.

Categories MSSQL, SQL Azure, SQL MVP, SQL Server Performance Tags boost, Data Platform, faster, launch, microsoft, performance, SQL, SQL Database, SQL Server 2016 11 Comments

SQL Server 2016: What Time Is It?

March 15, 2016 by Thomas LaRock

Today I found that SQL 2016 introduces a function to help alleviate the issues we have when it comes to finding the current time.

Categories Database Design, MSSQL, SQL Azure, SQL MVP Tags datetime, spacetime, SQL Server 2016, Things I Write While High on Bacon, time zone, UTC 8 Comments
Newer posts
← Previous Page1 Page2
+ More
Pro SQL Server 2022 Wait Statistics