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

Database Design

The Server Draft

April 28, 2016 by Thomas LaRock

If you were given the chance to build the ultimate server, what would you draft first?

Categories Database Design, MSSQL, SQL Server Performance Tags CPU, disk, memory, network, server, Things I Write While High on Bacon, Things Only I Find Amusing 6 Comments

Why You’re Wrong: The Data Professional’s Guide To Contentious Issues

April 19, 2016 by Thomas LaRock

I’m here to put an end to the debates. Today we will examine the data professional’s guide to contentious issues.

Categories Database Design, MSSQL, Musings, SQL MVP Tags DAC, NULLs, objects, ORM, schemas, server core, sql server, Triggers 12 Comments

Advanced Accidental Database Design

April 6, 2016April 5, 2016 by Thomas LaRock

Next week (12th April, 2016) we will be doing a webinar for SolarWinds, Advanced Accidental Database Design, taking place at 9AM ET (13:00 UTC).

Categories Database Design, MSSQL, SQL Server Performance, Travel Tags Database Design, sql server, sqlbits 4 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

Migrating Data From a TDE Enabled SQL Server Database Without a Key

February 9, 2016February 9, 2016 by Thomas LaRock
The model.xml file shows our database was encrypted.

But our database has TDE enabled, shouldn’t our data at rest in the BACPAC be protected? Nope.

Categories Database Design, MSSQL, SQL MVP Tags BACPAC, BCP, microsoft, sql server, TDE, Transparent Data Encryption 2 Comments

15 Things That Didn’t Happen To Me In 2015

December 28, 2016December 28, 2015 by Thomas LaRock

It’s that time of year again. It’s only natural for folks to wax nostalgic as 2015 fades into the sunset one final time.

Categories Database Design, MSSQL, Musings, SQL MVP Tags 2015, MSSQL, sql server, VMWare, year in review 12 Comments
Older posts
Newer posts
← Previous Page1 … Page4 Page5 Page6 … Page12 Next →
+ More
Pro SQL Server 2022 Wait Statistics
Next Page »