#PowershellBasics: Expanding the column width to avoid truncation
I was recently asked to get a list of all of the services running on one of the boxes we ... Continue reading
2022-07-20 (first published: 2022-07-07)
444 reads
Kenneth Fisher
#PowershellBasics: Multi-line commands
When I’m sharing code one of the things I hate most is having a scroll bar along the bottom. I ... Continue reading
2022-07-19
109 reads
#PowershellBasics: Write the output to a file.
Last week I posted about a request to get a list of services. The first problem I ran into was ... Continue reading
2022-07-14
233 reads
How do I tell if identity_insert is turned on and if so what table?
TLDR; The code to do this is below but it’s a bit hokey and probably isn’t worth it. It’s pretty ... Continue reading
2022-07-11 (first published: 2022-06-24)
524 reads
SQL Homework – July 2022 – Update your resume.
Resumes have been on my mind a lot recently. I’ve been thinking that I wish I’d kept mine up to ... Continue reading
2022-07-06 (first published: 2022-07-05)
34 reads
What’s next? Pt 2
Well, it’s only been about a week and a half but here’s an update. First a piece of advice. You ... Continue reading
2022-06-30
98 reads
Creating a Database Audit Specification can create new users & schemas in the background
I love database audits. They are simple, easy to use, effective, not overly resource intensive, and can be turned on ... Continue reading
2022-06-28
34 reads
TSQL Tuesday #150: Your first technical job. Rollup.
This months subject for T-SQL Tuesday was Your first technical job. I have to say I really really enjoyed reading ... Continue reading
2022-06-24 (first published: 2022-05-24)
251 reads
What’s next?
As I’m sure a fair number of you already know I was told my position had been eliminated. They are ... Continue reading
2022-06-21
343 reads
An auditing mind set
I little while back I presented at Pass Data Community Summit. Specifically the presentation was Auditing your data and data ... Continue reading
2022-06-15 (first published: 2022-05-31)
234 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Kertajaya Indah No.Telp 083831617937
Whatsapp.083831617937 Jl. Manyar Kertoardjo 95,Mojo, Kec. Gubeng, Kota SBY, Jawa Timur Surabaya, Jawa Timur,...
BCA KCP Kertajaya No.Telp 083831617937
Whatsapp.083831617937 Jl. Kertajaya No.35, RT.001/RW.10, Manyar Sabrangan, Kec. Mulyorejo, Kota SBY, Jawa Timur Surabaya,...
BCA KCP Kenjeran No.Telp 083831617937
Whatsapp.083831617937 Jalan Kenjeran No.98, Simokerto, Tambakrejo, Kec. Simokerto, Kota SBY, Jawa Timur Surabaya, Jawa...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers