Helen Joyce Free utility for converting Backup tasks in Maintenance plans to use SQL Backup To cut down a potentially laborious task of converting backup tasks in several maintenance plans to use SQL Backup we... 09 November 2007 1 min read
Louis Davidson sys.dm_exec_xml_handles d Gives you information about any sessions that are using xml documents, including stats about the XML document and usage. ... 04 November 2007 3 min read
Nigel Morse Do you yield? Yay! I’ve actually used the C# yield statement for the first time. I’ve wanted to use it ever since I... 31 October 2007 4 min read
Tony Davis What are the most innovative .NET tools? We all have our favourite websites. Not the ones we read as part of our job, but the ones we... 31 October 2007 2 min read
Phil Factor On the trail with the Cowboy Coders. One of the signs of increasing age in the IT industry is that of ‘déjà vu’. New things that are... 24 October 2007 4 min read
Tim Ford Do I Ask Too Much of My Beloved RDBMS? OK Simple-Talkers I have a interesting situation driving be nuttier than squirrel poo. I have the following 2 steps in a... 16 October 2007 3 min read
Robert Chipperfield It’s a <strike>boy</strike> new version of SQL Data Compare! Well, after five months of design, development, testing, documentation, training, and countless other activities that I’ve almost certainly forgotten to... 08 October 2007 2 min read
András Belokosztolszki SQLBits in Reading and the British language SQLBits was held in Reading this Saturday and it certainly superseded my expectations. There were over 300 people, excellent talks... 08 October 2007 2 min read
Louis Davidson Normalization’s other little side effect… It isn’t that I don’t like a challenge, really it isn’t. I like puzzles, mazes, Suduko, video games with challenging... 07 October 2007 4 min read
Louis Davidson sys.dm_exec_sql_text (Edit: Was reading Adam’s book tonight and discovered you can pass a plan handle to this object. Very interesting!) This... 03 October 2007 3 min read
Robert Chipperfield The (slightly obscene) way to speed up loops Last night as I wandered around some sites on Java optimization, I came across an example of loop optimization that... 03 October 2007 3 min read
Brian Donahue Database backup: insufficient resources for cache withdrawal Sometimes SQL Server can pose conundrums of such complexity that even the Riddler couldn’t conceive of. In my mind’s eye, a... 30 September 2007 5 min read
Louis Davidson PASS Followup, Technical Edition I have already given a rundown of most everything PASS here on my personal blog, including a series of posts with... 25 September 2007 6 min read
András Belokosztolszki The GO command can have a parameter? I have mixed feelings about the GO command. It is not a T-SQL statement, it is just something that Management... 24 September 2007 2 min read
Tim Ford PASS Day 3: Hello Muddah, Hello Faddah Here it is, the last day of PASS 2007 and I find myself in a melancholy that comes with the... 23 September 2007 2 min read
Tim Ford PASS Day Two: You Can’t Get There From Here (A Geog-DUH-phy Lesson) Here it is day two and I am finally starting to get adjusted to the time difference. Wimp. Sure, I... 21 September 2007 3 min read
Richard Mitchell iPodtastic Just to let you know that we’re contacting the people who’ve helped out with the SQL Data Compare 6 Alpha... 21 September 2007 1 min read
Brian Donahue How to rewind a SQL Server I work for a company that sells software. And SOME people, because of their untrusing nature, need to be convinced... 20 September 2007 8 min read
Tim Ford It’s PASS 2007 Arg! Volunteer meetings, PASS business, PASS SIG Quizbowl, Welcome Reception, SQL Server Central Party and the subsequent after party and after-after party,... 19 September 2007 2 min read
Robert Chipperfield Can you Break The Code? Fancy winning some cool goodies? Red Gate has just launched its “Break The Code” prize draw, where you can win... 19 September 2007 1 min read
