SQL Script to find the databases size
Sometimes we need to find out the size of the database on a server. Below SQL Scripts can be used...
2015-01-20
613 reads
Windows policy Lock Pages in Memory option and SQL Server instance in VM
As we know, this Windows policy Lock Pages in Memory option determines which accounts can use a process to keep data in physical memory, preventing the Windows operating system from paging...
2015-01-20
14 reads
Windows policy Lock Pages in Memory option and SQL Server instance in VM
As we know, this Windows policy Lock Pages in Memory option determines which accounts can use a process to keep data in...
2015-01-20
1,989 reads
Collation Conflicts
I have recently seen some “bad plans” being generated by the optimiser and from investigation, the cause came down to...
2015-01-20
1,739 reads
A Reason To Smile! - Deep Dives II
Over this past weekend, SQL MVP Kalen Delaney sent an inspiring note to the MVP email thread, and I wanted to...
2015-01-20
1,973 reads
SQLSaturday #362 – Austin, TX – Let’s Get Weird
I used to spend the 4th of July weekend (or week) in Austin with some buddy’s when we were in...
2015-01-20
928 reads
Upgraded SSD
I was going to call this an upgraded HDD, but that’s not right. Technically it’s a drive update, but really...
2015-01-19
2,070 reads
A Healthy SQL Server
T-SQL Tuesday has come and gone and I missed the boat due to some ongoing work constraints. With that said...
2015-01-19
565 reads
Exam Prep 70-463: Data Flow Source Adapters
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-01-19
887 reads
Understand the True Source of Problems
There’s an old joke that goes, “Doctor, doctor, it hurts when I do this.” While the person in question swings...
2015-01-19
778 reads
Blogs
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Forums
Alamat BCA KCP Thamrin Nine Telp:0821°7555°651
Telp/Wa 628217555651 Thamrin Nine Podium Area - UG Unit A, Jl. MH Thamrin No.10,...
Alamat BCA KCP Samanhudi Telp:08218200203
Telp/Wa 628218200203 Jl. Samanhudi No.57 B, RT.5/RW.3, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta...
Alamat BCA KCP AM Sangaji Telp:08218200233
Telp/Wa 628218200233 Jl. A.M Sangaji No.020 A, RT.3/RW.04, Petojo Utara, Kecamatan Gambir, Kota Jakarta...
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers