Office Hours, Short Text Answers Edition
Not all of the questions y’all post at https://pollgab.com/room/brento require long, thought-out answers. Some are just one-line specials, like these: F’legend: Hi Brent, in reply to a question talking about database restores for 1TB+ you a …
Metadata Functions in SQL Server and Their Use Cases
The post Metadata Functions in SQL Server and Their Use Cases appeared first on SQLServerCentral.
Managing Datasets for Database Development Work using Flyway
The post Managing Datasets for Database Development Work using Flyway appeared first on SQLServerCentral.
The Uses of Dependency Information in Database Development
The post The Uses of Dependency Information in Database Development appeared first on SQLServerCentral.
SQL WAITFOR Command to Delay SQL Code Execution
The post SQL WAITFOR Command to Delay SQL Code Execution appeared first on SQLServerCentral.
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 …