DBA Support
This Friday Steve Jones talks about your support load. Let us know how many databases you support and what the load is like.
Introducing the Set-based Loop
Set-based programming doesn’t mean “no loops” or a single statement. Finding out the best ways to traverse a full hierarchy.
How to generate T-SQL scripts in SQL Server Management Studio with the collation settings
SQL Server collation is an important setting when creating database objects. One of the best ways to ensure that collation issues do not happen is to ensure that the collation settings are properly specified in the script that generates the database objects - Siddharth Mehta demonstrates how to do this.
A Software Warranty
Steve Jones says that developers should take responsibility for the code they deploy, perhaps with a warranty of sorts inside their company.
Taking Pictures from HTML
Sometimes a request from a user who doesn't appreciate the limitations of the technology can jolt you into discovering that an application feature that was, until recently, difficult to achieve is suddenly relatively easy. Dino was asked to allow the user to take photographs and associate them with an item of work. After he'd recovered from the shock, he decided that it was achievable, and now describes how he went on and did it.
Do you have DBA syndrome?
Sometimes DBAs become resistant to change. When they lose focus on their full purpose they may have DBA syndrome.
Pattern Matching : More Fun When I Was a Kid
Aaron Bertrand runs some tests to challenge an assertion that CHARINDEX is always faster at pattern matching than LEFT and LIKE.
PowerShell Solutions - Working with files
When we administer a SQL Database, we always have to work with files. This new article shows how to handle them using PowerShell.
Questioning the Interviewer
Asking questions in an interview is important, but there can be issues. Steve Jones talks a little about how to approach this.
Managing SQL Server Backup and Restore History Information
Greg Larson explains that SQL Server provides a couple of different ways to delete backup and restore history. If you want to remove backup and restore information for all databases based on a date you can use the sp_delete_backuphistory system stored procedure. Or you can use the system stored procedure named sp_delete_database_backuphistory if you want to remove all backup and restore history for a specific database.
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 KCP Jelambar Baru Raya Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Jl. Jelambar Baru Raya No.53 C, Jelambar, Kec. Grogol petamburan, Kota Jakarta...
BCA KCP Mal Taman Anggrek Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Jl. Letjen S. Parman No.Kav. 21 Lower Ground Lot. C 07, Slipi, Kec....
BCA KCU GREEN GARDEN Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Blok A.7 No, Komplek, Jl. Perumahan Green Garden 31-35, RT.1/RW.3, Kedoya Utara, Kec....
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers