RAID 5 and SQL Server
Given that disk storage has come down substantially in price over recent years, will RAID 5 continue to be relevant as a storage configuration for databases?
Given that disk storage has come down substantially in price over recent years, will RAID 5 continue to be relevant as a storage configuration for databases?
A planning guide for the implementation of TDE in SQL Server.
A table contains the list of modifications made to each card. Your job is to write a query that shows the first number, current number (most recent) and the number of changes made.
This article demonstrates the relative merits of natural and surrogate keys and benchmarks their performance in different scenarios.
It’s important to profile your database queries to see what happens in response to Entity Framework queries and other data access activities, says Julie Lerman, who gives you the details on several profiling options to improve you coding.
This article presents a possible solution to the raffle logistics employed in SQL Server user group meetings around the world.
Howdy all…as is so often the case, I’m studying something – Powershell – and I’m in need of a reference to help...
components. These same configuration settings can be leveraged in Script Task, but you also have the option of triggering and tracking events in a considerably more customizable manner. This article explores features that provide this flexibility.
Do you know what to do in case of a data breach? Steve Jones talks about the importance of having a "runbook" for security that covers the same types of things you might need to know for disaster recovery.
SQLServerCentral has a mobile site to enable you to access the question of the day from your cell phone.
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
WA:08218154393 Jl. Jend. Sudirman No.49-51, Terban, Kec. Gondokusuman, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55223
WA:08218154393 Jl. Kisamaun No.57, RT.001/RW.006, Sukasari, Kec. Tangerang, Kota Tangerang, Banten 15118
Comments posted to this topic are about the item Forward Deployed Engineers
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers