PowerSQL – Find Size, Name, LastAccess and Last Modified time of all bak files across ALL Servers.
We came across a scenario where database bak files being created from long time which are no more in use...
2013-04-30
1,117 reads
Installing SSMS 2012 all by it’s lonesome
SQL Server Management Studio (SSMS) is not offered as a standalone download on MSDN.
Installation requires the user to download the...
2013-05-07 (first published: 2013-04-30)
26,618 reads
Enhance your career by blogging!
When I started my blog two years ago, I never would have thought how much it would help my career. I...
2013-04-30
2,851 reads
SQL Server +0 and -0
This is a very interesting error happened in one of my clients’ databases. Their database has been running for at...
2013-04-30
1,574 reads
Looking Forward
For the past couple months I’ve been looking forward to a 5 week break, a chance to think about what...
2013-04-30
1,413 reads
Five Ways to Improve Your Productivity with SSMS
For most DBAs, Management Studio is the primary work tool.
That’s why properly using it can save a-lot of time and...
2013-05-06 (first published: 2013-04-30)
7,724 reads
My First White Paper – Top 10 Tips for Optimizing SQL Server Performance
Earlier this year I had the chance to collaborate on my first ever white paper “Top 10 Tips for Optimizing...
2013-04-30
1,437 reads
SQLDiva reviews the First PASS Business Analytics Conference
Join Mellissa Demsak (twitter – SQLDiva) for a review of what she rates as the best from PASS’s first attempt at...
2013-04-29
1,315 reads
How to collect cluster Information using TSQL
Sometime back I was involved in a project which was to collect information for the servers we are supporting – creating...
2013-04-29
1,903 reads
INFORMATION_SCHEMA the un-sung system views
I spend a reasonable amount of time looking through various forums, answering some questions and reading the answers to others....
2013-04-29
2,642 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 BCA KCP Tmn. Harapan Indah Telp:0821°8200°233
Telp/Wa 628218200233 Komp. Taman Harapan Indah Blok EE No.1, RT.14/RW.7, Jelambar Baru, Kec. Grogol...
Alamat BCA KCP Rajawali Telp:0821°8200°203
Telp/WA 628218200203 Rukan Multiguna, Jl. Rajawali Selatan Raya Blok C5. 2, Blok 2, Pademangan...
Alamat BCA KCP Mangga Dua Mal Telp:0821°7555°651
Telp/Wa 628217555651 Mal No. RM, Jl. Mangga Dua Raya No.49, RT.1/RW.12, Mangga Dua Sel.,...
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