Monthly Archives: January 2012

Returning Results from an Insert – OUTPUT clause

Posted on January 30, 2012 by

I needed to return an identity value recently from an insert for use in another piece of code. For a client front end, you can easily encapsulate your insert in a stored procedure and then SELECT scope_identity() to get the … Continue reading →

Posted in Blog | Tagged , | 2 Comments

Should we outsource identity management

Posted on January 30, 2012 by

My Database Weekly editorial for Jan 30, 2012 One of the first things many people build when they’re developing an application these days on the web is a login/identity system for their users. This allows them to identify people, customize … Continue reading →

Posted in Editorial | Tagged , ,

Morale Data

Posted on January 30, 2012 by

Would you use this site to enter your morale at work? It’s an idea by a new company that should enable employees to enter information about how they feel at work, how their job is going, and other meta data that describes their attitude … Continue reading →

Posted in Editorial | Tagged

A Quick Export with SQL Packager

Posted on January 26, 2012 by

Disclosure: I work for Red Gate Software Someone asked me the other day if I’d ever used SQL Packager to export a table to send to another person. I hadn’t, and in fact hadn’t even ever run the tool, but … Continue reading →

Posted in Blog | Tagged , , | 7 Comments

Healthy Work Habits

Posted on January 26, 2012 by

Many of us work with computers extensively, day after day. It’s easy to fall into the habits of working in a particular way, and we’ve seen recommendations from health professionals about the dangers of our environment. I’ve written in the past … Continue reading →

Posted in Editorial | Tagged

Enabling Compression? Update your baseline

Posted on January 25, 2012 by

I wrote recently about capacity planning, with an item near the end about disk usage. Someone pointed out to me that compression can dramatically affect your baseline, and as you implement it, or de-implement it, you need to update your … Continue reading →

Posted in Blog | Tagged , ,

No Cloud for Stack Exchange

Posted on January 25, 2012 by

One very large and successful site in the technology world is the Stack Exchange collection of sites. They’ve grown and scales with relatively few people, and they have chosen to host thier own systems as opposed to moving to the … Continue reading →

Posted in Editorial | Tagged ,

The Avon Walk

Posted on January 24, 2012 by

It’s more often than not that I wake up, hoping that no new bad news comes my way. The short story is that my wife is going to do a 39mi walk this summer to raise money for cancer. If … Continue reading →

Posted in Blog | Tagged

Back to Vegas

Posted on January 24, 2012 by

I enjoy Las Vegas and am glad to be heading back to present at the Spring SQL Server Connections conference in March. If you wear a number of hats at your job, and deal with a variety of platforms in the Microsoft … Continue reading →

Posted in Editorial | Tagged ,

Insert multiple rows from one INSERT statement

Posted on January 23, 2012 by

One of the things that has been annoying for a long time in SQL Server is adding lots of data for testing. Personally I use Data Generator, and I recommend that, but for a quick few rows of data, do … Continue reading →

Posted in Blog | Tagged , ,