What you can do is based on more than your direct permissions.
What you have access to is not just what you have direct permissions to. The other day I needed to ... Continue reading
2022-10-19 (first published: 2022-10-06)
226 reads
SQLStudies
SQL Homework – October 2022 – Replication part 2
In August we started taking a look at replication. We learned some of the terms used, and set up a ... Continue reading
2022-10-04
11 reads
Being a script magpie
Last month (I ran just a little bit late writing this, it was meant to go out 9/29) Brent Ozar ... Continue reading
2022-10-01
100 reads
Viewing errors with extended events
A little while back I came across this post: Identifying failed queries with extended events. It has a script to ... Continue reading
2022-10-10 (first published: 2022-09-27)
312 reads
Conversion Precedence
Recently I talked about the difference between implicit and explicit datatype conversions. In it I ran this code: With the ... Continue reading
2022-09-20
10 reads
Making the mouse pointer easier to see.
I know this is way off my usual content but the other day someone was mentioning how easy it is ... Continue reading
2022-09-15
17 reads
Putting counters in names
It’s not all that unusual, or unreasonable to put a counter in a name. For example let’s say you need ... Continue reading
2022-10-03 (first published: 2022-09-13)
534 reads
What’s next 4th time
It’s now been about two and a half months since I was given notice and decided to blog about my ... Continue reading
2022-09-28 (first published: 2022-09-08)
201 reads
Creating a SERVER ROLE created a LOGIN as well.
One of my co-workers came to me the other day and told me that they found their network id as ... Continue reading
2022-09-21 (first published: 2022-09-06)
308 reads
SQL Homework – September 2022 – Query window challenge
I had every intention of doing Replication Part 2 this month but had a thought I liked better. I will ... Continue reading
2022-09-14 (first published: 2022-09-01)
315 reads
Blogs
New Job -> Week 2 -> Creating a Checklist
This is part of a series of new job blog posts. You can find...
SQL Server 2022 Administration Inside Out
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
WIT/DEI Mental Health and Wellness Day Challenge to Present
Back in December 2019, I started presenting my session on mental health with lots...
Forums
Tsql query to show currently running sql agent jobs
Hi All, Using Tsql query I want to know currently running sql agent jobs...
SQL Agent Job schedule
Hi All, Want to know what are the SQL Agent Jobs scheduled for today...
Need an alert for a sudden increase in data
Hi All, Today, all of a sudden the size of the data file (.mdf)...
Ask SSC