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.
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Comments posted to this topic are about the item Liability for AI Errors
Hello , I would like to run a stored procedure on a secondary replica...
Comments posted to this topic are about the item Pro SQL Server Internals
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers