When looking for impending problems due to lack of disk space it's necessary to know how much space is available on each drive. There have been other tips written about how to do this, but in this tip I show you a way this can be done using SQLCLR.
2010-04-27
3,390 reads
This article by Paul White presents an optimisation for paging through a wide data set.
2010-04-26
27,837 reads
To finish up the month of April we’ve got sessions from AppDev and DBA and I’m even including one from PASS on ‘Intro to Speaking At PASS’.
2010-04-26
455 reads
Adding and removing nodes in SQL Server Clusters is not so difficult, and instructions on how to do so abound on the internet. However, mismanagement when adding/removing nodes can quickly become a 'gotcha' that wastes time. Bo Chen offers insight into some of those scenarios that are not normally covered in the standard online documents.
2010-04-26
2,048 reads
The stuff of nightmares, a corrupt database. However Gail Shaw gives you some advice about how to handle this situation.
2010-04-23 (first published: 2009-02-16)
64,090 reads
Handling security in an application can be a bit cumbersome. R Glen Cooper brings us a database design technique from the real world that can help you.
2010-04-23 (first published: 2010-04-06)
6,534 reads
In a previous tip on creating a Function to Return Default SQL Server Backup Folder , you've seen how you can create a T-SQL function to query the registry and retrieve the default SQL Server Backup folder. Is there an easier way to do it in Windows PowerShell?
2010-04-23
2,763 reads
Testing and analysis of new backup compression and table/index compression features of SQL Server 2008.
2010-04-22
7,688 reads
2010-04-22
3,825 reads
We can all recognize good-quality database code: It doesn't break with every change in the server's configuration, or on upgrade. It isn't affected by concurrent usage, or high workload. In an extract from his forthcoming book, Alex explains just how to go about producing resilient TSQL code that works, and carries on working.
2010-04-22
5,476 reads
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...
Jl. Dewi Sartika No.15, Sayang, Kec. Cianjur, Kabupaten Cianjur, Jawa Barat 43213
BCA Finance Bekasi Layanan Mobil Telpon/WA:085188120691 KOMPLEK MEGA OFFICE PARK, Jl. Harapan Indah Boulevard...
BCA KCP Ketapang Telpon/WA:08137887595.Blok A/3-4, Ketapang Indah, Jl. KH Zainal Arifin, Krukut, Kec. Taman...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers