Good Business Intelligence depends on a good Data Warehouse
Good BI, Good DW There are certain components that are essential for a successful Business Intelligence implementation and in this post I want to emphasize the importance of the data warehouse. It’s obviously a foundational component and doing it right requires choosing the right DW model and implementing a quality design. My Baseball Woes I [...]
T-SQL Tuesday and Best Practices – SQL is a Set-Based Language
This month’s T-SQL Tuesday#20 – T-SQL best Practices is a tall order to write about. Best practices can cover coding style, documentation, performance, and so many other areas that whole books can and have been written about them. When I consider the poor practices I’ve seen in T-SQL code I think about the basic flaws [...]
