Tag Archives: sql server

Feedback and Big Data

How do we improve the way we do things? We measure them, observe, make a change based on our observation, measure again, and then repeat, looking to make our process, product, or idea better over time. We design our software … Continue reading

Posted in Editorial | Tagged | Comments Off on Feedback and Big Data

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

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 , , | Comments Off on Enabling Compression? Update your baseline

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 , , | Comments Off on Insert multiple rows from one INSERT statement