Monthly Archives: January 2012

Returning Results from an Insert – OUTPUT clause

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

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

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

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

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

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

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

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

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

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 , ,