SQL Server 7.0 – Transaction Log Not Backing Up
I have not worked with SQL Server 7.0 in a loooong time. So when I received a call from a...
A Function Gotcha with the Use of an Asterisk
This article describes and demonstrates the problem of using asterisk to select all fields from a table within a table function. (from Apr 2008)
Moore's Law
Moore's Law has been in the front of technical people's minds for years. However is the end of it's applicability to our world near? This Friday Steve Jones asks if you pay attention to the news about processor hardware.
Moore's Law
Moore's Law has been in the front of technical people's minds for years. However is the end of it's applicability to our world near? This Friday Steve Jones asks if you pay attention to the news about processor hardware.
Moore's Law
Moore's Law has been in the front of technical people's minds for years. However is the end of it's applicability to our world near? This Friday Steve Jones asks if you pay attention to the news about processor hardware.
Moore's Law
Moore's Law has been in the front of technical people's minds for years. However is the end of it's applicability to our world near? This Friday Steve Jones asks if you pay attention to the news about processor hardware.
Service Broker: Performance and Scalability Techniques
SQL Server Service Broker provides support for building asynchronous messaging and queuing applications with the SQL Server Database Engine. This paper describes a large scale customer scenario and the techniques employed in scaling Service Broker to process tens of thousands of messages per second on one server.
Ten Common SQL Programming Mistakes
It is not always easy to spot "antipatterns" in your SQL, especially in more complex queries. In this article, Plamen demonstrates some of the most common SQL coding errors that he encounters, explains their root cause, and illustrates potential solutions.
Writing a Technical Article – Where to Publish
This is part three of a series on writing a technical article. The advice might apply to non-technical articles, but...
A Good Word for ODBC
A guest editorial from Phil Factor puts in a good word for ODBC. This is the standard for Windows machines to connect to all kinds of data sources, and is both loved and hated by developers of all kinds.
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
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers