Sign Up Now!

Sign up and get personalized intelligence briefing delivered daily.

Sign Up

Articles related to "script"


  • Also available in Figma.
  • Bootstrap Icons are packaged up and published to npm.
  • We only include the processed SVGs in this package—it's up to you and your team to implement.
  • Read our docs at for usage instructions.
  • Depending on your setup, you can include Bootstrap Icons in a handful of ways.
  • See the docs for more information.
  • Clone the repo, install dependencies, and start the Hugo server locally.
  • Here are some key scripts you'll use during development.
  • Be sure to look to our package.json for a complete list of scripts.
  • Use npm run icons to run the script, run npm run pages to build permalink pages, complete those pages, and, finally, commit the results in a new branch for updating.
  • Documentation is published automatically when a new Git tag is published.
  • See our GitHub Actions and package.json for more information.

save | comments | report | share on

Migrating a 40TB SQL Server Database

  • The goal was to migrate the data to the new format, then when we got new servers it would be as simple as moving the drives to get the new database in place (or so we thought).
  • The database was going to have all of the old historical tables (i.e. the 40TBs) stored on the TrafficLogs_Archive filegroup, and we’d use the PRIMARY and TrafficLogs_Current for newer data being added.
  • Pulling millions of rows of data from spinny drives, and then inserting it back into new tables on those same spinny drives was slow.
  • We didn’t have new hardware yet and these were production SQL Servers - meaning the old database was still receiving new data and we were adding a new table everyday.
  • As I was moving tables to the new database, we were adding tables with hundreds of millions of rows of data to the old database.

save | comments | report | share on