TOP vs Max/Min: Is there a difference?
Is there a difference between using TOP and MAX/MIN to return and end value to a table?
How to Get Started with SQL Server Management Studio
Learn How to Get Started with SQL Server Management Studio with Brent Ozar.
The Basics of PowerShell Day By Day
A basic introduction to PowerShell for those DBAs familiar with T-SQL.
Using Simple Linear Regression to Make Predictions
The first part of this article focuses on using an R program to find a linear regression equation and the second part is devoted to simple linear regression analysis.
SQL Server Agent Job Monitoring for Last Execution
In this article we continue our series of using PowerShell to monitor SQL Server by collecting the last run information for SQL Server Agent Jobs.
Attacks on Unsecured Databases
Unsecured databases are a problem, but someone is fighting this issue by wiping them out.
Azure Data Factory : Your First Data Pipeline
Introduction Azure Data Factory is the cloud-based ETL and data integration service that allows you to create data-driven workflows for orchestrating data movement and transforming data at scale. We can create and schedule data pipelines which can move data between various supported data stores. We can also use for data transformation before loading it into […]
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Seasons City,Telpon/Wa 0821-8200-239
Komp. Ruko Season City Blok E. 8, RT.13/RW.9, Jemb. Besi, Kec. Tambora, Kota Jakarta...
BCA KCP Mal Taman Anggrek,Telpon/Wa 0821-8200-239
Jl. Letjen S. Parman No.Kav. 21 Lower Ground Lot. C 07, Slipi, Kec. Grogol...
BCA KCP Grand Sudirman. Tlp:(+62) 8218168235
Ruko Grand Sudirman, Jl. P.B. Sudirman Blok C5-C6, Dauh Puri Klod, Kec. Denpasar Bar.,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers