Category Archives: Microsoft SQL Server
-
What can you do with a SELECT statement without a FROM clause?
4October 25, 2022 by Kenneth Fisher
Some people have shower thoughts, I have 1am thoughts. In this case it was the only keyword required in a …
Continue reading -
Comments in your generated code : T-SQL Tuesday #155
4October 11, 2022 by Kenneth Fisher
The ever amazing Steve Jones (blog|twitter) is our host this month. And in case you didn’t know he also is …
Continue reading -
What you can do is based on more than your direct permissions.
1October 6, 2022 by Kenneth Fisher
What you have access to is not just what you have direct permissions to. The other day I needed to …
Continue reading -
SQL Homework – October 2022 – Replication part 2
Leave a commentOctober 4, 2022 by Kenneth Fisher
In August we started taking a look at replication. We learned some of the terms used, and set up a …
Continue reading -
Being a script magpie
Leave a commentOctober 1, 2022 by Kenneth Fisher
Last month (I ran just a little bit late writing this, it was meant to go out 9/29) Brent Ozar …
Continue reading -
Viewing errors with extended events
3September 27, 2022 by Kenneth Fisher
A little while back I came across this post: Identifying failed queries with extended events. It has a script to …
Continue reading -
Conversion Precedence
1September 20, 2022 by Kenneth Fisher
Recently I talked about the difference between implicit and explicit datatype conversions. In it I ran this code: With the …
Continue reading -
Making the mouse pointer easier to see.
6September 15, 2022 by Kenneth Fisher
I know this is way off my usual content but the other day someone was mentioning how easy it is …
Continue reading -
Creating a SERVER ROLE created a LOGIN as well.
1September 6, 2022 by Kenneth Fisher
One of my co-workers came to me the other day and told me that they found their network id as …
Continue reading -
SQL Homework – September 2022 – Query window challenge
Leave a commentSeptember 1, 2022 by Kenneth Fisher
I had every intention of doing Replication Part 2 this month but had a thought I liked better. I will …
Continue reading
SQL Studies 