I am a Senior Applications Programmer / Analyst with years of experience developing enterprise solutions using the Microsoft technology stack including C#, VB.NET, ASP.NET, AJAX, IIS and SQL Server.
I specialize in Web application development with a focus on building secure systems, integrating applications, and designing robust database structures.
In this article I will go through a technique that you can use when working with a modal popup that lets you store form information from your popup to later use with your main Web form.
In earlier articles I have covered some of the general functions and benefits of using the ShowModalDialog function that I will expand on this article. If you have questions about some of the code I’ve used in this article, then please take a look at my earlier articles that might help explain some of the concepts:
If you have several different versions of the same database then you will want to be able to check for differences in the objects between the databases. You can quickly and easily do so using SQL Server’s sys.objects or if you are specifically looking up stored procedures, SQL Server’s sys.procedures system views.
Let’s take an example use case where if you have a development and a deployment database and you want to check what procedures in development that you (or someone on your team) has worked on that you should now move to deployment. Normally it’s not too difficult to remember, but if there are a large number of small changes or a long time has passed since you made the changes, then you’ll need to run a simple difference comparison between the two databases to remember what procedures you need to migrate.
Luckily you can simply type in your comparison query in SQL Server Management Studio (SSMS). This is as powerful and granular as you want it to be and can be just as accurate as specially written custom tools. Unlike custom tools though, this method comes with SQL Server and just requires a bit of understanding of the sys.objects system view.
You can find this information scattered all over the Web, but I want to make a note of where to find your WordPress XML Site Map and RSS feed.
By the way, the Site Map and RSS feed URLs are just for sites hosted on WordPress.com and not self-hosted WordPress sites, but the WebMaster Tools information is applicable to everyone.
Knowing the location of your RSS and Site Map is especially useful information to have at hand when you are registering your site with Bing or Google. In both search engines it’s a good idea to submit both your RSS feed and your Site Map to their site maps section.
Basically I’m putting together this article to keep a list of useful links in place to refer to when managing one’s WordPress Web site. I have some other articles that cover general Web development topics that you might find interesting if you found this article useful. (more…)
Justin Cooney 