The sysname datatype defaults to not NULL.
The other day I was creating a table to store some metadata. Since the metadata I was collecting (sys.databases.name for ... Continue reading
2021-09-10 (first published: 2021-08-26)
194 reads
Kenneth Fisher
Remote Desktop: Force the resolution to match the screen size.
One of the things I hate most about using remote desktop is when the resolution for the remote server is ... Continue reading
2021-09-09
47 reads
Auditing with “C2 Auditing” and “Common Criteria Compliance”
I’m going to be fairly high level on these because to be honest, if you are going to use them ... Continue reading
2021-09-07
73 reads
Work requests: It’s broke. Fix it.
Many years ago I was given a work request that literally just said: It’s broke. Fix it. I’m sure you ... Continue reading
2021-09-03 (first published: 2021-08-12)
428 reads
Experiment: Does sp_recompile on a table update associated views.
tldr: No. You have to use sp_refreshview. One of the only good things to come out of all of the ... Continue reading
2021-09-01 (first published: 2021-08-17)
304 reads
Thoughts on a work/life balance – Spend Wisely : T-SQL Tuesday #141
Wow, it’s TSQL Tuesday again! Tjay Belt (blog|twitter) is our host this month and he’d like us to talk about ... Continue reading
2021-08-27 (first published: 2021-08-10)
231 reads
Error: Cannot continue the execution because the session is in the kill state.
This was a rather interesting error. I’d certainly never seen it before, and based on one of the answers to ... Continue reading
2021-08-24
153 reads
Interview Tip: Know your resume
Seriously. Make a point of reading your resume before submitting it, and again before an interview. I’ve been helping with ... Continue reading
2021-08-20 (first published: 2021-08-05)
251 reads
A new presentation on Auditing your databases
I’m giving a presentation at the PASS Data Community Summit 2021 being put on by Redgate! It’s going to be ... Continue reading
2021-08-19
31 reads
SQL Homework – August 2021 – Security Standards
A few years back (wow time flies) I had you Work with Security. It’s been a while so if you ... Continue reading
2021-08-18 (first published: 2021-08-03)
311 reads
Blogs
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
The First Steps: Understanding the Basics of FinOps
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers