• Home
  • Speaking
  • Training
  • Articles
  • About
  • Contact
  • Twitter Twitter icon
  • Instagram
  • Dev.to dev.to icon
  • LinkedIn LinkedIn icon
  • RSS RSS icon

Use the Right Tool for the Right Job - ExecuteScalar or ExecuteNonQuery

31 January 2008 All

Would you use a drill to pre-drill a hole for a nail to hang a picture? I wouldn't either. Just hammer the nail into the wall. OK, need something more code related? Would you define a class with a single property and no other members just to store a string? Me neither. <FONT color=#008000&g

Tip: Side by Side Installation of SQL Server 2005 and SQL Server 2000

31 January 2008 All

<FONT color=#800080>Tip: when installing SQL Server, consider using named instances. I recently installed SQL Server 2005 on my PC. It went fairly quick and installed with 0 issues. I was also quite pleased that it installed very nicely side by side with a SQL Server 2000 installation already

The Zenker Has Landed!

31 January 2008 All

A very talented former colleague of mine has entered the world of blogging. You can check out all that The Zenker [http://www.dotnetjunkies.com/WebLog/azenker/default.aspx] (Andreas Zenker) has to say at his new blog at http://www.dotnetjunkies.com/WebLog/azenker/default.aspx.

The Forgotten Woes

31 January 2008 All

We're all celebrating the recent advancements in .NET and other technologies like LINQ, XML in SQL Server and the fascinating tools like CodeRush [http://www.devexpress.com]and ReSharper [http://www.jetbrains.com]. But it struck me this week that we haven;t gone far enough in some areas ... like

Thanks for the Nomination

31 January 2008 All

Congratulations to Geoff [https://www.johnpapa.net/blogs/geoff.appleby] for getting his MVP award today. I also owe a great big thanks to those who nominated me and a thanks to the MVP team for awarding me with the MVP award. I was notified earlier today that I am now an MVP for Visual Developer - V

Newer Posts
Page 208 of 232
Older Posts

John Papa

Hi, I'm John Papa. I author this blog, create courses for Pluralsight, and work in Developer Relations. I am a professional storyteller, I contribute to OSS, and I'm a Web technologist

Latest Projects

  • Comparing Callbacks, Promises and Async Await in TypeScript
  • Debug Angular 9: Interacting with Components
  • Vanilla JavaScript and HTML - No frameworks. No libraries. No problem.
  • Shifting Your Node Express APIs to Serverless
  • Predictive Preloading Strategy for Your Angular Bundles
  • How I Write Online Articles
  • Debug Your Node.js App in 60 Seconds
  • The Next.js for Angular - Analog on Web Rush #290
  • VS Code to the Cloud in 60 Seconds on Web Rush #289
  • Make AI Useful For You on Web Rush #288
  • Why You As A Developer Must Care About Managing Your APIs on Web Rush #287
  • Fast Development with Visual Studio on Web Rush #286
  • The Best of Build for Developers on Web Rush #285
  • App Spaces: Simplifying App Development in Azure on Web Rush #284
  • Twitter Twitter icon
  • Instagram
  • Dev.to dev.to icon
  • LinkedIn LinkedIn icon
  • RSS RSS icon
Copyright 2025 John Papa

This work is licensed under a Creative Commons Attribution 4.0 International License. In other words, share generously but provide attribution.

Disclaimer

Opinions expressed here are my own.

Published with Ghost

This site is hosted on Ghost.io
Theme by Cross Stroke.