Reeves Smith explains why you should add Master Data Services to your enterprise and why data governance is often overlooked in data warehouse projects.
SQL SERVER – Iterating over Metadata with BimlScript – Notes from the Field #061
Reeves Smith continues his Biml series and shows how iterating over metadata with BimlScript helps automate repetitive SQL Server BI work.
SQL SERVER – Validation Rules: Code or Database? – Notes from the Field #054
Should validation rules live in the .NET app layer or in the database? G. Andrew Duthie looks at this common argument between developers and DBAs.
SQL SERVER – The Why of BIML – Notes from the Field #051
Can writing an XML-based language like BIML really help you? Reeves Smith explains the why of BIML and why it is worth learning for BI work.
SQL SERVER – What is Biml and How Can it Help Me with SQL Server BI? – Notes from the Field #036
What is Biml, and how can it help with SQL Server BI? Reeves Smith explains Business Intelligence Markup Language and how it adds automation to BI work.