Ben Johnston in Blogs Feature Flags in Data Projects My motivation for writing this summary was an interaction with a project owner that didn’t understand why we couldn’t use... 01 February 2024 23 min read
Blogs Dennes Torres in Blogs Power BI: ETL or not ETL, that’s the question ETL stands for Extract, Transform, and Load. Dennes Torres explains what an ETL tool is and isn't.… 07 March 2022 5 min read
Blogs Dennes Torres in Blogs 5 SSIS tricks you would like to know How to make conditional decisions in a package It may seems strange the lack of a decision task for the... 30 August 2021 3 min read
Elizabeth Ayer The Comeback of Migrations-Based Deployments With database deployments, not all script-based processes are equal. Some use change scripts in a free-and-easy way, and some, which... 17 March 2016 11 min read
Michael Sorens Documenting Your PowerShell Binary Cmdlets Whereas it is easy to provide inline documentation for a normal scripted PowerShell cmdlet or function so as to provide... 17 November 2015 31 min read
Dennes Torres Optimizing Batch Process in SQL Server SQL Server batch processes are usually run from SQL Agent in background. They can take significant time and resources, especially... 08 May 2015 32 min read
Feodor Georgiev How to get ETL Horribly Wrong ETL ( Extract, transform, load) doesn't have to be like a spell on hell. To make a success of ETL... 09 January 2015 14 min read
Feodor Georgiev Data Cleaning in SQL 2012 with Data Quality Services For data to be usefully analyzed, it must be consistent, accurate, and trustworthy. When incoming data is non-uniform, duplicated records... 31 December 2014 11 min read
Feodor Georgiev SSIS 2012 Projects: Deployment Configurations and Monitoring The Project Deployment Model introduced in SSIS 2012, which was explained in the first part of this series, speeds up... 14 November 2014 7 min read
Feodor Georgiev SSIS 2012 Projects: Setup, Project Creation and Deployment It used to be that SQL Server Integration Services (SSIS) packages had to be deployed individually. Now, they can be... 04 November 2014 7 min read
Robert Sheldon Importing Excel Data into SQL Server Via SSIS: Questions You Were Too Shy to Ask The job of retrieving data from Excel, and importing it into SQL Server hasn't the same appeal or glamour as,... 11 September 2014 31 min read
Saurabh Dhoble Developing a Custom SSIS Source Component SSIS was designed to be extensible. Although you can create tasks that will take data from a wide variety of... 30 June 2014 21 min read
Nirmal Sharma Book Review: Optimizing And Troubleshooting Hyper V Networking 2013 If you want to learn how to optimize and troubleshoot Hyper-V, then this book, written by Microsoft people whose day... 11 February 2014 10 min read
Feodor Georgiev Collect Your SQL Server Auditing and Troubleshooting Information Automatically If you have a number of SQL Server instances with versions ranging from 2005 upwards, with a whole host of... 28 January 2014 12 min read
Annette Allen SSIS Basics: Using the Merge Join Transformation SSIS is able to take sorted data from more than one OLE DB data source and merge them into one... 16 October 2013 19 min read
Andy Brown Moving Data From Excel to SQL Server – 10 Steps to Follow SQL Server Integration Services provide a versatile way of reading Excel files into SQL Server. A task like this illustrates... 21 May 2013 15 min read
Edward Charbeneau Refactoring CSS with Sass and Compass CSS is still a valuable way of specifying the rendered style of HTML objects. By using a preprocessor to assist... 16 April 2013 18 min read
Robert Sheldon Getting Started Testing Databases with tSQLt There are several frameworks for assisting with the testing of SQL Server databases, but tSQLt is popular because it is... 08 April 2013 22 min read
Annette Allen SSIS Basics: Using the Conditional Split The Conditional Split can route data rows to different outputs depending on whatever criteria of the data that you wish.... 28 January 2013 12 min read
Richard Morris Bill Baker: Geek of the Week Bill Baker had a considerable influence on the way that SQL Server evolved to deliver reporting services and business intelligence.... 04 December 2012 8 min read