Data Load Optimisation using the SSIS Balanced Data Distributor
Optimize SSIS data loads using parallel processing and the Balanced Data Distributor
SSMS Maturity
Announcements recently for changes in SSMS mean that the tool many of us rely on is growing up.
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.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Klender Tlpn/wa0853.7373-7551
Jl. I Gusti Ngurah Rai No.8 A-B, RT.8/RW.6, Wil, Kec. Duren Sawit, Kota Jakarta...
Apakah ini layanan Halo ?????? 24 jam ???????? ??????
Ya, layanan Halo ?????? melalui (+62) (082--13111--179) tersedia 24 jam sehari, 7 hari seminggu...
BCA KCP Plaza Sentral Telpon/wa.0853.7373.7699
BCA KCP Plaza Sentral Telpon/wa.0853.7373.7699.Jl. Jend. Sudirman No.Kav.47, Karet Semanggi, Kecamatan Setiabudi, Kota Jakarta...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers