Posts Categorized: SQL Server
Welcome to the 90th edition of Log Buffer, the weekly review of database blogs.
After spending a long time on a project for a client that does a huge amount of data movement using SELECT INTO, I posted a Connect item asking for an enhancement where a minimally-logged insert would be available from a SELECT doing an INSERT into an existing table. One day the item was updated with a comment: “This is targetted to be available in SQL Server 2008.” I wasn’t sure exactly what this meant until the last few days, when Sunil Agarwal posted a series of three posts describing the enhancements to minimal logging in SQL Server 2008 — including the ability to do a minimally logged insert via a SELECT, to an existing table!
Recently I encountered a SQL Server 2005 Replication setup where an error message was appearing about every 5 minutes in the SQL Server error logs. The error message was coming from the failing distribution cleanup job. Examining the job history I was able to determine the real error message. The first step in debugging was to confirm if xp_cmdshell was enabled….
Welcome to the 89th edition of Log Buffer, the weekly review of database blogs.
I would not wish this task on my worst enemy. My friend, good luck and best wishes but I’m afraid I just can’t help you, because that much suffering is way too much for me.
As of this month, Adam Machanic has been hired to lead Pythian’s global SQL Server practice and will be working out of our office in Central Square in Boston, Massachussets. Adam is in my opinion as close as it comes to a resource in the Microsoft SQL Server space that has the personality, track record and respect that Tom Kyte has in the Oracle space.
Welcome to the 88th edition of Log Buffer, the weekly review of database blogs.
Welcome the the 87th of Log Buffer, the weekly review of database blogs.
Courtesy of our friends at Oracle cost containment company Miro Consulting, I am giving a webinar tomorrow at 1pm EST (click this link for the time in other timezones please. The subject I’ve chosen is how to apply the best practices around advanced supply management that are extremely successful and mature in the product supply chain world to the equally extremely immature practices we typically find in enterprise IT supply provisioning. It should be a great presentation; I give an overview of the famous “Toyota Way” and cover some recent findings from the California Management Review as well. Keep reading for a full overview.
Welcome to the 86th edition of Log Buffer, the weekly review of database blogs. Let’s jump right in.