Tag: Microsoft SQL Server

Log Buffer #174: A Carnival of the Vanities for DBAs

Happy New Year to all our readers! Welcome to 2010 and the 174th edition of Log Buffer, the weekly review of database blogs.

Read More >

Log Buffer #173: A Carnival of Vanities for DBAs

Nicklas Westerlund has published the 173rd edition of Log Buffer, the weekly review of database blogs, on SELECT mysqlgenie FROM lamp;.

Read More >

Log Buffer #172: A Carnival of the Vanities for DBAs

One week and a whole lot of snow later, it is time for the 173rd edition of Log Buffer, the weekly review of database blogs. MySQL goes first this week.

Read More >

C.J. Date’s Seminar Not to Miss in January 2010

I’ve recently learned that Chris Date is giving a three days seminar. It must be one of the unique opportunities to learn from the world renown expert in relational database theory. The seminar title is “How to Write Correct SQL and Know It: A Relational Approach to SQL”. It’s focused on writing reliable SQL. While SQL has been designed as a simple access interface to relational data, it turned out to be quite complex and requires your to follow a certain disciplines to produce truly reliable SQL code — relational discipline.

Read More >

Log Buffer #171: A Carnival of the Vanities for DBAs

Hello, and welcome to the 171st edition of Log Buffer, the weekly review of database blogs. Let’s get it going this week with . . .

Read More >

OpenSQLCamp Videos online!

OpenSQLCamp was a huge success! I took videos of most of the sessions. The links to the videos are in this post. Enjoy!

Read More >

Check URL Status from SQL Server

One of our clients has a public web page and they needed to ensure that it is always up and accessible. Pythian already has a monitoring stack that includes website and pages monitoring. I wondered if this could be done from SQL Server using built-in Windows modules to access external web resources. There are various the methods we can use.

Read More >

Perl and Server Management Objects (SMO)?

I had an opportunity over the past few days to attempt to use Microsoft’s Server Management Objects (SMO) with Perl to manage a SQL Server 2005 DB. To make a long story into a short post, I blundered into the Win32::CLR module on CPAN, a little gem from Toshiyuki Yamato. Here is all you need to get started.

Read More >

Log Buffer #170: A Carnival of the Vanities for DBAs

This is the 170th edition of Log Buffer, the weekly review of database blogs. Welcome. Let’s kick off this week with a double-helping of . . .

Read More >

SQL Server: More light shed on “non-yielding scheduler” and Indexes stats

Here is a must-read whitepaper describing SQL Server Scheduling and how to interpret and diagnose Errors 17883, 17884, 17887, and 17888; please look here How To Diagnose and Correct Errors 17883, 17884, 17887, and 17888. We had a client having same issue. The client runs a busy online business with thousands of connected users; databases sometimes include more than half a million tables. We had a healthy counters and server didn’t seem to suffer from memory or I/O bottlenecks. We did suspect, that it is something to do with SQL Server internals, as we also received fatal exceptions pertaining to SPIDs <50 (system processes). If you face similar issues, you should install the latest service pack and cumulative update, and check if you have any resource bottlenecks. You can try trace T2330 as well, and if you still get errors or dumps, then you had better open a case with Microsoft Support to analyze the dumps and provide a resolution.

Read More >
Page 32 of 51« First Page...10...3031323334...40...Last Page »