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)

Advertisements

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

Moving the ConfigMgr site database to an Always On Availability Group

Back in 2012 I really wanted to be able to have the ConfigMgr database in an Always On Availability Group (I’ll refer to this as an “Availability Group” or an “AG” from now on). So, a coworker and I made that happen – sure, it wasn’t supported and auto-failover didn’t work but nevertheless we had … Continue reading Moving the ConfigMgr site database to an Always On Availability Group