The Software Comparison - Part 3
Steve Jones takes another attempt at comparing software development to another profession. Today's target: doctors.
2008-06-03
63 reads
Articles
Tips for moving from local disk storage to SANs
Move SQL Server storage to storage area networks (SANs) with network redundancy and storage multipathing tips. Learn about iSCSI databases and SQL failover.
2008-06-03
4,514 reads
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.
2008-06-02
13,433 reads
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?
2008-06-02
3,771 reads
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.
2008-06-02
41 reads
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.
2008-06-02
2,812 reads
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.
2008-06-02
39 reads
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.
2008-06-02
40 reads
Database Weekly - June 2, 2008
A look back at the news from the week including Windows 7 and taking an unwired vacation.
2008-06-01
45 reads
Database Weekly - June 2, 2008
A look back at the news from the week including Windows 7 and taking an unwired vacation.
2008-06-01
31 reads
Blogs
Rambling about Data on Wheels – origins, branding, expansion
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Think Twice Before Enabling Fabric’s Inbound Network Protection
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python
Most apps that call an LLM send every request to the same model. That...
Forums
AI Observability Challenges in FinOps as a DBA
Comments posted to this topic are about the item AI Observability Challenges in FinOps...
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers