Moving and Downsizing

Moving and Downsizing

must confess, 2005 was an odd year. Perhaps you remember a column a few months back, describing the wretched flight with four cats and an ill seatmate, moving the household from from the left coast to the right. One cross-country move in a lifetime should be enough for anyone; for us, however, two per this year seem to be required.

It’s awfully embarrassing when I run into friends, and they say “So, I hear you moved from California to Florida. How’s that working out for you?” (There’s often a slight hint of schadenfruede in the tone, as well?hurricanes have been in the news for the past two years.) The embarrassing part is when I respond with “Well, we did move to Florida, but it didn’t work out. We’re back in California again.”

It’s true?condo life wasn’t for me. Loved being on the beach. Loved having friends and business partners Andy Baron and Mary Chipman 200 yards away. Didn’t so much love the neighbors who arrived six months into the experience. They turned out to be lovely people, but they were accustomed to living in much larger quarters. Their 6000 sq ft house had been devastated by a hurricane, and they decided to relocate and downsize, somewhat begrudgingly, into a condo on the beach (go figure). We survived door slamming, yelling and histrionics at 2AM, laundry being done loudly at 4AM, and more door slamming all day and night. The building shook at the whim of the neighbor’s comings and goings. Being inherently quiet and private folks, this didn’t sit well on our side of the paper-thin walls. Nerves jangling, we discussed it with the offenders, who promised to try to be better. Two weeks later, with no real improvement in sight, we looked at each other, and confessed simultaneously: “We have to move.”

As you may remember, I requested suggestions on great places to live in this spot four months ago. I did get some very sincere responses, and for those, I am grateful. Luckily, the neighbors in Florida had been lusting after our real estate, wanting to expand into our square footage, and were willing to pay full price to get the space. We were willing to take full price to get the quiet. The fortuitous deal executed, we again fled across the country. (For those who have the slightest interest, we transported the animals this time by flying twice, taking two at a time. I’m guessing no one really has that interest, so we’ll just move on.)

And where did we end up? NoCal, thanks. Out in the woods. No beach, but lots of deer, wild turkeys, and much flora and fauna. Some snow, but not much. Friendly neighbors, far enough away that we don’t see or hear them, but close enough for help in an emergency. So far, it’s a winner. Hopefully, there’s only one more move in the works, and I won’t notice that one.

Of course, when one moves across the country, and has to pay movers out of ones’ own pockets, one makes the effort to downsize so as to avoid paying to move any extraneous belongings. We downsized seriously before the first move, giving away tools, gardening supplies, furniture, and more, to friends and relatives. The friends to whom we gave most of the stuff ended up being the ones that suggested we move to the new community, where they also settled. Donated stuff keeps flowing back in our direction from Doug and Diane, tipping the scales closer to their original balance. Every week, something new appears in the garage that we haven’t seen for a year. It’s like Christmas, all the time!

Speaking of downsizing (finally, the real content), I’ve been spending some time working with and demonstrating ASP.NET 2.0’s membership functionality. I love how simple they’ve made it to manage users and roles, storing data in a local SQL Express database named ASPNETDB.MDF. I also need to distribute and deploy these demo applications, often to attendees at classes or conferences.

Here’s the problem: By default, ASPNETDB.MDF is 10MB in size. Yikes. That’s a lot of “air” to be transporting, when you’ve only added three users to the system. There may be some global setting that controls the default size of this database, but it’s too large for my needs, for sure.

Using SQL Server 2005, I could certainly shrink the database?the Management Studio includes a right-click interface to do this. I could also use the DBCC ShrinkFile statement to do the work, but it’s not quite that easy. The documentation doesn’t explain how to shrink the contents of a free-standing MDF file, and all the attempts I made simply did nothing at all.

Finally, I called in my partner, Brian Randell. He’s spent a lot more time with SQL Server 2005 than I have, and he, too, was at first stumped. With a little research, he came up with a solution that works quite nicely, and he has posted a blog entry about the answer. In his code, he creates a temporary database, attaches the MDF file to the new database, and calls the DBCC ShrinkFile statement. Finally, he detaches the temporary database, as shown below:

   SET NOCOUNT ON;   GO   USE MASTER;   GO   CREATE DATABASE SHRINK_ASPNETDB      ON (FILENAME = 'C:PathAPP_DATAASPNETDB.MDF'),       (FILENAME = 'C:PathAPP_DATAaspnetdb_log.ldf')       FOR ATTACH;   GO   USE SHRINK_ASPNETDB;   GO   DECLARE @FileName nvarchar(100);   SELECT @FileName = FILE_NAME(1);   DBCC SHRINKFILE (@FileName, 1);   GO   USE MASTER;   GO   sp_detach_db SHRINK_ASPNETDB;   GO

You will, of course, need to change the paths to the database and log file to match your own situation. From the Windows command prompt, you can run the sqlcmd utility, like this (assuming that you’ve named the script shrink.sql):

   sqlcmd -E -S .SQLExpress -i Shrink.sql

Brian’s tip will certainly save me a lot of time and effort, no longer requiring me to cart around huge empty databases (see more of Brian’s blog).

For now, I’ve downsized and moved enough. I saw a movie recently in which a character was packing to move, and I actually found myself getting nauseous. I’m here to stay for now?you’re bored hearing about the moves, and goodness knows, I’m tired of participating. Thanks to Brian, at least, we’ve found an easier way to move ASP.NET’s membership database around.

devx-admin

devx-admin

Share the Post:
USA Companies

Top Software Development Companies in USA

Navigating the tech landscape to find the right partner is crucial yet challenging. This article offers a comparative glimpse into the top software development companies

Software Development

Top Software Development Companies

Looking for the best in software development? Our list of Top Software Development Companies is your gateway to finding the right tech partner. Dive in

India Web Development

Top Web Development Companies in India

In the digital race, the right web development partner is your winning edge. Dive into our curated list of top web development companies in India,

USA Web Development

Top Web Development Companies in USA

Looking for the best web development companies in the USA? We’ve got you covered! Check out our top 10 picks to find the right partner

Clean Energy Adoption

Inside Michigan’s Clean Energy Revolution

Democratic state legislators in Michigan continue to discuss and debate clean energy legislation in the hopes of establishing a comprehensive clean energy strategy for the

Chips Act Revolution

European Chips Act: What is it?

In response to the intensifying worldwide technology competition, Europe has unveiled the long-awaited European Chips Act. This daring legislative proposal aims to fortify Europe’s semiconductor

USA Companies

Top Software Development Companies in USA

Navigating the tech landscape to find the right partner is crucial yet challenging. This article offers a comparative glimpse into the top software development companies in the USA. Through a

Software Development

Top Software Development Companies

Looking for the best in software development? Our list of Top Software Development Companies is your gateway to finding the right tech partner. Dive in and explore the leaders in

India Web Development

Top Web Development Companies in India

In the digital race, the right web development partner is your winning edge. Dive into our curated list of top web development companies in India, and kickstart your journey to

USA Web Development

Top Web Development Companies in USA

Looking for the best web development companies in the USA? We’ve got you covered! Check out our top 10 picks to find the right partner for your online project. Your

Clean Energy Adoption

Inside Michigan’s Clean Energy Revolution

Democratic state legislators in Michigan continue to discuss and debate clean energy legislation in the hopes of establishing a comprehensive clean energy strategy for the state. A Senate committee meeting

Chips Act Revolution

European Chips Act: What is it?

In response to the intensifying worldwide technology competition, Europe has unveiled the long-awaited European Chips Act. This daring legislative proposal aims to fortify Europe’s semiconductor supply chain and enhance its

Revolutionized Low-Code

You Should Use Low-Code Platforms for Apps

As the demand for rapid software development increases, low-code platforms have emerged as a popular choice among developers for their ability to build applications with minimal coding. These platforms not

Cybersecurity Strategy

Five Powerful Strategies to Bolster Your Cybersecurity

In today’s increasingly digital landscape, businesses of all sizes must prioritize cyber security measures to defend against potential dangers. Cyber security professionals suggest five simple technological strategies to help companies

Global Layoffs

Tech Layoffs Are Getting Worse Globally

Since the start of 2023, the global technology sector has experienced a significant rise in layoffs, with over 236,000 workers being let go by 1,019 tech firms, as per data

Huawei Electric Dazzle

Huawei Dazzles with Electric Vehicles and Wireless Earbuds

During a prominent unveiling event, Huawei, the Chinese telecommunications powerhouse, kept quiet about its enigmatic new 5G phone and alleged cutting-edge chip development. Instead, Huawei astounded the audience by presenting

Cybersecurity Banking Revolution

Digital Banking Needs Cybersecurity

The banking, financial, and insurance (BFSI) sectors are pioneers in digital transformation, using web applications and application programming interfaces (APIs) to provide seamless services to customers around the world. Rising

FinTech Leadership

Terry Clune’s Fintech Empire

Over the past 30 years, Terry Clune has built a remarkable business empire, with CluneTech at the helm. The CEO and Founder has successfully created eight fintech firms, attracting renowned

The Role Of AI Within A Web Design Agency?

In the digital age, the role of Artificial Intelligence (AI) in web design is rapidly evolving, transitioning from a futuristic concept to practical tools used in design, coding, content writing

Generative AI Revolution

Is Generative AI the Next Internet?

The increasing demand for Generative AI models has led to a surge in its adoption across diverse sectors, with healthcare, automotive, and financial services being among the top beneficiaries. These

Microsoft Laptop

The New Surface Laptop Studio 2 Is Nuts

The Surface Laptop Studio 2 is a dynamic and robust all-in-one laptop designed for creators and professionals alike. It features a 14.4″ touchscreen and a cutting-edge design that is over

5G Innovations

GPU-Accelerated 5G in Japan

NTT DOCOMO, a global telecommunications giant, is set to break new ground in the industry as it prepares to launch a GPU-accelerated 5G network in Japan. This innovative approach will

AI Ethics

AI Journalism: Balancing Integrity and Innovation

An op-ed, produced using Microsoft’s Bing Chat AI software, recently appeared in the St. Louis Post-Dispatch, discussing the potential concerns surrounding the employment of artificial intelligence (AI) in journalism. These

Savings Extravaganza

Big Deal Days Extravaganza

The highly awaited Big Deal Days event for October 2023 is nearly here, scheduled for the 10th and 11th. Similar to the previous year, this autumn sale has already created

Cisco Splunk Deal

Cisco Splunk Deal Sparks Tech Acquisition Frenzy

Cisco’s recent massive purchase of Splunk, an AI-powered cybersecurity firm, for $28 billion signals a potential boost in tech deals after a year of subdued mergers and acquisitions in the

Iran Drone Expansion

Iran’s Jet-Propelled Drone Reshapes Power Balance

Iran has recently unveiled a jet-propelled variant of its Shahed series drone, marking a significant advancement in the nation’s drone technology. The new drone is poised to reshape the regional

Solar Geoengineering

Did the Overshoot Commission Shoot Down Geoengineering?

The Overshoot Commission has recently released a comprehensive report that discusses the controversial topic of Solar Geoengineering, also known as Solar Radiation Modification (SRM). The Commission’s primary objective is to

Remote Learning

Revolutionizing Remote Learning for Success

School districts are preparing to reveal a substantial technological upgrade designed to significantly improve remote learning experiences for both educators and students amid the ongoing pandemic. This major investment, which

Revolutionary SABERS Transforming

SABERS Batteries Transforming Industries

Scientists John Connell and Yi Lin from NASA’s Solid-state Architecture Batteries for Enhanced Rechargeability and Safety (SABERS) project are working on experimental solid-state battery packs that could dramatically change the

Build a Website

How Much Does It Cost to Build a Website?

Are you wondering how much it costs to build a website? The approximated cost is based on several factors, including which add-ons and platforms you choose. For example, a self-hosted