Technical Article

Microsoft Platform Vaults into New Performance Territory

SQL Server 2000 Enterprise Edition clocked an incredible 308,620 transactions per minute (tpmC)1 running on Windows .NET Server 2003, Datacenter Edition on an NEC TX7 server with 32 Intel Itanium 2 processors. The NEC system sets a new performance record on Windows, nearly doubling the best published 32-bit result. In addition, this Microsoft/Intel/NEC solution delivers the best price-performance of all results on the Top Ten performance list, at just $14.96/tpmC.

Technical Article

NGSSQuirreL Released.

NGSSoftware have released NGSSQuirreL, a security audit and management tool for SQL Server. Designed to ease the administrative burden of securing SQL Server, NGSSQuirreL finds the security holes then generates a lockdown script based upon the vulnerabilities found so the server can be secured in a matter of minutes; and regular audits can help keep it that way. For more information or an evaluation copy please see the NGSSite - http://www.nextgenss.com/.

SQLServerCentral Article

Performance Adding Hints

During the process of performance tuning queries and stored procedures there comes a time when you will notice that the execution plan selected by SQL Server is not the best plan. On occasion, everything you try doesnt cause SQL Server to choose the best way to execute your code. These are the times when hints can improve performance.

Blogs

Using Flyway Prepare for State-Based Deployments

By

One of the neat enhancements made to Flyway was the addition of state-based workflows...

How I Migrated to Azure PostgreSQL Flex from Single Server

By

I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...

Have a Plan for Your Personal Downtime

By

Most of us know that spending a lot of time on social media and...

Read the latest Blogs

Forums

Resolving Access Denied Errors During SQL Server Database Attachment

By Noman072

Comments posted to this topic are about the item Resolving Access Denied Errors During...

The Lesser Used Functions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Lesser Used Functions

SQL in an Azure VM Backup

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL in an Azure VM...

Visit the forum

Question of the Day

SQL in an Azure VM Backup

If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)

See possible answers