Replication in Configuration Manager is talked about pretty frequently. It's a pretty awesome feature, but also a pain at times. One of the reasons I find it to be so cool is that it takes advantage of a SQL feature called Change Tracking. This feature is the fundamental basis for replication - and is a … Continue reading Change Tracking (aka Syscommittab) Issues and Cleanup – Part 1
Year: 2017
SQL Tip: Creating a Grand Total (and additional subtotals)
[edit: April 2019] This was originally posted to my internal (to Microsoft) blog on Jan 23, 2012 as part of a series I called 'SQL Tips' for coworkers and an email distribution list people could sign up to. I have left this as originally written but have updated formatting for my WordPress theme. Sometimes when … Continue reading SQL Tip: Creating a Grand Total (and additional subtotals)
SQL Tip: Creating a PIVOT table (Part 2)
[edit: April 2019] This was originally posted to my internal (to Microsoft) blog sometime in 2011/2012 as part of a series I called 'SQL Tips' for coworkers and an email distribution list people could sign up to. I have left this as originally written but have updated formatting for my WordPress theme. Last tip we … Continue reading SQL Tip: Creating a PIVOT table (Part 2)
SQL Tip: Creating a Pivot table via T-SQL
[edit: April 2019] This was originally posted to my internal (to Microsoft) blog sometime in 2011 as part of a series I called 'SQL Tips' for coworkers and an email distribution list people could sign up to. I have left this as originally written but have updated formatting for my WordPress theme. Sometimes your queries … Continue reading SQL Tip: Creating a Pivot table via T-SQL
SQL Tip: The DENSE and DENSE_RANK Functions
[edit: April 2019] This was originally posted to my internal (to Microsoft) blog on Dec 10, 2011 as part of a series I called 'SQL Tips' for coworkers and an email distribution list people could sign up to. I have left this as originally written but have updated formatting for my WordPress theme. Best Practice … Continue reading SQL Tip: The DENSE and DENSE_RANK Functions