×

Default database for SQL Server login

October 24, 2023

Why do SQL Server Logins have a default database? Kenneth Fisher and Aaron Bertrand explain this here and here. Here is a sample script to identify logins whose default database no longer exists on the server. Once you identify, you can assign another database as default to avoid the issues explained in the abovementioned two […]

T-SQL Tuesday # 157: Having fun with T-SQL

April 11, 2023

I thank Reitse Eskens (Blog|Twitter) for hosting T-SQL Tuesday #161. The topic for this month is Having Fun with T-SQL. I also want to acknowledge Adam Machanic’s vision behind this project. I learned a lot from some T-SQL Tuesdays and participated in a few. Thank you, Steve Jones (Blog|Twitter), for coordinating this program. If you are interested to […]

CPU Affinity Mask & TF8002

January 13, 2023

Setting CPU affinity in SQL Server is not a task you do every day. Rarely are there use cases when you need to do that. I had a recent requirement to do it. We plan to replace a physical server with half of its current CPU. Primarily due to faster CPU and workload moved off of […]

T-SQL Tuesday # 157: Year-End Tasks

December 13, 2022

I thank Garry Bargsley (Blog|Twitter) for hosting T-SQL Tuesday #157. The topic for this month is End of Year Activity. I also want to acknowledge Adam Machanic’s vision behind this project. I learned a lot from some T-SQL Tuesdays and participated in a few. Thank you, Steve Jones (Blog|Twitter), for coordinating this program. If you are interested […]

SQL PASS SUMMIT 2022 DAY-2 Keynote Live Blog

November 17, 2022

Pass Data Community Summit 2022 day two keynote titled “Doing More with Less: The Challenges Ahead for Every Data Professional” will be delivered by Redgate. There are three names (Jakub Lamik, Steve Jones, and Kathi Kellenberger) but five pictures. I am unsure if David Bick and Arne Eskandari will be on the stage. I am […]



profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook