AD Discovery Info via SQL query

In a recent Twitter post I was asked about how to query Microsoft Endpoint Manager Configuration Manager (aka MEMCM, ConfigMgr, CM, or SCCM) to get the LDAP paths defined in Active Directory Discovery. So, while I answered the question (on Twitter) I thought it might be a good idea to write a quick blog on … Continue reading AD Discovery Info via SQL query →

SQL Tip: SSMS Options – Keyboard Shortcuts

[edit: May 2022] This was originally posted to my internal (to Microsoft) blog on Feb 16, 2012 as part of a series I called 'SQL Tips' for coworkers and anyone else who was interested. This has been sitting in my drafts forever but after sharing this tip in the 'Tips and Tricks' session of MMS … Continue reading SQL Tip: SSMS Options – Keyboard Shortcuts →

Enabling Dark Mode in SSMS (via PowerShell)

If you like Dark Mode and use SQL Server Management Studio (SSMS) you probably already know how to enable dark mode. However, at a recent conference I attended (MMS Miami) there were some people who didn't know you could enable it and I told them how. What I failed to mention is that every time … Continue reading Enabling Dark Mode in SSMS (via PowerShell) →

SQL Tip: Unicode/Non-Unicode & Implicit Conversion

[edit: January 2020] This was originally posted to my internal (to Microsoft) blog on March 11, 2013 as part of a series I called 'SQL Tips' for coworkers based on an email distribution list I sent out before the internal blog. I have left this as originally written (where possible) and updated the formatting for … Continue reading SQL Tip: Unicode/Non-Unicode & Implicit Conversion →

SQL Tip: FOR XML (Create a comma separated list of values)

[edit: December 2019] This was originally posted to my internal (to Microsoft) blog on October 7, 2013 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...and updated the … Continue reading SQL Tip: FOR XML (Create a comma separated list of values) →