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

BACPAC

View BACPAC Files Using This One Weird Trick

May 8, 2017April 24, 2017 by Thomas LaRock
change BACPAC to ZIP file

I did not think it was possible to view the contents of a BACPAC file. However, last month while at SQL Bits I was reminded about this one weird trick to view the contents of a BACPAC file.

Categories Database Design, MSSQL, SQL Azure, SQL MVP, SQL Server Performance Tags BACPAC, DACPAC, SQL, Things I Write While High on Bacon, ZIP 1 Comment

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
Pro SQL Server 2022 Wait Statistics