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.
Coming Attacks
What happens if we can't access the Internet? We should be prepared, at home and work. Steve Jones has a few comments.
Constant Data Types
Data types are an important part of how tables and variables work. Did you know that constants have databases too?
Intelligence from Data
This week Steve Jones looks at the idea of using AI and machine learning with your data to develop amazing new insight.
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
Alamat kontak resmi BCA KCU TANGERANG CITY Telp:0817866887
Tlp/Wa_Cs:0817-866-887 Komp. Tangerang City Ruko Skandinavia Blok H 6-8 & 18-20, Jl. Jenderal Sudirman...
Alamat kontak resmi BCA KCP MERR Tlp/Wa:0817866887
WhatsApp:0817-866-887 Jl. Dr Ir H Soekarno, Ruko promenade. 8 Surabaya 60298, Kedung Baruk, Kec....
Alamat kontak resmi BCA KCP Tidar Telp:0817866887
WhatsApp:0817866887 Jl. Tidar No.109, Petemon, Kec. Sawahan, Surabaya, Jawa Timur 60252
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers