#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
127 reads
Kenneth Fisher
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)
365 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)
28 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
92 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
16 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)
198 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
169 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)
205 reads
Too many coding standards : T-SQL Tuesday #151
One of my favorite people, Malathi Mahadevan (blog|twitter), is our host this month and she’d like to talk about coding ... Continue reading
2022-06-14
46 reads
Running dynamic SQL in a different database
This is one of those things that on hindsight was a stupid problem, but still cost me hours and a ... Continue reading
2022-06-10 (first published: 2022-05-19)
461 reads
Blogs
Slides from SQL Saturday Los Angeles 2022
By Steve Jones
If you attended my talk at SQL Saturday Los Angeles 2022, then you can...
Creating a HEAD utility for Windows 10
By Steve Jones
One of the things I did often in my first career job was create...
Distributed Replay: The Little Engine That Almost Could
Honestly, sincerely, no kidding, I love Distributed Replay. Yes, I get it. Proof positive...
Forums
SELECT * FROM ( ... ) X
Hi all! I'm trying to understand how does this work. I've read a thread...
Would like to understand a better way of updating data that a cursor if possible
I have a need to update some data and also create a record of...
SQL Question - Column References
Hi. Looking for someone to help with a query I'm tring to run. I...
Ask SSC