Software That Shines

Better Software Blog

Software Insights

Posts tagged SQL Server
SQL Server Temporal Table Tricks and Troubles

Temporal tables are a useful feature introduced with SQL Server 2016 to track changing data.  Here I show a quick example of converting existing data to temporal tables, I show another subtle trick to implement an automatic "modified date" without a history table, and I demonstrate some possible pitfalls with the temporal table behavior.



Read More
A checklist for a better SQL Server setup (2012-2016)

There are a lot of performance best practices with Microsoft SQL Server that can add up to a significant impact; some of them involve the machine, some of them involve Windows. Some of them involve the SQL server instance, and some of them involve the database: many of the defaults when setting up a new SQL instance and database are suboptimal, probably for legacy reasons. (Thankfully, SQL 2016 finally improves all this!)

I've collected as much as I can here into a "one stop shopping" checklist. And you can always contact us for help!

Read More
Mark SowulSQL Server