How to Fix a Corrupt MSDB SQL Server Database
Keep reading and you will see that there is another way to rebuild the msdb database without compromising the master database.
Training Computer Scientists
What's the best way to enter this business? Steve Jones has a few thoughts on the traditional CS degree.
Survey: Development and Test Databases
Unless development happens directly on the production database, every organization will manage one or more development and test instances. Redgate is doing research to learn how development and test databases are managed within organizations. If you’d like to know more about our plans, or are happy to help us understand the problem, please take part in this 3-page survey.
The Importance of Our Work
Work is important, and it's a large part of our lives, but Steve Jones notes we need to keep things in perspective.
Trusting Source Control
One of the benefits of a version control system (VCS) is that you can look at the history of code changes. Ed Elliot shows us a situation where that helps a DBA track down a problem.
Grant User Access to All SQL Server Databases
Consider a situation when you have a large number of databases on your SQL Server, and you are requested to grant user access to all SQL Server databases. How can you grant access to a user for all databases on a SQL Server instance?
Learning about Multiple Tempdb Files
References and links to help you learn how to create multiple tempdb files.
Learning about the Cardinality Estimator
A few links to help you understand the Cardinality Estimator.
Learning SQL Server 2014
A list of technologies in SQL Server 2014 that you might want to learn more about.
Not a cloud to be seen
Phil factor find much to admire in the StackOverflow architecture. It is built on SQL Server, doesn't use microservices or the cloud. It all seems a bit retro, but it manages manage 440 million queries a day, peaking at 8500 queries per second, and never even breaks into a sweat.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Sopo Del Hub:Cs.083831618816
WhatsApp:083831618816Gedung Sopo Del Office Tower A Lantai GF-15, Jl. Mega Kuningan Barat III No.Lot...
BCA KCP Metro Tanah Abang Telp:08213111109
Pusat Grosir Metro Tanah Abang 2 Lt. 7. 10, Jl. K.H. Wahid Hasyim No.189,...
BCA KCU JEMBER No tlpon:083138717148
Whatsapp:083138717148.Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates, Kabupaten Jember, Jawa...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers