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)
170 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-09-27
6 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)
274 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
16 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)
304 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-09-13
252 reads
Why is security important in a dev environment?
I was asked a rather interesting question during an interview recently. It went something like this: Your resume says you’ve ... Continue reading
2022-09-05 (first published: 2022-08-23)
211 reads
New parameter in sp_DBPermissions and sp_SrvPermissions: @CopyTo
I’ve added a new parameter to my permissions scripts (well, just the main two for now). Fair warning, it’s in ... Continue reading
2022-08-31 (first published: 2022-08-18)
402 reads
When good enough is good enough
Any time I’ve learned about the optimizer there is always one important thing that’s brought up. The optimizer is not ... Continue reading
2022-08-30
17 reads
Blogs
Storytelling with Data – Enertia User Conference 2022
By DataOnWheels
Thank you to everyone who attended my session at the Enertia User Conference in...
Daily Coping 30 Sep 2022
By Steve Jones
Today’s coping tip is to find a new way to use one of your...
Why You Need Presentation Skills
And no, the answer is not because you want to be a Microsoft MVP....
Forums
How and where did you learn SQL from?
Could you give me advice on where I should learn SQL and Python to...
Save Query Results to Excel and Automatically run it
Hello, I have a very simple query Select * from Employees where company...
TCP Provider: A connection attempt failed for target server
Hi. In source SQL Instance target linked server has been created and connection tested...
Ask SSC