12/13/09

Thin Crust Pizza

Thin Crust Pizza
Click on Image for Larger View

Thin-Crust Pizza



For many years I have been trying to learn the secrets of making a good thin-crust pizza. I've had this type of pie at various pizza parlors such as Shakey's Pizza Restaurant, Pizza Inn, Pizza Hut, and the Village Inn Pizza Parlor. I have been told that this type of pizza is officially known as an "Original California-Style" pizza and is also found at such restaurants as Straw Hat and Round Table. To quote the folks at Straw Hat, "California crust is special, it's a layered, flaky crust. It's airy and crispy on the bottom, yet bubbling on top. It has a cracker-like crunch, and is never soggy or limp." Click here to see what I mean.

Here are some of the secrets that I have learned so far:

  • The whole concept of the thin crust is more than just the flour or dough recipe, it is the method of sheeting the dough into the pizza pan. Most restaurants employ the use of a special machine known as a dough sheeter (or roller) which rolls out the dough quickly and evenly. They typically run the dough through the sheeter about 5 or 6 times, dusting the dough with flour each time, to get it down to the paper-thin thickness. The function of the dusting flour is to actually incorporate more flour into the dough during the sheeting process. The dough is typically short a little flour in the mixing process so that it will sheet easier, so the dough reaches its final flour content during the dusting and sheeting process.


Acme Dough Roller

  • Thin-crust pizza dough is somewhat dry and dense after sheeting. You will need to dust the dough with flour several times as you roll it out in order to incorporate more flour into the recipe. This also helps ensure that the dough will not stick to the countertop and your rolling pin.

  • It is important that you use flour with a high gluten content (12% protein or higher) in order to make the crust crispy. The King Arthur Flour Company manufactures a high-gluten flour that contains 14% protein which is excellent for this recipe (see their "Sir Lancelot" brand). If you don't have Sir Lancelot handy then use a quality bread flour that contains at least 12% protein. Do not use all-purpose flour.

  • Retard dough a full day (24-hours) in the refrigerator (38 °F to 40 °F). This allows the yeast to work long and hard which develops the dough's characteristic texture and, more importantly, its unique flavor. Allow dough to warm to room temperature for about an hour or two before rolling out and docking.


Dough docker

  • The dough must be docked after being sheeted and placed in pan. Docking prevents large air bubbles from forming in the crust. If you do not own a dough docker, you can use a fork to prick the dough thoroughly.

  • Optional: Pre-cook the crust for 4 minutes before adding the sauce and toppings. This allows the crust to become more crisp before weighing it down with toppings.

I have worked long and hard developing this recipe and it is by no means perfect. I have eaten more test-pizzas than I care to admit. I hope you enjoy the fruits of my labor and I hope that you share your pizza making experiences with me. Good luck!



Dough Recipe

1 pound (or about 3 1/2 cups) high gluten flour
3/4 cup warm water
1 tablespoon vegetable oil
1 1/2 teaspoon active dry yeast
1 1/2 teaspoon sugar
1 teaspoon salt



In a heavy-duty stand mixer (e.g., KitchenAid) fitted with dough hook, add the water, oil, yeast, salt, and sugar. Mix thoroughly until yeast has fully dissolved. Add flour and mix on low speed until all of the flour and water have mixed and a stiff dough ball forms, about 3 to 4 minutes. Stop mixing as soon as the dough ball forms as this type of dough should not be kneaded.

Place the dough ball into a large bowl and cover tightly with plastic wrap. Let the dough rise for 24 hours in the refrigerator before using. Please note that I cannot over-emphasize the importance of a 24-hour rising time since it is absolutely essential for the dough to develop its signature texture and, more importantly, its unique flavor! Do not skip this step!



Thin-Crust Pizza Sauce

28 oz. can whole peeled tomatoes in heavy puree (RedPack brand preferred)
1 tablespoon fresh green bell pepper, finely chopped
1 teaspoon fresh yellow onion, finely chopped
1 clove fresh garlic, minced
1 teaspoon dried thyme
1/2 teaspoon dried oregano
1/2 teaspoon salt (or to taste)



Place all ingredients in a blender and puree until smooth. Pour into a saucepan and simmer over low heat for 20 minutes (do not allow the sauce to boil). Allow to cool to room temperature before using.

Preheat your oven to 500 °F about one hour before you plan to bake the pizza.

Turn the dough out onto a large surface and dust with flour. Using a heavy rolling pin (or dough sheeter), roll the dough out very thin to form a 24-inch or larger circle. If you're using a cutter pizza pan (recommended), dust the pan lightly with flour, place the dough in the pan and dock. Use the rolling pin to trim off the excess dough drooping over the sides of the pan. If you wish to cook the pizza directly on a pizza stone (not using a pan), then place the dough on a dusted pizza-peel, dock, and fold the edge over 1-inch all the way around and pinch it up to form a raised lip or rim.


Photo courtesy of pizzatools.com

Optionally, pre-cook the crust for 4 minutes before adding any sauce or toppings. Remove the crust from the oven and pop any large air pockets that may have formed. Add the sauce, shredded mozzarella cheese, and your favorite toppings. Continue baking, on the lowest oven rack, rotating the pan half way through so that it cooks evenly, until crust is sufficiently browned and crisp, about 10 to 15 minutes. Remove the pizza from the oven and slide pizza out of cooking pan onto a large wire cooling rack or cutting board. Allow to cool for 5 minutes before transferring to a serving pan. This step allows the crust to stay crisp while it cools, otherwise the trapped steam will soften the crust.

Once cool, use a pizza cutter to slice the pie into pieces and enjoy! Please share your results with me!

12/10/09

Vista and Buffalo Terastation (and Windows 7)

Just a note in case anyone else runs into this problem. If you want to connect to a share on a Buffalo Terastation (which seems to be using Samba) from a Windows Vista installation, you need to do the following:
  • Run the Local Security Policy app - secpol.msc
  • Go to Local Policies Security Options and choose the "Network Security: LAN Manager Authentican Level" item
  • Set it to "Send LM & NLTM, use NTMLv2 session if negotiated"
And that should sort you out. [Update] For those of us unlucky enough to be running Vista Home (which doesn't come with secpol), you can do the following (thanks to Patrick in the comments for this)
  • Run regedit (Windows-R, 'regedit') to open the registry editor
  • Find key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\
  • Change the value for the option "LMCompatibilityLevel" from 3 to 1.
Now you should be able to access the TeraStation (you may need to reboot)

[Update 25th August 2009]. A couple of commenters have been kind enough to say that this also works in Windows 7 RC and thus in Windows 7 RTM (pretty safe assumption). For what it's worth, I have a Windows 7 RC virtual machine running and I've been able to connect fine without needing to make any changes that I can remember.

12/7/09

Ipod files to computer

Site which helps transfer files from ipod back to computer.
http://download.cnet.com/Music-Rescue/3000-2169_4-10257368.html

11/22/09

Peter Reinhart's Napoletana Pizza Dough Recipe

4 1/2 cups (20.25 ounces) unbleached high-gluten, bread, or all-purpose flour, chilled
1 3/4 (.44 ounce) teaspoons salt
1 teaspoon (.11 ounce) instant yeast
1/4 cup (2 ounces) olive oil (optional)
1 3/4 cups (14 ounces) water, ice cold (40°F)
Semolina flour OR cornmeal for dusting

1. Stir together the flour, salt, and instant yeast in a 4-quart bowl (or in the bowl of an electric mixer). With a large metal spoon, stir in the oil and the cold water until the flour is all absorbed (or mix on low speed with the paddle attachment), If you are mixing by hand, repeatedly dip one of your hands or the metal spoon into cold water and use it, much like a dough hook, to work the dough vigorously into a smooth mass while rotating the bowl in a circular motion with the other hand. Reverse the circular motion a few times to develop the gluten further. Do this for 5 to 7 minutes, or until the dough is smooth and the ingredients are evenly distributed. If you are using an electric mixer, switch to the dough hook and mix on medium speed for 5 to 7 minutes, or as long as it takes to create a smooth, sticky dough. The dough should clear the sides of the bowl but stick to the bottom of the bowl. If the dough is too wet and doesn't come off the sides of the bowl, sprinkle in some more flour just until it clears the sides. If it clears the bottom of the bowl, dribble in a tea- spoon or two of cold water. The finished dough will be springy, elastic, and sticky, not just tacky, and register 50 to 55F.

2. Sprinkle flour on the counter and transfer the dough to the counter. Prepare a sheet pan by lining it with baking parchment and misting the parchment with spray oil (or lightly oil the parchment). Using a metal dough scraper, cut the dough into 6 equal pieces (or larger if you are comfortable shaping large pizzas), You can dip the scraper into the water between cuts to keep the dough from sticking to it, Sprinkle flour over the dough. Make sure your hands are dry and then flour them. Lift each piece and gently round it into a ball. If the dough sticks to your hands, dip your hands into the flour again. Transfer the dough balls to the sheet pan, Mist the dough generously with spray oil and slip the pan into a food-grade plastic bag.

3. Put the pan into the refrigerator overnight to rest the dough, or keep for up to 3 days. (Note: If you want to save some of the dough for future baking, you can store the dough balls in a zippered freezer bag. Dip each dough ball into a bowl that has a few tablespoons of oil in it, rolling the dough in the oil, and then put each ball into a separate bag. You can place the bags into the freezer for up to 3 months. Transfer them to the refrigerator the day before you plan to make pizza.)

4. On the day you plan to make the pizza, remove the desired number of dough balls from the refrigerator 2 hours before making the pizza. Before letting the dough rest at room temperature for 2 hours, dust the counter with flour, and then mist the counter with spray oil. Place the dough balls on top of the floured counter and sprinkle them with flour; dust your hands with flour. Gently press the dough into flat disks about 1/2 inch thick and 5 inches in diameter. Sprinkle the dough with flour, mist it again with spray oil, and cover the dough loosely with plastic wrap or a food-grade plastic bag. Now let rest for 2 hours.

5. At least 45 minutes before making the pizza, place a baking stone either on the floor of the oven (for gas ovens), or on a rack in the lower third of the oven. Heat the oven as hot as possible, up to 800F (most home ovens will go only to 500 to 550F, but some will go higher). If you do not have a baking stone, you can use the back of a sheet pan, but do not preheat the pan.

6. Generously dust a peel or the back of a sheet pan with semolina flour or cornmeal. Make the pizzas one at a time. Dip your hands, including the backs of your hands and knuckles, in flour and lift I piece of dough by getting under it with a pastry scraper. Very gently lay the dough across your fists and carefully stretch it by bouncing the dough in a circular motion on your hands, carefully giving it a little stretch with each bounce. If it begins to stick to your hands, lay it down on the floured counter and reflour your hands, then continue shaping it. Once the dough has expanded outward, move to a full toss as shown on page 208. If you have trouble tossing the dough, or if the dough keeps springing back, let it rest for 5 to 20 minutes so the gluten can relax, and try again. You can also resort to using a rolling pin, though this isn't as effective as the toss method.

7. When the dough is stretched out to your satisfaction (about 9 to 12 inches in diameter for a 6-ounce piece of dough), lay it on the peel or pan, making sure there is enough semolina flour or cornmeal to allow it to slide. Lightly top it with sauce and then with your other top- pings, remembering that the best pizzas are topped with a less-is-more philosophy. The American "kitchen sink" approach is counterproductive, as it makes the crust more difficult to bake. A few, usually no more than 3 or 4 toppings, including sauce and cheese is sufficient.

8. Slide the topped pizza onto the stone (or bake directly on the sheet pan) and close the door. Wait 2 minutes, then take a peek. If it needs to be rotated 180 degrees for even baking, do so. The pizza should take about 5 to 8 minutes to bake. If the top gets done before the bottom, you will need to move the stone to a lower self before the next round. if the bottom crisps before the cheese caramelizes, then you will need to raise the stone for subsequent bakes.

9. Remove the pizza from the oven and transfer to a cutting board. Wait 3 to 5 minutes before slicing and serving, to allow the cheese to set slightly.

Makes six 6-ounce pizza crusts.

11/1/09

The Bumper List of Windows 7 Secrets

It’s great to see Windows 7 Beta finally released to the world! We're very proud of what has been accomplished over the last months; in many ways, it sets a new quality bar for a beta operating system release. Building on top of the Windows Vista foundation, Windows 7 adds a great deal of polish and refinement to both the user interface and the underlying architecture, while at the same time introducing many new features and improvements that support new hardware, give power users and casual users alike better tools to manage their digital lives, and enable new classes of application experience.

Over future blog entries, I’ll spend time drilling into some of those areas in more detail; of course, there are plenty of articles already out there that dissect Windows 7 in some depth, with the Windows SuperSite and Ars Technica providing notably comprehensive entries. I’d also like to draw particular attention to the series of Windows 7 interviews that Yochay Kiriaty has been posting on Channel 9, which give the inside scoop on the development of many of the most significant new features.

For now, though, I want to focus in on some of “secrets” of Windows 7: the many little tweaks and enhancements that we’ve made in this release that I’ve discovered and collated over the last few months of using Windows 7 across my home and work machines. These are the things that are too small to appear in any marketing document as “features”, but that you quickly miss when you switch to an older version of Windows. There are some who think that we’re arbitrarily hiding functionality to make Windows easy for casual users, but I’d argue that a great deal of effort has been put into this release to satisfy power users. In homage to those of us who enjoy discovering the nooks and crannies of a new operating system list, I’ve put together the longest blog post that I’ve ever written. If you’ve downloaded and installed Windows 7 Beta recently, I think you’ll enjoy this list of my thirty favorite secrets. Have fun!

  1. Windows Management. By now, you’ve probably seen that Windows 7 does a lot to make window management easier: you can “dock” a window to the left or right half of the screen by simply dragging it to the edge; similarly, you can drag the window to the top of the screen to maximize it, and double-click the window top / bottom border to maximize it vertically with the same horizontal width. What you might not know is that all these actions are also available with keyboard shortcuts:
    • Win+Left Arrow and Win+Right Arrow dock;
    • Win+Up Arrow and Win+Down Arrow maximizes and restores / minimizes;
    • Win+Shift+Up Arrow and Win+Shift+Down Arrow maximizes and restores the vertical size.

    This side-by-side docking feature is particularly invaluable on widescreen monitors – it makes the old Windows way of shift-clicking on two items in the taskbar and then using the context menu to arrange them feel really painful.

  2. Display Projection. Had enough of messing around with weird and wonderful OEM display driver utilities to get your notebook display onto an external projector? In that case, you’ll be pleased to know that projection is really quick and simple with Windows 7. Just hit Win+P, and you’ll be rewarded by the following pop-up window:
    The Win+P Projector Settings window allows you to quickly switch display settings.
    Use the arrow keys (or keep hitting Win+P) to switch to “clone”, “extend” or “external only” display settings. You can also access the application as displayswitch.exe.

    If you want broader control over presentation settings, you can also press Win+X to open the Windows Mobility Center, which allows you to turn on a presentation “mode” that switches IM clients to do not disturb, disables screensavers, sets a neutral wallpaper etc. (Note that this feature is also available in Windows Vista.)
  3. Cut Out The Clutter. Working on a document in a window and want to get rid of all the extraneous background noise? Simply hit Win+Home to minimize all the non-active background windows, keeping the window you’re using in its current position. When you’re ready, simply press Win+Home again to restore the background windows to their original locations.
  4. Multi-Monitor Windows Management. The earlier tip on window management showed how you can dock windows within a monitor. One refinement of those shortcuts is that you can use Win+Shift+Left Arrow and Win+Shift+Right Arrow to move windows from one monitor to another – keeping them in the same relative location to the monitor’s top-left origin.
  5. Command Junkies Only. One of the most popular power toys in Windows XP was “Open Command Prompt Here”, which enabled you to use the graphical shell to browse around the file system and then use the context menu to open a command prompt at the current working directory. In Windows 7 (and in Windows Vista, incidentally – although not many folk knew about it), you can simply hold the Shift key down while selecting the context menu to get exactly the same effect. If the current working directory is a network location, it will automatically map a drive letter for you.
  6. It’s a Global Village. If you’ve tried to change your desktop wallpaper, you’ve probably noticed that there’s a set of wallpapers there that match the locale you selected when you installed Windows. (If you picked US, you’ll see beautiful views of Crater Lake in Oregon, the Arches National Park, a beach in Hawai’i, etc.) In fact, there are several sets of themed wallpapers installed based on the language you choose, but the others are in a hidden directory. If you’re feeling in an international mood, simply browse to C:\Windows\Globalization\MCT and you’ll see a series of pictures under the Wallpaper directory for each country. Just double-click on the theme file in the Theme directory to display a rotation through all the pictures for that country. (Note that some countries contain a generic set of placeholder art for now.)
  7. The Black Box Recorder. Every developer wishes there was a way that an end-users could quickly and simply record a repro for the problem that they’re running into that is unique to their machine. Windows 7 comes to the rescue! Part of the in-built diagnostic tools that we use internally to send feedback on the product, the Problem Steps Recorder provides a simple screen capture tool that enables you to record a series of actions. Once you hit “record”, it tracks your mouse and keyboard and captures screenshots with any comments you choose to associate alongside them. Once you stop recording, it saves the whole thing to a ZIP file, containing an HTML-based “slide show” of the steps. It’s a really neat little tool and I can’t wait for it to become ubiquitous on every desktop! The program is called psr.exe; you can also search for it from Control Panel under “Record steps to reproduce a problem”.
    The Problem Steps Recorder provides an easy way for users to record a problem repro for later diagnosis.
  8. The Font of All Knowledge. Long Zheng will be happy: we’ve got rid of the Add Fonts dialog that has served Windows faithfully for the last twenty years. (Of course, for most of that time, it’s been deprecated – the easy way to install a set of fonts has simply been to drag them into the Fonts folder via Control Panel.) But now font installation is really easy – we’ve added an “Install” button to the font viewer applet that takes care of the installation process:
    You can install a font in Windows 7 from the standard font viewer dialog.
    There are lots of other new features built into Windows 7 that will satisfy those of a typographic bent, incidentally – grouping multiple weights together, the ability to hide fonts based on regional settings, a new text rendering engine built into the DirectWrite API, and support in the Font common file dialog for more than the four “standard” weights. For example:
    The new common font dialog in Windows 7 supports more than four weights for a font.
  9. Gabriola. As well as the other typographic features mentioned above, Windows 7 includes Gabriola, an elaborate display type from the Tiro Typeworks foundry that takes advantage of OpenType Layout to provide a variety of stylistic sets, flourishes and ornamentation ligatures:
    Some sample variants of the Gabriola display font.
  10. Who Stole My Browser? If you feel like Internet Explorer is taking a long time to load your page, it’s worth taking a look at the add-ons you have installed. One of the more helpful little additions in Internet Explorer 8 is instrumentation for add-on initialization, allowing you to quickly see whether you’re sitting around waiting for plug-ins to load. Just click Tools / Manage Add-ons, and then scroll right in the list view to see the load time. On my machine, I noticed that the Research add-on that Office 2007 installs was a particular culprit, and since I never use it, it was simple to disable it from the same dialog box.
  11. Rearranging the Furniture. Unless you’ve seen it demonstrated, you may not know that the icons in the new taskbar aren’t fixed in-place. You can reorder them to suit your needs, whether they’re pinned shortcuts or running applications. What’s particularly nice is that once they’re reordered, you can start a new instance of any of the first five icons by pressing Win+1, Win+2, Win+3 etc. I love that I can quickly fire up a Notepad2 instance on my machine with a simple Win+5 keystroke, for instance.

    What’s less well-known is that you can similarly drag the system tray icons around to rearrange their order, or move them in and out of the hidden icon list. It’s an easy way to customize your system to show the things you want, where you want them.
  12. Installing from a USB Memory Stick. My wife has a Samsung NC10 netbook (very nice machine, by the way), and we wanted to install Windows 7 Beta on this machine to replace the pre-installed Windows XP environment. Like most netbook-class devices, this machine has no built-in media drive, and nor did I have an external USB DVD drive available to boot off. The solution: I took a spare 4GB USB 2.0 thumbdrive, reformatted it as FAT32, and simply copied the contents of the Windows 7 Beta ISO image to the memory stick using xcopy e:\ f:\ /e /f (where e: was the DVD drive and f: was the removable drive location). Not only was it easy to boot and install from the thumbdrive, it was also blindingly fast: quicker than the corresponding DVD install on my desktop machine.

    It’s also worth noting in passing that Windows 7 is far better suited to a netbook than any previous operating system: it has a much lighter hard drive and memory footprint than Windows Vista, while also being able to optimize for solid state drives (for example, it switches off disk defragmentation since random read access is as fast as sequential read access, and it handles file deletions differently to minimize wear on the solid state drive).
  13. I Want My Quick Launch Toolbar Back! You might have noticed that the old faithful Quick Launch toolbar is not only disabled by default in Windows 7, it’s actually missing from the list of toolbars. As is probably obvious, the concept of having a set of pinned shortcut icons is now integrated directly into the new taskbar. Based on early user interface testing, we think that the vast majority of users out there (i.e. not the kind of folk who read this blog, with the exception of my mother) will be quite happy with the new model, but if you’re after the retro behavior, you’ll be pleased to know that the old shortcuts are all still there. To re-enable it, do the following:
    • Right-click the taskbar, choose Toolbars / New Toolbar
    • In the folder selection dialog, enter the following string and hit OK:
      %userprofile%\AppData\Roaming\Microsoft\Internet Explorer\Quick Launch
    • Turn off the “lock the taskbar” setting, and right-click on the divider. Make sure that “Show text” and “Show title” are disabled and the view is set to “small icons”.
    • Use the dividers to rearrange the toolbar ordering to choice, and then lock the taskbar again.

    If it’s not obvious by the semi-tortuous steps above, it’s worth noting that this isn’t something we’re exactly desperate for folks to re-enable, but it’s there if you really need it for some reason. Incidentally, we’d love you to really try the new model first and give us feedback on why you felt the new taskbar didn’t suit your needs.

  14. It’s a Drag. Much play has been made of the Jump Lists feature in Windows 7, allowing applications like Windows Live Messenger to offer an easy task-based entry point. Jump lists replace the default right-click context menu in the new taskbar; another way to access them (particularly useful if you’re running Windows 7 on a one-button MacBook) is by left-clicking and dragging up in a kind of “swooshing” motion. This was designed for touch-enabled devices like the beautiful HP TouchSmart all-in-one PC, where the same gesture applies.

    Another place where you can “swoosh” (not an official Microsoft term) is the IE 8 address bar, where the downward drag gesture brings up an expanded list containing the browser history, favorites and similar entries. The slower you drag, the cooler the animation!
  15. Standards Support. Every review of Windows 7 that I’ve seen has noted the revamped WordPad and Paint applets that add an Office-like ribbon to expose their functionality. Few, however, have noticed one small but hopefully appreciated feature: WordPad can now read and write both the Word 2007-compatible Office Open XML file format but also the OpenDocument specification that IBM and Sun have been advocating:
    WordPad in Windows 7 allows you to save in ODF or OOXML formats.
  16. Windows Vista-Style Taskbar. I wasn’t initially a fan of the Windows 7 taskbar when it was first introduced in early Windows 7 builds, but as the design was refined in the run up to the beta, I was converted and now actively prefer the new look, particularly when I’ve got lots of windows open simultaneously. For those who really would prefer a look more reminiscent of Windows Vista, the good news is that it’s easy to customize the look of the taskbar to more closely mirror the old version:
    The Windows 7 Taskbar can be configured for a Windows Vista compatibility view.
    To achieve this look, right-click on the taskbar and choose the properties dialog. Select the “small icons” checkbox and under the “taskbar buttons” setting, choose “combine when taskbar is full”. It’s not pixel-perfect in accuracy, but it’s close from a functionality point of view.
  17. Peeking at the Desktop. While we’re on the taskbar, it’s worth noting a few subtleties. You’ve probably seen the small rectangle in the bottom right hand corner: this is the feature we call “Aero Peek”, which enables you to see any gadgets or icons you’ve got on your desktop. I wanted to note that there’s a keyboard shortcut that does the same thing – just press Win+Space.
  18. Running with Elevated Rights. Want to quickly launch a taskbar-docked application as an administrator? It’s easy – hold down Ctrl+Shift while you click on the icon, and you’ll immediately launch it with full administrative rights (assuming your account has the necessary permissions, of course!)
  19. One More of the Same, Please. I’ve seen a few folk caught out by this one. If you’ve already got an application open on your desktop (for example, a command prompt window), and you want to open a second instance of the same application, you don’t have to go back to the start menu. You can simply hold down the Shift key while clicking on the taskbar icon, and it will open a new instance of the application rather than switching to the existing application. For a keyboard-free shortcut, you can middle-click with the third mouse button to do the same thing. (This trick assumes that your application supports multiple running instances, naturally.)
  20. Specialized Windows Switching. Another feature that power users will love is the ability to do a kind of “Alt+Tab” switching across windows that belong to just one application. For example, if you’ve got five Outlook message windows open along with ten other windows, you can quickly tab through just the Outlook windows by holding down the Ctrl key while you repeatedly click on the single Outlook icon. This will toggle through each of the five Outlook windows in order, and is way faster than opening Alt+Tab and trying to figure out which of the tiny thumbnail images relates to the specific message you’re trying to find.
  21. Walking Through the Taskbar. Another “secret” Windows shortcut: press Win+T to move the focus to the taskbar. Once you’re there, you can use the arrow keys to select a particular window or group and then hit Enter to launch or activate it. As ever, you can cancel out of this mode by hitting the Esc key. I don’t know for sure, but I presume this shortcut was introduced for those with accessibility needs. However, it’s equally valuable to power users – another good reason for all developers to care about ensuring their code is accessible.
  22. image The Widescreen Tip. Almost every display sold these days is widescreen, whether you’re buying a notebook computer or a monitor. While it might be great for watching DVDs, when you’re trying to get work done it can sometimes feel like you’re a little squeezed for vertical space.

    As a result, the first thing I do when I set up any new computer is to dock the taskbar to the left hand side of the screen. I can understand why we don’t set this by default – can you imagine the complaints from enterprise IT departments who have to retrain all their staff – but there’s no reason why you as a power user should have to suffer from default settings introduced when the average screen resolution was 800x600.

    In the past, Windows did an indifferent job of supporting “side dockers” like myself. Sure, you could move the taskbar, but it felt like an afterthought – the gradients would be wrong, the Start menu had a few idiosyncrasies, and you’d feel like something of a second-class citizen. The Windows 7 taskbar feels almost as if it was designed with vertical mode as the default – the icons work well on the side of the screen, shortcuts like the Win+T trick mentioned previously automatically switch from left/right arrows to up/down arrows, and so on. The net effect is that you wind up with a much better proportioned working space.

    Try it – in particular, if you’ve got a netbook computer that has a 1024x600 display, you’ll immediately appreciate the extra space for browsing the Internet. For the first day you’ll feel a little out of sync, but then I guarantee you’ll become an enthusiastic convert!
  23. Pin Your Favorite Folders. If you’re always working in the same four or five folders, you can quickly pin them with the Explorer icon on the taskbar. Hold the right-click button down and drag the folder to the taskbar, and it will be automatically pinned in the Explorer Jump List.
  24. Starting Explorer from “My Computer”. If you spend more time manipulating files outside of the documents folders than inside, you might want to change the default starting directory for Windows Explorer so that it opens at the Computer node:
    The Computer node in Windows 7.
    To do this, navigate to Windows Explorer in the Start Menu (it’s in the Accessories folder). Then edit the properties and change the target to read:
    %SystemRoot%\explorer.exe /root,::{20D04FE0-3AEA-1069-A2D8-08002B30309D}

    If you want the change to affect the icon on the taskbar, you’ll need to unpin and repin it to the taskbar so that the new shortcut takes affect. It’s worth noting that Win+E will continue to display the documents library as the default view: I’ve not found a way to change this from the shell at this time.
  25. ClearType Text Tuning and Display Color Calibration. If you want to tune up your display for image or text display, we have the tools included out of the box. It’s amazing what a difference this makes: by slightly darkening the color of the text and adjusting the gamma back a little, my laptop display looks much crisper than it did before. You’d adjust the brightness and contrast settings on that fancy 42” HDTV you’ve just bought: why wouldn’t you do the same for the computer displays that you stare at every day?
    image image
    Check out cttune.exe and dccw.exe respectively, or run the applets from Control Panel.
  26. ISO Burning. Easy to miss if you’re not looking for it: you can double-click on any DVD or CD .ISO image and you’ll see a helpful little applet that will enable you to burn the image to a blank disc. No more grappling for shareware utilities of questionable parentage!
    You can burn an ISO image to disk with this built-in utility in Windows 7.
  27. Windows Movie Maker. Windows 7 doesn’t include a movie editing tool – it’s been moved to the Windows Live Essentials package, along with Photo Gallery, Mail and Messenger. Unfortunately, Windows Live Movie Maker is currently still in an early beta that is missing most of the old feature set (we’re reworking the application), and so you might be feeling a little bereft of options. It goes without saying that we intend to have a better solution by the time we ship Windows 7, but in the meantime the best solution for us early adopters is to use Windows Movie Maker 2.6 (which is essentially the same as the most recent update to the Windows XP version). It’s missing the full set of effects and transitions from the Windows Vista version, and doesn’t support HD editing, but it’s pretty functional for the typical usage scenario of home movie editing.
    Windows Movie Maker 2.6 is compatible with Windows 7.
    Download Windows Movie Maker 2.6 from here:
    http://microsoft.com/downloads/details.aspx?FamilyID=d6ba5972-328e-4df7-8f9d-068fc0f80cfc
  28. Hiding the Windows Live Messenger Icon. Hopefully your first act after Windows 7 setup completed was to download and install the Windows Live Essentials suite of applications (if not, then you’re missing out on a significant part of the Windows experience). If you’re a heavy user of IM, you may love the way that Windows Live Messenger is front and central on the taskbar, where you can easily change status and quickly send an IM to someone:
    Windows Live Messenger appears by default on the taskbar.
    On the other hand, you may prefer to keep Windows Live Messenger in the system tray where it’s been for previous releases. If so, you can fool the application into the old style of behavior. To do this, close Windows Live Messenger, edit the shortcut properties and set the application to run in Windows Vista compatibility mode. Bingo!
  29. Enjoy The Fish. I’m surprised that not many people seem to have caught the subtle joke with the Siamese fighting fish that is part of the default background, so I’ll do my part at keeping the secret hidden. Check out wikipedia for a clue.
  30. When All Else Fails… There are always those times when you’re in a really bad spot – you can’t boot up properly, and what you really want is something you can quickly use to get at a command prompt so you can properly troubleshoot. Windows 7 now includes the ability to create a system repair disc, which is essentially a CD-bootable version of Windows that just includes the command prompt and a suite of system tools. Just type “system repair disc” in the Start Menu search box, and you’ll be led to the utility.

http://blogs.msdn.com/tims/archive/2009/01/12/the-bumper-list-of-windows-7-secrets.aspx

10/28/09

VBA function to count # of days between two dates

Function DayCount(DateBeg As Date, DateEnd As Date, Optional D1 As Integer, Optional D2 As Integer, Optional D3 As Integer, Optional D4 As Integer, Optional D5 As Integer, Optional D6 As Integer, Optional D7 As Integer)
For i = 0 To DateEnd - DateBeg If Weekday(DateBeg + i) = D1 Then Cnt = Cnt + 1 Else End If
If Weekday(DateBeg + i) = D2 Then Cnt = Cnt + 1 Else End If
If Weekday(DateBeg + i) = D3 Then Cnt = Cnt + 1 Else End If
If Weekday(DateBeg + i) = D4 Then Cnt = Cnt + 1 Else End If
If Weekday(DateBeg + i) = D5 Then Cnt = Cnt + 1 Else End If
If Weekday(DateBeg + i) = D6 Then Cnt = Cnt + 1 Else End If
If Weekday(DateBeg + i) = D7 Then Cnt = Cnt + 1 Else End If
Next i
DayCount = Cnt
End Function

10/23/09

Interview Questions from Employers

The underlying purpose of all questions is to probe or explore your personality, attitude, or behaviour characteristics to gauge if you will be a good fit. Before going to interviews, always take the time to think of questions that you may be asked and compile a list of responses. Remember that most interviewers will be looking for three things when you answer questions:

  • your answer;

  • how well you can organize your thinking; and

  • how well you express yourself.

“Breaking the Ice” Interview Questions

  • Painting (or whatever you wrote in your resume) has always intrigued me. How did you become interested in it?

  • The campus looks very busy. How is your semester going?

  • I see you are involved in sports. How is your season going?

  • I have an extra hour and it's my first visit to the area. What should I see?

Work History Interview Questions

  • What were your responsibilities? Which was most / least rewarding?

  • What were your expectations for the job and to what extent were they met?

  • What were your starting and final levels of compensation?

  • What major challenges and problems did you face? What was your toughest job assignment?

  • How would you evaluate your present firm?

  • What were your biggest accomplishment / failure in this position?

  • What was it like working for your supervisor? What were his strengths and shortcomings?

  • What did you like the most and least about your previous job?

  • What mistakes have you made in your career? How did you fix them?

  • Would you describe a few situations in which your work was criticized?

  • Why are you leaving your job? Why are you looking for a new career? Why did your business fail?

  • Why were you fired? Why have you not obtained a job so far?

  • Why are you not earning more by now?

  • Have you helped increase sales? Profits? Reduce costs?

  • Where do you relate best - up one level, down one level, or with your peers?

  • What do your subordinates think of you?

  • How do you evaluate your subordinates?

  • Describe a situation in which you and a co-worker have disagreed. How did you work it out?

  • Have you ever taken charge as a leader in a work situation without being formally assigned to that role by your boss?

  • Have you ever gone beyond the call of duty in helping a client?

  • How many hours do you normally work?

  • How would you describe the pace at which you work?

  • What were you doing during the period of time not covered in your resume?

  • Have you kept up in your field with additional training?

Personal and Motivational Interview Questions

  • Tell me about yourself. How would you describe your own personality?

  • Can you describe yourself using one-word adjectives?

  • How do you handle rejection?

  • Who or what had the greatest influence on your life?

  • What are some of the greatest personal challenges you have faced during your lifetime?

  • What are some of your personal goals and have you achieved them?

  • What satisfies you, bothers you, or motivates you?

  • List three personal attributes that you would like to improve? Have you made any efforts to improve in these areas?

  • How would others describe your weaknesses?

  • What are your greatest achievements at this point in your life?

  • What accomplishments are you most proud of?

  • What are your strong points? What are your weak points?

Work-Related Interview Questions

  • Have you worked under deadline pressures? Provide examples.

  • How do you handle stress and pressure?

  • Can you discuss a time when you had to perform multiple tasks on very strict time lines? How did you ensure everything was completed on time?

  • Can you describe a typical work week?

  • What have you done that shows initiative and willingness to work?

  • What are the most important rewards you expect in your career?

  • What do you look for in a job?

  • What do you find are the most difficult decisions to make?

  • If you could start again, what would you do differently?

  • If the people who know you were asked why you should be hired, what would they say? How would your colleagues describe you? How would your boss describe you? How would you describe yourself?

  • Do you prefer to work independently or on a team? Give some examples of team work.

  • How do you build a team under you?

  • What type of work environment do you prefer?

  • Can you describe a difficult work situation / project and how you overcame it?

  • How do you evaluate success?

  • Can you describe your ideal work environment? What kind of people do you enjoy working with?

  • How would you handle an upset customer / client?

  • What is the difference between a good position and an excellent one?

  • What is your philosophy of management?

  • How has your early career or background influenced your progression and current management style?

  • How has your management style changed in the last ten years?

  • Can you discuss some of your past leadership roles?

  • How do you rate yourself as a professional? As an executive?

  • Can you discuss the importance of your job as it relates to your family?

  • What was the most difficult ethical decision you have had to make? What was the result?

  • How do you show your anger or frustration?

  • What is the worst situation you have faced in your professional life? How did you deal with it? What happened?

  • Are you a leader? A good manager? Analytical? Give an example we can verify.

  • Have you fired people? When and why?

  • Will you be out to take your boss’s job?

  • Can you tell me about someone who has influenced you personally or professionally?

  • Have you ever stolen anything from a company?

  • Can you tell me about the last time you broke the rules?

  • What is the funniest thing that has ever happened to you?

  • What was the worst career mistake you have ever made and what have you learned from it?

Position-Specific Interview Questions

  • What interests you about this job? What prompted you to apply with our company?

  • What do you know about this company?

  • Why do you want to work for this organization?

  • Why are you the best person for the job?

  • What can you do for us that someone else cannot do?

  • In what ways do you think you can make a contribution to our firm?

  • How long would it take you to make a contribution to our firm?

  • What qualifications do you have that makes you think you will be successful in this business? Why should we hire you? Why should we hire you instead of any of the other well-qualified candidates?

  • Do you prefer large or small organizations? Why?

  • What interests you most about the position we have? The least?

  • What challenges are you looking for in a position?

  • Is there anything I haven't told you about the job or company that you would like to know?

  • What business, credit, or character references can you give us?

  • How long do you expect to work here? When will you know when it is time to leave?

  • Would you object to working for a woman?

  • Do you generally speak to people before they speak to you?

  • Do you not feel you might be better off with a different size firm than ours?

  • What do you think it takes to be successful in an organization such as ours?

  • In what ways do you think you can make a contribution to our organization?

  • Have you ever been a member of a union? Worked with union members?

  • Are you willing to work overtime?

  • What type of work environment are you most comfortable with?

  • Why do you think you might like to live in the community in which our organization is located?

  • Can you list five things about yourself that would make you an asset to any organization that hired you?

  • In addition to your educational and professional experiences, what else would you like us to know about you in order to make an appropriate decision?

  • What kind of hours are you used to working or would like to work?

Interview Questions Related to Remuneration and Benefits

  • What kind of salary are you worth and why? What are your salary requirements?

  • What starting salary do you expect as an employee?

  • What company benefits are most important to you?

  • How do you feel about an income made up totally of commissions?

  • When comparing one company offer to another, what factors will be important to you besides starting salary?

  • How important is starting salary to you when considering our company's job offer?

  • Can you explain your salary history?

Relocation & Travelling Interview Questions

  • Are you willing to travel?

  • Are you willing to go where the organization sends you? Are you willing to relocate?

  • Do you mind traveling?

  • How do you feel about relocating during a career with our company?

Future Career Goals Interview Questions

  • What are you looking for in your next job? What is important to you?

  • What are your goals for the next five years / ten years? How do you plan to achieve those goals?

  • What are your salary requirements - both short-term and long-term?

  • How much money do you hope to earn five years from now?

  • What new goals or objectives have you established recently? Why?

  • What do you know about opportunities in your field?

  • What are the most important rewards you expect from your career?

  • What would you be giving up in your present job to take our position?

  • What position have you held that has been most meaningful to you and why?

  • What improvements would you have made in you last job?

  • What kind of challenge are you looking for?

  • What do you think determines a person's progress in a good company?

  • How do you determine or evaluate success?

  • What personal characteristics are necessary for success in your field?

Interview Questions Related to Education

  • How does your education and experience relate to this position?

  • Why did you not do better in college?

  • Can you summarize your educational background for me?

  • Why did you major in _____________?

  • What courses did you like the most? The least? Why?

  • Do you feel you have done the best scholastic work for which you are capable?

  • Can you describe your most rewarding accomplishment since you've started college?

  • Can you describe your study habits?

  • How did you finance your education?

  • Do you feel you received a good general education?

  • Why did you drop out of school?

  • How do you spend college vacations?

  • What extra-curricular activities are you involved in? What have you gained from these experiences?

  • Do you have plans for furthering your education?

  • If you could start college over, what would you do differently?

  • Why did you choose to major in this field of study? Why did you choose your particular college or university?

  • What were your favorite college courses, those you liked most? Least? Why? Please tell me about accomplishments in your academic program that are relevant to your future career goals.

  • What is your grade point average (GPA)? How do you feel about this? Should grades be used as an indicator of future career potential when an organization is considering new college graduates?

  • What were your reactions to instructors or college faculty during your academic program? How would you relate your academic accomplishments to future career aspirations? How satisfied are you with your accomplishments in this academic program?

  • What was the most difficult aspect of obtaining a college degree? What are your academic strengths? What courses gave you the most difficulty?

  • If you could, what changes would you make in your school's academic program?

Interview Questions Related to Extracurricular Activities and College Experiences

  • How do you spend your spare time? What are your hobbies? What was the last book you read? Movie you saw? Sporting event you attended?

  • How do you spend your free time? What would you do if you had more of it?

  • What extracurricular activities have you been involved in?

  • Can you tell me about your accomplishments in extracurricular activities?

  • What have been your greatest challenges for improvement of a campus organization? What do you enjoy doing most?

  • Can you describe your most rewarding college experiences?

  • Can you give examples of the challenges you experienced during your leadership positions with campus activities?

  • If you could relive your college experiences, what would you do differently?

  • What changes would you make in your overall campus life?

  • During your campus activities, what positions did you hold?

Hypothetical Interview Questions

  • What could you see as the major objectives of this job?

  • If you were hired by our organization, how would you identity the major roles and responsibilities of your new position?

  • What is your purpose in life?

  • How would you resolve conflict in a group situation?

  • If you were given this assignment, how would you proceed?

Closing Interview Questions

  • What are your salary expectations?

  • When can you start work?

  • If we invite you to our facility in [city], would you be able to come?

  • Is there anything else I should know about you?

  • Do you have any other questions?

10/14/09

Table Index Optimization to Improve Dynamics GP Performance

I recently touched up some code I wrote for a client back in 2003. For them, Bob and I integrated GP Depot Management Work Order Entry/Update with Sales Order Processing (Document Number = Work Order Number) for quoting and invoicing repair work and after sales service. Part of this customization enabled them to inquire on their quotes and orders directly from Work Order Entry/Update.

The code simply queries the Sales Order Processing Work (SOP10100) and Sales Order Processing History (SOP30200) tables where the ORIGNUMB = Work Order Number and then opens the Sales Order Processing Document Inquiry, sets the From and To Document Number, and sets the Unposted or History radio button accordingly. This saves the service center personnel significant time when researching work order detail for customers which increases customer satisfaction.

After 6+ years they've accumulated a little history in SOP. The code behind the inquiry buttons placed on Work Order Entry/Update window was taking too long to run. With customer service agents on the phone with customers, waiting more than a few seconds for the system to return data was too long. It didn't take long to realize that there wasn't an index on the SOP30200.ORIGNUMB column. The impact of adding that index was phenomenal reducing wait time from 10+ seconds to what seems like just milliseconds.

To create a new index in SQL Server Management Studio:

1. Right Click on the table and click Design from the menu.
2. From the Table Design menu option select Indexes/Keys.
3. Click Add to create a new index.
4. Select the column(s) on which you want to create the index.
5. Name your indexes consistently so that you can query all them out of sysobjects later when you need to.
6. Set other properties as needed.

















There is a lot of great information widely available about when and how to create new indexes. I strongly recommend you educate yourself and engage an expert to optimize your indexes.

Of course, you can use T-SQL to load new indexes on your tables. Here's a sample:

CREATE NONCLUSTERED INDEX IX_SOP30200_ORIGNUMB ON dbo.SOP30200
(
ORIGNUMB
)
WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

Remember that when you upgrade GP, it's likely that you will need to reload your indexes as the upgrade process will drop the old tables and therefore your indexes. Plan your upgrades accordingly and make sure you script your indexes before you do. Otherwise, GP will generally react positively to the new indexes.

Simple Table Backups with T-SQL

I was working on a project recently with a very experienced and respected GP consultant. He has taught me many things but I was able to show him something very simple that made his life much easier. Simple table level backups with T-SQL.

The following will select all of the data in SOP10100 into a new SOP10100_Bkup_03012009 table:

select *
into SOP10100_Bkup_03012009
from SOP10100

Remember that inserts, updates, and deletes often fire off events that could alter data in other tables. This won't backup those dependent tables so be mindful of the potential that a simple update to one table could affect data on many others.


http://mbsguru.blogspot.com/2009/03/simple-table-backups-with-t-sql.html

Custom Business Alerts

GP does a good job of giving you the ability to create business alerts to keep you informed of events that have or may occur based on conditions in your database. Sometimes, the need to create an alert outside of the functionality in GP does, amazingly, come up. Just today a post at http://groups.google.com/group/microsoft.public.greatplains/topics and a response by Polino @ DynamicsAccounting.net drove me to create a sample business alert using only T-SQL that you could use as a starting point to developing your own.

This alert, if scheduled to run periodically, will e-mail a list of users that have been logged into GP for longer than 12.5 hours or 750 minutes. It's pretty simple!

IF EXISTS
(
select datediff(mi,logindat+logintim, getdate()) as DURATION,--convert(datetime, convert(varchar(15), GetDate(), 114), 114) - LOGINTIM as DURATION,
USERID,
CMPNYNAM,
LOGINDAT,
LOGINTIM
from DYNAMICS.dbo.ACTIVITY
where datediff(mi,logindat+logintim, getdate()) > 750
)
BEGIN

DECLARE @SQL varchar(8000)

SET @SQL = 'select datediff(mi,logindat+logintim, getdate()) as DURATION,
USERID,
CMPNYNAM,
LOGINDAT,
LOGINTIM
from DYNAMICS.dbo.ACTIVITY
where datediff(mi,logindat+logintim, getdate()) > 750'

print @SQL

EXEC master.dbo.xp_sendmail @recipients = 'youralias@yourcompany.com',
@subject = 'Users Logged in beyond limit',
@message = 'Attached is a list of users that have been logged in beyond the limit',
@query = @SQL,
@attach_results = 'TRUE',
@width = 250
END

http://mbsguru.blogspot.com/2009/02/custom-business-alerts.html

Who has that record locked?

I love the GP Newsgroup. Helping others with their problems helps me learn more about GP. Here's what I tought myself today in response to a newsgroup post.

Run this against your company database to select the users which users have SOP Documents locked:

select distinct l.row_id, t.dex_row_id, t.SOPNUMBE, a.USERID
from tempdb.dbo.Dex_Lock l
inner join SOP10100 t
on l.row_id = t.dex_row_id
inner join DYNAMICS.dbo.Activity a
on l.session_id = a.SQLSESID
where right(rtrim(table_path_name), 8) = 'SOP10100'

http://mbsguru.blogspot.com/2007/12/who-has-that-record-locked.html

SQL Nugget - shortcut to create INSERT into

Here's a SQL nugget I love to use when writing stored procs, triggers, and the like. Copy and paste this into query analyzer and replace %TableName% with the name of the Table in which you want to insert records. Execute it to return the INSERT into statement complete with default values for every field in the table. Paste the results into your object and populate the fields with your values. This can be a real time save for developers and when doing data conversions.

A slick cat we'll call Mo gave this to me. I can't take credit for it.

set nocount on
DECLARE @sTableName varchar(128)set @sTableName = '%TableName%'
select @sTableName as sTableName into #tmpTableName
DECLARE @lTableID intset @lTableID = NullSELECT @lTableID = [ID] from sysobjects where (objectproperty(id, N'IsTable') = 1) and (id = object_id(@sTableName))
if (@lTableID is Null)begin print 'Table not found! Aborting.' returnend
SELECT [name], xtype, prec, scale, colorder, isnullable into #tmpColumns from syscolumns where ([id] = @lTableID) and (colstat = 0) order by colorder
alter table #tmpColumns ADD lRowID int not null identity, -- add an identity column to the temp table sDefault varchar(40) -- add a column to store the default that we want to enter for new rowsGO
UPDATE #tmpColumns set sDefault = case xtype when 34 then ''' ''' -- image when 35 then ''' ''' -- text when 36 then Null -- unique identifier when 48 then '0' -- tinyint when 52 then '0' -- smallint when 56 then '0' -- int when 58 then '''1/1/1900''' -- smalldatetime when 59 then '0.0' -- real when 60 then '0' -- money when 61 then '''1/1/1900''' -- datetime when 62 then '0.0' -- float when 99 then ''' ''' -- ntext when 104 then '0' -- bit when 106 then '.00' -- decimal when 108 then '0.0' -- numeric when 122 then '0.0' -- smallmoney when 165 then '0' --'convert(varbinary, '' '')' -- varbinary when 167 then ''' ''' -- varchar when 173 then '0' --'convert(binary, '' '')' -- binary when 175 then ''' ''' -- char when 189 then Null -- timestamp when 231 then ''' ''' -- nvarchar when 239 then ''' ''' -- nchar endDELETE #tmpColumns where sDefault is Null--select sDefault, xtype, [name] from #tmpColumns order by colorder, lRowID

DECLARE cur insensitive scroll cursor for select sDefault, [name] from #tmpColumns order by colorder, lRowIDOPEN cur
declare @sDefault varchar(40), @sName varchar(128)declare @sWork varchar(200)declare @sWork2 varchar(100)
select top 1 @sWork2 = sTableName from #tmpTableNameprint 'INSERT into ' + @sWork2print ' ('
FETCH first from cur into @sDefault, @sNameWHILE ( @@fetch_status = 0 )begin set @sWork = char(9) + @sName
FETCH next from cur into @sDefault, @sName -- if the fetch is good, add a ',' to the end if ( @@fetch_status = 0 ) set @sWork = @sWork + ','
print @sWorkendprint ' )'
print 'select'
FETCH first from cur into @sDefault, @sNameWHILE ( @@fetch_status = 0 )begin set @sWork = char(9) + @sDefault set @sWork2 = @sName
-- get the next record from the cursor FETCH next from cur into @sDefault, @sName
-- if the fetch is good, add a ',' to the end if ( @@fetch_status = 0 ) set @sWork = @sWork + ','
set @sWork = @sWork + char(9) + '-- ' + @sWork2 print @sWorkend
CLOSE curDEALLOCATE CUR
DROP table #tmpColumnsDROP table #tmpTableName

http://mbsguru.blogspot.com/2006/04/sql-nugget-shortcut-to-create-insert.html

Find tables, with data, that have a spefic column

We're going to change some Item Numbers in GP. I know, I can use PS Tools to do this but to use that you have to turn off your replication. Long story short, I don't wanna.

Anyway, I had to figure out which tables to update so I wrote a query that would return to me all of the tables, with data, that have an ITEMNMBR column:

select distinct o.Name
from SysColumns c
inner join SysObjects o
on c.id = o.id
inner join SysIndexes i
on c.id = i.id
where c.name = 'ITEMNMBR'
and o.xtype = 'u'
and rowcnt <> 0

http://mbsguru.blogspot.com/2007/12/find-tables-with-data-that-have.html

Deleting Empty Batches in SOP

Schedule this script to run periodically against your company database to delete empty SOP batches automatically. It will check to verify that there aren't any transactions in the batch and that there is not a batch activity record first.

DECLARE @INTERID varchar(10),
@CMPNYNAM varchar(31)

SET @INTERID = DB_Name()
SELECT @CMPNYNAM = CMPNYNAM from DYNAMICS.dbo.SY01500 where INTERID = @INTERID

DELETE SY00500
where BCHSOURC = 'Sales Entry'
and BACHNUMB not in (select BACHNUMB from SOP10100)
and BACHNUMB not in (select BACHNUMB from DYNAMICS.dbo.SY00800 where CMPNYNAM = @CMPNYNAM and TRXSOURC = 'Sales Transaction Entry')

http://mbsguru.blogspot.com/2007/11/deleting-empty-batches-in-sop.html

10/3/09

To Check or Not to Check: Understanding Landed Cost's Invoice Match and Revalue Inventory Options in Microsoft Dynamics GP

Dynamics GP presents two selection options in the Landed Cost Maintenance screen: Invoice Match and Revalue Inventory. These two options have profound accounting effects in how inventory and purchases are tracked in GP. The following is provided as is and was posted by Marge Swanson, Senior Software Development Engineer at Microsoft in response to a user's question on the Dynamics GP community board, but I felt it was important to rescue as it contains valuable information not found in the manuals or elsewhere:

You should determine whether or not to mark the Invoice Match checkbox based on how you want your distributions to be tracked for the Landed Cost. If you do not mark Invoice Match, the distributions will be reversed from the accrued purchases account used on the Shipment – which defaults from the Landed Cost card. If you mark Invoice Match, the distributions will be created with the Purchase Price Variance account on the Landed Cost Maintenance window.

This helps you track the variances to a separate account if you want to. If you also mark Revalue IV when you mark Invoice Match, the distributions will assigned to the inventory account associated with the item the landed cost is applied to. The cost basis for the item will also be updated for any cost variance on the Landed Cost.

Example: Invoice matching and distributions for landed costs

Marking the Invoice Match option for a landed cost record will affect account distributions. For example, suppose that a shipment is recorded for 10 items at $1 each. The landed cost uses the Flat Amount cost calculation method, and the flat amount is $0.50.

The distributions for the shipment would look like this:


Inventory $10.50
Accrued Purchases - Landed Cost ($0.50)
Accrued Purchases – Inventory ($10.00)

Suppose that when the invoice is received, the cost of the goods is unchanged, but the landed cost has increased to $0.75. If Invoice Match is not marked, the account distributions would be as follows.


Accrued Purchases - Landed Cost $0.75
Accrued Purchases – Inventory $10.00
Accounts Payable ($10.75)

If Invoice Match is marked and the Revalue Inventory option is marked for the cost variance, the account distributions would be as follows:


Accrued Purchases - Landed Cost $0.50
Accrued Purchases - Inventory $10.00
Inventory $0.25
Accounts Payable ($10.75)

If Invoice Match is marked and Revalue Inventory option is not marked for the cost variance, the account distributions would be as follows:


Accrued Purchases - Landed Cost $0.50
Accrued Purchases - Inventory $10.00
Purchase Price Variance $0.25
Accounts Payable ($10.75)

Until next post!

GP 10 SDK

http://www.microsoft.com/downloads/thankyou.aspx?familyId=16d5bcea-c965-4f9a-a965-f4a81b0dd564&displayLang=en