#PowershellBasics: Running a .sql script file.
As with all programming tasks there are a number of ways to do something, this is just one that I ... Continue reading
2021-09-27 (first published: 2021-09-16)
497 reads
Kenneth Fisher
Database Sizes
Quick query today. I needed a list of database sizes so came up with this: Nothing exciting, but I figure ... Continue reading
2021-09-22 (first published: 2021-09-14)
398 reads
Rule 1: Be kind, be polite.
In my house, this is rule one. Sometimes it’s my wife or I reminding our kids, sometimes it’s them reminding ... Continue reading
2021-09-17 (first published: 2021-08-31)
325 reads
SQL Homework – September 2021 – How good is your recovery plan?
Last month I had you create a security standards document. This month we are going to document our recovery plan. ... Continue reading
2021-09-15 (first published: 2021-09-02)
212 reads
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)
179 reads
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
35 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
50 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)
383 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)
277 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)
224 reads
Blogs
Learn some critical SQL Security with the MidnightDBAs (Thursday, Jan 20)
By Jen McCown
Friends, the MidnightDBAs have a plan for 2022. A capital-P Plan. And it involves...
CosmosDB and Consistency
By Steve Jones
I was doing a little work with CosmosDB recently, and there were a few...
Daily Coping 17 Jan 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
How to reclaim space from a table
Hi All I have 1 TB database and i cant shrink it as it...
Linked Server UPDATE & DELETE fails . But INSERT & SELECTs work fine
Hello, I have a Windows 2019 machine. I have SQL Server 2016 and the...
Ask SSC