Why would database performance remain low and fragmentation high event though the entire database has been defragmented every night? In this tip we cover how SHRINKFILE works and some of the issues it might create.
The start of a new series from Leo Peysakhovich that looks at some of the issues with moving data around between systems and ensuring that it is in sync between them.
This week Steve Jones finds some issues with the security of third party vendor software.
It's important to have time to think, but quite often we don't find the time. Steve Jones comments on how he's learned just how valuable this can be.
There are some good reasons to think about attending the 2010 PASS Community Summit.
This challenge has a (fake) reference to the 24 Hours of PASS event and your task is to count the number of attendees who watched the complete presentation of each speaker.
If you are not keen on repetitive typing, you can still rapidly produce production-quality documented code by planning ahead and using Extended properties, and system views. Phil Factor explains, with some Scary SQL
Determining which columns to index in a table used to be a very time consuming process that was as much art as science. New author Ranga Narasimhan brings us an article that shows how SQL Server 2005 makes this much easier.
ROWE stands for a Results Oriented Work Environment. This Friday Steve Jones asks if you'd like to work in one.
In a recent thread here on SQL Server Central, it was pointed out that a member of the securityadmin fixed...
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Cs Lion WhatsApp 083843888827 Jl. Inspeksi Cakung Drain Tim. No.1, RW.6, Cakung Bar., Kec....
Plaza Bona Indah Jl. Karang Tengah Raya blok B/12, Lb. Bulus, Kec. Cilandak, Kota...
Plaza Bona Indah Jl. Karang Tengah Raya blok B/12, Lb. Bulus, Kec. Cilandak, Kota...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers