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
Kenneth Fisher
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
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
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)
535 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
102 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)
309 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
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)
316 reads
Blogs
Migrating from EverNote to Joplin
By Steve Jones
Recently I got a message that my Evernote subscription was going up. It’s been...
Using Data Masker on Chinese Surnames
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
A New Word: Looseleft
By Steve Jones
looseleft – the feeling of loss upon finishing a good book, sensing the weight...
Forums
How can I show the last opening period for each project in my project dimension
I have two attributes hierarchies in my dimension [Dim Project]: Project Code Opening date...
Upgrading from 2016 to 2019 with Encryption
Hi, I have a few AWS EC2 instances currently running SQL Server 2016. I'd...
NOT LIKE Alternatives in WHERE clause
Hello, I need help to improve an existing (hence I cannot change table's structure...
Ask SSC