Category Archives: Microsoft SQL Server
-
End of year planning: T-SQL Tuesday #157
Leave a commentDecember 13, 2022 by Kenneth Fisher
It’s T-SQL Tuesday again! And Garry Bargsley (blog|twitter) has asked us what we have planned for the end of the …
Continue reading -
#PowershellBasics: Warnings and how to hide them.
1December 8, 2022 by Kenneth Fisher
One of my favorite parts of having a new job is that I learn a ton. (No really, my brain …
Continue reading -
SQL Homework – December 2022 – What’s new in SQL Server?
Leave a commentDecember 1, 2022 by Kenneth Fisher
SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still got a while before retirement. I …
Continue reading -
What is production grade code? : T-SQL Tuesday #156
1November 8, 2022 by Kenneth Fisher
It’s that time of the month again! It’s T-SQL Tuesday and this month Tom Zika (blog|twitter) is hosting. Tom would …
Continue reading -
SQL Homework – November 2022 – Getting ready for the next time you have to look for a job.
Leave a commentNovember 1, 2022 by Kenneth Fisher
Back in July I suggested that you get your resume up to date. It’s something I’d wish I’d kept up …
Continue reading -
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