myLittleTools announces myLittleAdmin v1.5a
myLittleTools is proud to announce the release of myLittleAdmin for SQL Server. With version 1.5a, myLittleAdmin etablishes itself as the best web-based database administration tool for ASP developers.
Murphy's Laws of Computing
I found this on the Internet, but I think it's really my own personal list.
Middle Tier Application Data Caching with SQL Server 2000
Middle tier applications often use a single database management system (DBMS) to store data, which can expose scaling limitations as the number of user requests increases. Caching, a technique used to increase application performance by copying data and then using the copied data in place of the original data, can dramatically increase the throughput (the number of application requests serviceable per unit time) and scalability of middle tier applications.
Dynamic SQL vs. Static SQL Part 2, Code
Robert Marda continues his series on dynamic SQL and shows you how to rewrite some queries that you may think need dynamic SQL.
Freeware DBEzze 1.0 Released
DBEzze is a freeware product that can look into a database and generate XML structural or data output. It can also generate INSERT statements from a table, view or stored procedure. This freeware product is available for download from SQLServerCentral.com members only.
SQL Mail Resources
As I work with a particular topic or problem, I often research on the Internet
different opinions, white papers, etc. Here is a list of resources that are located both
on SQL Server Central and other sites that I have found useful.
Microsoft Tunes Windows
Microsoft Corp. is considering bundling in the next version of Windows a pared-down version of its next-generation SQL Server database and the relational file system that goes with it.
Performance Comparison: Data Access Techniques
Architectural choices for data access affect performance, scalability, maintainability, and usability. This article focuses on the performance aspects of these choices by comparing relative performance of various data access techniques, including Microsoft® ADO.NET Command, DataReader, DataSet, and XML Reader in common application scenarios with a Microsoft SQL Server™ 2000 database.
How to Fix Inconsistent Metadata Errors
Why does changing a table on a SQL Server 7.0 server cause "OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time." to occur when query the table from a SQL Server 2000 server via link to other. In this article by James Travis, he shows you what the problem is and how to fix it.
Blogs
Speaking at the NYC Lunch and Learn DevOps Devour Hour
By Steve Jones
This Friday is the NYC DevOps Devour hour, which is actually 3 hours. Plus...
What’s new in SQL Server 2025 CTP 2.0
Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...
Monday Monitor Tips: Beyond SQL Server
By Steve Jones
Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...
Forums
Deadlocks and Backups - Need help
Hey everyone, please excuse my ignorance, I'm just .NET developer and have used SQL...
Does Version Control Scare You
Comments posted to this topic are about the item Does Version Control Scare You
Unlimited Text
Comments posted to this topic are about the item Unlimited Text
Question of the Day
Unlimited Text
If I want to get unlimited amounts of data back from a varchar(max)/nvarchar(max) column, what do I run?
See possible answers