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 […]
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 […]
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 […]
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 […]
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 […]