SQL Server – Script to get Service Account for all local instances
Earlier on my blog I posted on How to get SQL Server Service Account using T-SQL. That works on a...
2013-08-26
140 reads
SQL Server – Script to get Service Account for all local instances
Earlier on my blog I posted on How to get SQL Server Service Account using T-SQL. That works on a...
2013-08-26
236 reads
SQL Server – Script to get Service Account for all local instances
Earlier on my blog I posted on How to get SQL Server Service Account using T-SQL. That works on a...
2013-08-26
1,279 reads
The effect of VLF size on shrinking the log.
I was wondering the other day how VLF (Virtual Log File) sizes effected shrinking the log file so I decided...
2013-08-29 (first published: 2013-08-26)
2,641 reads
How to Become a Better DBA
Whether you’re just starting out or already a few years in the game, you’re probably wondering how you can become...
2013-08-30 (first published: 2013-08-26)
3,845 reads
Creating and Executing an SSIS Package Programmatically
One of the nice things about SQL Server Integration Services (SSIS) is its extensibility.
If you find you have need for...
2013-08-25
28,377 reads
Using DMV to identify sessions in your SQL Server
More than running sp_who2, which gives you more information than the good ol’ sp_who, or querying sys.dm_exec_sessions to check all...
2013-08-24
823 reads
Who’s doing what to your SQL Server?
When doing any kind of troubleshooting in your SQL Server first thing you ask is who is currently connected to...
2013-08-24
675 reads
When and why you should use 1=1 in WHERE clause?
One Interviewer ask this question during interview of my friend.It is easy to answer but need some specific and to...
2013-08-24
1,273 reads
Authority as the Enemy: Notes on elections and perceptions in the tech community
Let’s hear a story. The story is true, but elements have been generalized and fictionalized for simplicity, and so’s not...
2013-08-23
617 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Alamat Telp BCA KCP Bintaro +62 838-4945-0961
Wa:083849450961 Jl. RC. Veteran. 9, dan No.9A, RT.9/RW.3, Bintaro, Kec. Pesanggrahan, Kota Jakarta Selatan,...
Alamat Telp BCA KCP Kepa Duri +62 838-4945-0961
Wa:083849450961 Jl. Mangga Raya No.20, RT.4/RW.3, Duri Kepa, Kec. Kb. Jeruk, Kota Jakarta Barat,...
Training the next generation
Comments posted to this topic are about the item Training the next generation
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers