T-SQL

Home - Archive by category: T-SQL

Automated Testing for the Data Warehouse

Case: we’ve integrated two sources of customers. We want to add a third source. Q: How do we at the same time know that our current integration and solutions will continue to work while at the same time integrating the new sources? A: Test it. Q: How do we get faster deployments and more stability? A: Automate the tests, so[...]
Read More

SQL Server MONEY datatype limitations

Be very, VERY careful when using SQL Server’s MONEY datatype. It’s okay for storage of money things (offers some nice features too), and has an accuracy of 0.0001. Once you start calculating with that, beware. 1/10000th is quite a limitation.
Read More

Latest Posts

Categories