Finding a Mentor
Someone asked Steve Jones about finding a mentor to become a better DBA. He shares some thoughts and advice about how to do this.
7 Ways To Crash a Database
Many articles on database administration take the perspective of trying to help you do your job better. We thought we might take a different tack and poke a little fun at some of more egregious mistakes we've seen over the years at IT shops.
Beware the REPLACE function when doing heavy string parsing
I found something interesting the other day. I was attempting to optimize a very heavy string parsing routine using T-SQL and was having problems. I don’t normally use T-SQL for such heavy string parsing, but this was a special case of a legacy structure that I had to work with, so I had no choice.
Finding a Mentor
Someone asked Steve Jones about finding a mentor to become a better DBA. He shares some thoughts and advice about how to do this.
Finding a Mentor
Someone asked Steve Jones about finding a mentor to become a better DBA. He shares some thoughts and advice about how to do this.
Finding a Mentor
Someone asked Steve Jones about finding a mentor to become a better DBA. He shares some thoughts and advice about how to do this.
Getting started with SQL Server database diagrams
In this tip I show you how you can use the built-in SQL Server database diagram tool. I go through some of them messages you may get when getting started and then look at various tasks that you would perform using this free tool.
SQL Bits
The next SQLBits conference is being held Nov 19-21, 2009 in Newport, UK. If you want to attend or even speak, read more about this event.
Moving Databases with the ALTER Command
A script that will move the files of a passed set of databases to a new data folder and log folder from James DiMauro.
A True SQL OS
SQL Server is so large and complex that it's like an operating system. In fact, there the core engine is often referred to as the "SQL OS" by Microsoft developers. Steve Jones would like to see SQL Server as it's own OS at some point.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCU GREEN GARDEN TLP/WA 08216366654
Blok A.7 No, Komplek, Jl. Perumahan Green Garden 31-35, RT.1/RW.3, Kedoya Utara, Kec. Kb....
BCA KCP Pondok Timur CSTelpon : 0853-73737551
Jl. Pd. Timur Indah Kompleks Perumahan Taman Nirwana No.8, RT.005/RW.019, Pengasinan, Kec. Rawalumbu, Kota...
BCA KCP Telepon Kota TLP/WA 08216366654
Jl. Ps. Pagi Raya No.9, Roa Malaka, Kec. Tambora, Kota Jakarta Barat, Daerah Khusus...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers