Data Types - Does size really matter? - nvarchar vs. varchar

How many of us have created a new table and used the default and first data type nvarchar for all of the text/alphanumeric fields, or had...

Another option is coming to gain extended support for SQL 2012

Another option is coming to gain extended support for SQL 2012

If you still have SQL 2012 servers, you are probably aware that support...

Quick Tip About Fonts in Deneb Visuals in Power BI

This week, I was working with a client who requested I use the Segoe UI font in their Power BI report. The report contained a mix of core visuals...

Appalachian State Cyber Summit – September 8, 2023

Looking to attend a security summit in cooler weather that will benefit students? Applachian State holds an annual cybersecurity summit and this year it is scheduled for September 8,...

Adding Copilot to Azure Data Studio and a Few Experiments

As a part of a recent Data Exposed that I was on, there was an ADS update which mentioned Copilot being added. Since I’ve been experimented, I decided to...

Searching for People

Inside Redgate Software, someone posted a picture and was asking if anyone knew who the person was. In this case, there had been a conversation at an event, and...

Focusing on a Different S Curve

At the beginning of the year, I took a step back and looked at how far my career had grown. In large part because of the incredible data community,...

Book Review – Scalable Data Analytics with Azure Data Explorer

I recently finished the book Scalable Data Analytics with Azure Data Explorer (Modern ways to query, analyze, and perform real-time data analysis on large volumes of data), written by...

How To Identify The Grain

Creating a data warehouse can be challenging. Identifying the grain is one of the most important parts of having a quality data...

T-SQL Tuesday #165: Database Job Titles Roundup

This month I prompted bloggers to talk about what database job titles mean to them. Thank you to all who posted on this topic! Don’t worry; if you still...