Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.
Claim your profile
Articles by Emmitt Albright
Window Function Basics - PARTITION BY – SQLServerCentral
One of the things that I've done over the last year to improve my T-SQL skills is learn to work with the various window functions that exist in the language. These were added in 2012 and there have been a number of improvements across the last decade. Since I struggled to understand some of the concepts early on, I decided to write a few articles on some basic concepts of how these functions work.
Comparing Two Execution Plans – SQLServerCentral
This is a short look at a technique that I discovered recently in Management Studio (SSMS). The technique is to compare two graphical execution plans in the tool to understand what they are doing and how two different queries might affect a particular system, both with the image and with the properties' data behind the graphical plan. This is actually something that was added in SSMS v16, but I hadn't upgraded until relatively recently, in the v18s.
Randomizing the Day Inside a Month Using T-SQL – SQLServerCentral
I recently ran across an interesting situation in our development databases. We have begun to protect various PII information in our systems by running scripts in the development databases when we restore a production backup. We do this as we have had executives express concern about losing data that exists on developer laptops and other systems. During one of our development sprints, we realized that we have a process that totals up birthdays in a month for some award system.
A Quick Start to Running Python Code in SQL Server – SQLServerCentral
SQL Server 2016 introduced the idea of running R language scripts from inside SQL Server. In SQL Server 2017, this capability was renamed Machine Learning Services and enhanced to include the ability to run Python code. This article gives a quick start in how you can execute Python code inside SQL Server and transform data in new ways. The Setup The ability to run Python code is not allowed by default in SQL Server. There are a couple of stages that you need to complete before you can run code.
Creating a Serverless Database in Azure – SQLServerCentral
I have been experimenting with Azure in my spare time, trying to better understand this cloud service and how I can use it for data projects. My employer is considering building some applications here, so I want to be prepared. In this article, I decided to document the process of creating a serverless database and give some impressions of what this means for me.
Fixing MLS Python Services to Load the Runtime – SQLServerCentral
Recently I went to work on a SQL Server 2017 instance and couldn't get the Python runtime to load. I'd keep getting this error: A strange error for me to see, and one that didn't quite make sense. How can the runtime not launch? However, restarting the instance still resulted in this error: Msg 39021, Level 16, State 1, Line 8 Unable to launch runtime for 'Python' script. Please check the configuration of the 'Python' runtime.
Key Rotation in TDE – SQLServerCentral
Transparent Data Encryption (TDE) has been around for a long time. It first appeared in SQL Server 2008, and after a rocky start with some bugs, it has become a regularly used feature for many organizations. While not perfect, it does provide some protection and auditors like to see physical protection features being used.
Show More
loading
Actions
Is this you?
As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.Get in touch with Emmitt
Contact Emmitt, search articles and posts on X, monitor coverage, and track replies from one place.
Learn more about Muck Rack