Microsoft SQL Server

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

It feels like blogs appeared just yesterday. Over the years, they have proved to be of much value for the technical and not-so-technical masses. The big boom in this social media outlet has enabled an unprecedented sharing of ideas for database professionals. The nature of databases and blogging is to always change, but Log Buffers are here to stay.

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.

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