Manage Your Business Rules in T-SQL Query
Motivation At some point in the carrier, we have come across the problem of hard-coded values in SELECT or WHERE clauses. And we all agree that these hardcoded values must be parametrised. This bad habit usually backfires when we need to troubleshoot …
SQL Server 2022 Build List
This is a list of the builds for SQL Server 2022. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlserve …
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.