One Way to Find Broken Code on Your Server

Before we approached our last major SQL Server upgrade, I was curious about what might break.  Yes, I had used the DEA to check our code against deprecated or...

Power BI Monthly Digest – July 2019

In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I will again guide you through some of our favorite Power BI

Quick 6 month check – how are those learning goals going…?

So in January I wrote a blog post on some goals I had this year: Some of my goals for 2019 It’s now July – how are things going?...

Join a List of Values

There are multiple ways of retrieving data from a table when you have a list of values. This article explores the use of the table value constructor.
Related Posts:

Correlate Trace...

Powershell script to get list of databases on a server

At one of my clients I received an email from one of the IT Project Managers asking a simple question:"Can you please let us know which databases reside on...

All the signs were there, but we didn’t understand them: an essay on gatekeeping in IT

This is the first in a series of posts about gatekeeping in Information Technology and other fields. I am not the first — nor will I be the last...

Investigating Azure Databricks

At SQL Saturday #884 – Pensacola, I dropped into Rodney Ladrum’s session on Azure Databricks (ADB) and the Traditional DBA. I had heard a bit about Databricks, and read...

Life Support 2008 – Audit Logons

Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep work involves auditing your server for any users that may still be using the instance.
Related...

New Security Update for SQL Server in July 2019 Patches

It doesn’t look like this would affect SQL Server 2008 or SQL Server 2008 R2 since the earliest reported platform is SQL Server 2014, but in Microsoft’s release of...

None of the IP addresses configured for the availability group listener can be hosted by the server Either configure a public cluster network 19456

Requirement: Remove a node from one of...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]