Introduction Relational databases are designed to track changes introduced to a database by data modification language (DML) commands. The fundamental reason for this construct is to ensure that changes are durable and that they can be rolled back reliably. The typical DML command used in SQL are INSERT, UPDATE and DELETE. When INSERT introduces new […]
These days we often have multiple applications that need to exchange data in use by customers. Steve shares a few thoughts on his recent experiences.
Learn about expressions and date functions in the Power BI Report Builder.
A third-party database monitoring tool is an investment that drives enormous value for the bottom line of a business in ten key ways, from simplifying cloud migration to retaining talent. Here's how.
Learn different ways to recover a T-SQL script when using SQL Server Management Studio if SSMS is accidently shutdown without saving the script.
Steve has a few thoughts on building your own PC to help you with work or your career.
Using a change management system for database code is a new idea for many database administrators. Grant Fritchey explains the many benefits of database change control.
When you have multiple clients in your application, do you want one or many databases?
Database systems often need tuning for best performance. Lukas Vileikis explains to how to optimize my.cnf for MySQL performance.
Matt Gordon is a Microsoft Data Platform MVP and the Director of Data and Infrastructure at Rev.io. In this short video, he talks us through the 3 key reasons database monitoring tools are essential for him as a Director, and how they help him to lead a team successfully and productively.
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
How I used AI for this postChatGPT to generate images based on info specifically...
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
WhatsApp 082225313145 Jl. Sam Ratulangi No.86, Bitung Tim., Kec. Maesa, Kota Bitung, Sulawesi Utara...
WhatsApp 082225313145 Jl. Kolongan Jl. Raya Tomohon No.10 d/a, Kolongan, Kec. Tomohon Tengah, Kota...
Comments posted to this topic are about the item How Can SQL Server Detect...
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers