The storage subsystem for a SQL Server can prove to be a bottleneck if the best choices of hardware aren't made, but there are ways to relieve the I/O bottlenecks if the causes are well understood. This requires benchmarking. Glenn Berry gives expert advice on getting to grips with the disk subsystem.
Solid State Drives are becoming more commonplace in database systems. eBay and Facebook have implemented large SSD systems in their environments. Steve Jones thinks DBAs should be learning more about how SSDs affect SQL Server.
This article will help to get some basic information from your databases that may help you in different situations.
Join Neil Davidson, Joint CEO of Red Gate Software, for a meetup in San Francisco on Aug 25th. Come talk software, databases, and development with other like-minded people.
The purpose of this article is to demonstrate a custom scripting framework which enables the management of SQLServer databases from a Windows PowerShell session and also to extend Powershell’s flexibility by creating a set of commands customized to our needs.
This week Steve Jones reminds us that the basic skills we may take for granted might need some refreshing or updating.
Use Powershell and SMO to quickly and easily enable and configure database mail in nine steps.
How much do you need to sacrifice to succeed in business? It might be a lot, but Steve Jones says a lot of financial success is not worth losing your soul over.
The primary purpose of SQL Server 2008 Integration Services is to deliver extraction, transformation, and loading (ETL) functionality that supports core features of the SQL Server database management system. However, there are numerous scenarios where its role involves interaction with components that provide business intelligence-related features incorporated into the product.
By Steve Jones
Last week I was honored with a trip to Rome for the Redgate President’s...
By Arun Sirpal
As part of my wider work exploring Claude Code and AI-assisted database engineering, I...
By Bert Wagner
Train Wreck The last time I watched a high school band nearly fall apart mid-performance...
Comments posted to this topic are about the item Why Your Index Isn't Being...
Comments posted to this topic are about the item Distance Metric Algorithms
Comments posted to this topic are about the item What Can AI Really Do?
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers