#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
342 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
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Analysis Services Model w/ Direct Query and (Default Veritpaq)
Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers