Tag: Microsoft SQL Server

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

Simple messages are the most powerful. Keep it simple is the advice given by top technologists. One reason why blogs are extremely popular is their simplicity. This simplicity comes from the shortness and focus of the message of the blog. This Log Buffer Edition collects some simple yet powerful blog posts for you in Log Buffer #248.

Read More >

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

Thanksgiving is here and the circular chain of thankfulness is going on. Clients are thankful that they have applications, applications are thankful to their databases, database are thankful to their DBAs, and DBAs are thankful to clients. And they all are thankful that there is weekly Log Buffer Edition, of which the latest is Log Buffer #247. :)

Read More >

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

Administrators across the database technologies find themselves at the center stage of that and they are sharing tips and tricks regarding that in their blogs. This Log Buffer Edition touches that and much more in Log Buffer #246.

Read More >

SQL server: Denali now tunes out of the plan cache

If you ever used SQL server Database Engine Tuning Advisor then you know you have few options as a source of analysis workload, here they are.

Read More >

SQL server: Create missing indexes with unmessing names

If you do any performance tuning , and everyone does, then you’ll come to a point where you want to know if your tables have sufficient indexes to serve the queries fast, here’s how.

Read More >

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

Getting stuck on technical problems is a norm in the life of any IT professional and DBAs are no exception. With evolving databases and their streaming new features make it more challenging. Blogs often provide the Eureka moment for those problems. So sit back and enjoy this Log Buffer Edition, which is Log Buffer #245.

Read More >

In ‘Movember’, Mo Bros stand together to fight Prostate Cancer

The 60s are NOT back but during the month of November , some gents , including myself, will grow a stache to raise the awareness of prostate cancer, an insidious disease that afflicts one in seven males.

Read More >

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

Managing the databases of any kind of any size in the production environment requires the administrators to remain up to date and on the toes every time. They need to learn fast and apply their knowledge fast. Keeping abreast of the newer features and the troubleshooting techniques is must for them and this Log Buffer Edition helps easing that task. Enjoy the Log Buffer #244.

Read More >

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

From Percona Live, London to TechEd Australia to Oracle Open World USA, the blogosphere of Oracle, MySQL, SQL Server and the related technologies is bustling with the eye witness accounts of these conferences, technical overviews, observations, predictions, and much more. This Log Buffer Edition covers all that and as usual more in Log Buffer #243.

Read More >

SQL server:opening errorlog:Failed to retrieve data for this request

After an in place upgrade of SQL server 2005 to SQL server 2008 R2 , I tried to open SQL errorlog from Management> SQL server logs but I got the following error. Here’s how I fixed it.

Read More >
Page 23 of 50« First Page...10...2122232425...30...Last Page »