SQL Overview IV - DBA's Morning Review
Continuing on with his very popular series on monitoring your servers, David Bird takes a look at how you manage checking on multiple servers.
The Software Comparison
Is building software like building a house? Steve Jones digs into the comparison at the start of an editorial series looking at other professions.
Optimistic Locking in SQL Server using the ROWVERSION Data Type
Using the default SQL Server READ COMMITTED isolation level, my application sometimes falls victim to the dreaded "lost update" condition where two of my users edit the same row for update but the user who submits his/her change last overwrites changes made by the other user. Is there a good way to check for this and prevent it?
Software Comparison - Part 2
The second editorial from Steve Jones comparing software to other types of jobs continues with a look at the legal profession.
Table-valued parameters – SQL Server 2008
In previous versions of SQL Server, it has not been possible to pass a table variable, as a parameter, to a stored procedure. Microsoft introduces table-valued parameters, along with other features, in SQL Server 2008. This article illustrates the function and usage of table-valued parameters.
The Software Comparison - Part 2
The second editorial from Steve Jones comparing software to other types of jobs continues with a look at the legal profession.
The Software Comparison - Part 2
The second editorial from Steve Jones comparing software to other types of jobs continues with a look at the legal profession.
Database Weekly - June 2, 2008
A look back at the news from the week including Windows 7 and taking an unwired vacation.
Database Weekly - June 2, 2008
A look back at the news from the week including Windows 7 and taking an unwired vacation.
The Software Comparison
Is building software like building a house? Steve Jones digs into the comparison at the start of an editorial series looking at other professions.
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
Alamat BCA KCP Dewi Sartika Tlp:08218200233
Telp/WA 62 8218200233 Jl. Dewi Sartika No.189, RT.1/RW.5, Wil, Kec. Kramat jati, Kota Jakarta...
Alamat Kantor BCA KCP MT Haryono Tlp:08218200203
Telp/WA 62 8218200203 Gedung Patria Park Jl. D.I. Panjaitan Kav. 5-6-7, Rukan-MZ No.RK 01...
Alamat BCA KCP Pondok Gede Tlp:08218200174
Telp/WA 62 8218200174 Jl. Raya Pd. Gede No.43, RT.1/RW.7, Lubang Buaya, Kec. Cipayung, Kota...
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers