Tag: Microsoft SQL Server

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

Welcome, everyone, to the 177th edition of Log Buffer, the weekly review of database blogs. It was another week heavy with technical posts, so let’s waste no time, and get it all started with . . .

Read More >

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

This is the 176th edition of Log Buffer, the weekly review of database blogs.

Read More >

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

Welcome to the 175th edition of Log Buffer, the weekly review of database blogs.

Read More >

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 >

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 >
Page 33 of 51« First Page...10...3132333435...40...Last Page »