Who’s Hiring in the Database Community? September 2022 Edition
Is your company hiring for a database position as of September 2022? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must …
Starting my dream job…
“ A new adventure, there in your eyes. It’s just beginning, Feel your heart beat faster. Reach out and find your Happily ever after! “ Well, here I am. My first new job in over 20 years and it is a dream come true. I have always wante …
Into the unknown, sort of
Over half of my life ago, I was looking for a job. I had written a bunch of triggers and stored procedures at my first job, but I was relatively green. I had just (barely) gotten my degree in Computer Science, and was looking to get out of Cleveland, T …
[Video] Fragmentation Explained in 20 Minutes at SQLBits
What does fragmentation mean? How does it happen? Can you fix it with fill factor? Should you rebuild your indexes to fix it? At the SQLBits conference, I tried a new way of explaining it using markers and pieces of whiteboard paper as database pages, …
How to use fn_builtin_permissions SQL Server Security Function
The post How to use fn_builtin_permissions SQL Server Security Function appeared first on SQLServerCentral.
T-SQL Language Changes in SQL Server 2022
SQL Server 2022 is in preview in August 2022. I assume this version will be released later this year, and I have been testing it with the idea that I will be looking at an upgrade sometime in the next year for a few servers. There are a lot of changes …
SQL ConstantCare® Population Report: Summer 2022
Ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for SQL Server adoption rates, hardware sizes, or numbers of databases? Let’s find out in the summer 2022 version of our SQL Const …
Drawing Entity Relationship Diagrams with Stable Diffusion
Documenting your database and code is such a pain in the rear. Wouldn’t it be awesome if artificial intelligence could help? Good news! There are a bunch of AI systems like Stable Diffusion and DALL-E that will draw things based on your text prom …
The ultimate guide to web accessibility
The post The ultimate guide to web accessibility appeared first on SQLServerCentral.
Understanding the Metadata Function DATABASEPROPERTYEX()
SQL Server offers various metadata functions to return metadata information about databases and its objects. Today, I will discuss one of the popular system functions using which we can fetch database properties for a specified database. This article w …
Getting Started with Python Pandas and Dataset Profiling
The post Getting Started with Python Pandas and Dataset Profiling appeared first on SQLServerCentral.
Database Deployment with Terraform – The Basics
This article is an introduction to automated database deployments with Terraform. Terraform is now one of the most interesting tools available to work with Infrastructure as Code (IaC), presenting a simple and readable structure. Thousands of companies …
Performance Testing Databases with Flyway and PowerShell
The post Performance Testing Databases with Flyway and PowerShell appeared first on SQLServerCentral.
PSPO: How SQL Server 2022 Tries to Fix Parameter Sniffing
Parameter sniffing is a notorious problem for Microsoft SQL Server because it tries to reuse execution plans, which doesn’t work out well for widely varying parameters. Here’s a primer for the basics about how it happens. SQL Server 2022 in …
What’s New in SQL Server 2022 Release Candidate 0: Undocumented Stuff
Microsoft has an official list of what’s new in 2022 overall, but here I’m specifically focusing on system objects that might be interesting to script developers like you and I, dear reader. New stored procedure sp_get_table_card_est_and_av …