Interview Trick Questions
Today, I am diverging from the more technical posts that I routinely share. Instead, as the title suggests, I want...
2019-02-25 (first published: 2019-02-04)
3,172 reads
SQL RNNR
Interview Trick Questions
Anybody that has interviewed for a job has most likely run into the trick question. Some interviewers like to throw out multiple trick questions all in an effort to...
2019-02-04
4 reads
Defaults In msdb Database
Today is a day to discuss defaults. It started with the day being TSQL Tuesday and having a topic of...
2019-02-19 (first published: 2019-01-28)
2,453 reads
Defaults In msdb Database
The defaults in the msdb database are about what is missing. It's missing quite a few things that could be critical to your environment.
Related Posts:
SQL Server Configurations - Back...
2019-01-28
10 reads
Easy Permissions Audit
Something I have written about more than a handful of times is the need to audit. When people think about...
2019-02-05 (first published: 2019-01-21)
2,568 reads
Easy Permissions Audit
This is an introductory level method demonstrating how to quickly audit database objects and principals for granted permissions.
Related Posts:
Failed to Create the Audit File December 31, 2017
Quick Permissions...
2019-01-21
7 reads
Audit SQL Agent Jobs
One probably seldom thinks of the SQL Agent jobs scheduled on the SQL Server instance – unless they fail. What if...
2019-01-17
986 reads
Audit SQL Agent Jobs
One probably seldom thinks of the SQL Agent jobs scheduled on the SQL Server instance - unless they fail. What if the job failed because something was changed in...
2019-01-17
211 reads
Quick Permissions Audit
Whether it is for a client, an audit, or just for good housekeeping, DBAs will often need to figure out...
2019-01-21 (first published: 2019-01-14)
2,889 reads
Quick Permissions Audit
DBAs often need to figure out who has access to what. When that need arises, it is frequently adequate to just perform a quick permissions audit.
Related Posts:
Easy Permissions Audit...
2019-01-14
11 reads
Blogs
Enterprise AI Operating Rhythm – Top 5 practices for 2026
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
Stop Being Surprised by Your Azure Bill: Use Budgets
By John
When organizations migrate workloads to Azure, the focus is usually on architecture, performance, and...
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
Forums
The Max PK Length
Comments posted to this topic are about the item The Max PK Length
My experience using the GitHub Copilot in SSMS 22
Comments posted to this topic are about the item My experience using the GitHub...
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
Question of the Day
The Max PK Length
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers