Microsoft SQL Server

Log Buffer #266, A Carnival of the Vanities for DBAs

The purpose of technology is to make life easier and more quality-oriented. It is this virtue of technology that makes it evergreen and sustainable. Its unique feature is its innovative nature. Technology blogging is a way for the technologists to rant about technology and throw light at known and unknown corners with new angles. This Log Buffer Edition covers those angles and more. Enjoy!

Log Buffer #265, A Carnival of the Vanities for DBAs

The weather is changing, clocks are being adjusted, and the changes at the technological front are as usual rapid, frequent, and over-whelming. Keeping up with such rapid-fire changes is a project in itself. In the database triangle of Oracle, SQL Server, and MySQL, patches, updates, features, tricks, and tips are booming, and so is this Log Buffer Edition.

T-SQL:Generate statements to add TEMPDB datafiles

TEMPDB, is one of SQL server hot-debated topics; there’s always something to say about its sizing, file placement or datafiles count in Multi-core instances. This is simply because TEMPDB is a global resource that’s heavily used and very critical asset in a busy instance; this makes any advice against TEMPDB fall in the “It depends” category.

Log Buffer #262, A Carnival of the Vanities for DBAs

This week is packed with conference news, birthdays, tutorials, awards, and much more. From Pythian proud recipient of HIO Employer Excellence Award to the health checks of SQL Server, and from hints in stored outlines to the birthday of Paul Vallee, this Log Buffer Edition has it all in Log Buffer #262.

Moving MSDB to a New Location

In recent past we had a situation where in, we were required to move MSDB, Model and Master databases to a new location, the reason being a faulty drive. While moving the system databases to the new location we needed to be extra cautious. Let’s see the process step-by-step.

Why Would I Upgrade to SQL Server 2012?

The process of upgrading SQL Server is usually time consuming, costs money and requires availability of human resources. If you don’t see the immediate need…Why bother?! Before deciding on upgrading, you should be aware of the new features and make sure you will really benefit by the upgrade. From our experience at Pythian with dozens of clients and hundreds of environments, what could be worth upgrading to SQL Server 2012?
Here are some of the top features related to the database engine (Part I):

Page 18 of 50« First...10...1617181920...304050...Last »