You can monitor your servers with the new SQL Monitor software from Red Gate Software. MVP Brad McGehee showed how the SQLServerCentral servers are being monitored publicly. The slide decks and Q&A transcript at available.
2010-12-02 (first published: 2010-11-09)
4,766 reads
I have audited for permissions on my databases because users seem to be accessing the tables, but I don't see permissions which give them such rights. I've gone through every Windows group that has access to my SQL Server and into the database, but with no success. How are the users accessing these tables?
2010-12-02
2,606 reads
A big part of my DBA career has centered around identifying and sharing SQL Server DBA best practices. There are...
2010-12-02
1,630 reads
When working with Script Task of SQL Server 2008 Integration Services, it is important to ensure that your custom code complies with the most elementary programming practices. Learn how to handle unexpected errors that interfere with the successful execution of your code.
2010-12-01
3,288 reads
The other day I was asked to provide the port number that a SQL Server instance was listening on. As...
2010-12-01
1,744 reads
MVP Allen White shows how he can use Powershell to setup SQL Source Control from Red Gate Software on Nov 18, 2010.
2010-11-30 (first published: 2010-11-10)
1,243 reads
Windows PowerShell has the concept of execution policy that determines in which cases script and configuration files are able to...
2010-11-30
1,310 reads
sp_locks is a useful tool which can help a DBA in detecting and troubleshooting blocking and concurrency scenarios. This article demonstrates a worked example of using sp_locks to troubleshoot a database concurrency issue.
2010-11-30
3,539 reads
This article presents a case study of using the Management Data Warehouse feature in SQL Server 2008 to analyze disk usage trends by product.
2010-11-29
3,915 reads
The first part of your job is to identify the unique color combinations of products and the second part is to identify the products that have the given color combination.
2010-11-29
1,363 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.58, Balonggede, Kec. Regol, Kota Bandung, Jawa Barat 40251
Alun Graha, Jl. Prof. DR. Soepomo SH No.233 Lt. Dasar, RT.007/RW.1, Menteng Dalam, Kec....
BCA KCU KALIMALANG Hub.0813•7887•595.Jl. Tarum Barat Blk. E No.5, Wil. Kota, Kec. Duren Sawit,...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers