As part of a data warehouse project that I’m working on, I need to be able to grant or deny access to users. I do…
Tag: Data Warehouse
Aim: In my last blog post, I recorded a sample query for processing JSON in SQL Server so that I can refer back to it…
Aim: Very occasionally I have to process JSON in SQL Server, usually as part of a data warehouse task. Because I don’t do this often,…
The following tSQLt test checks that a view is not empty. This test is primarily used to check the views that expose data to the end…
The following tSQLt test checks that all the indexes exist & are enabled as expected: CREATE PROCEDURE testSchema.[test that all indexes exist] AS BEGIN IF…
The following tSQLt test checks the historical unchanging data in a fact table to ensure that it has not been changed unexpectedly as part of…
The following tSQLt test checks the unchanging (or very slowly-changing) data in a dimension or reference table to ensure that it has not been changed…
tSQLt is a great T-SQL based unit testing framework for SQL Server. In addition to using it for unit testing, I’ve recently been (mis)using it…
The following tSQLt test checks that the basic schema of a table (or view) to ensure that it has not been changed unexpectedly as part…
As of SQL Server 2016 SP1, fine grained auditing is now available in Standard Edition. This has proved to be an easy way to monitor…