Me, Myself and Mayvelous

Archive for the ‘Microsoft’ Category

I learnt something new today. I needed to make a release which includes lots of changes to DB over 3 months period and needed a quick way to figure out which staging db objects to move across to the production.

I wished many times to list storedprocedures by last modified date but stupid enough never Google it and just did the painful way of noting down and scripting them. Then I face the problem of all those script files keep piling up over the period of time and lost track of which scripts have been executed or not.

Today I’m in a bit of sensible mode and did a quick googling and found this useful script, so I’m posting here for later reference.

Listing last modified storedprocedures
select name, create_date, modify_date
from sys.procedures
order by modify_date desc

Listing last modified tables
select name, create_date, modify_date
from sys.tables
order by modify_date desc

Listing db objects by type and date
FROM sys.objects
WHERE type in ('P', 'U')
AND DATEDIFF(D,modify_date, GETDATE()) < 90

Type “P” is for storedprocedures and “U” for tables. More on available Types:

Now that I know which objects have been last updated, I can do the DB script very easily by just selecting those objects. Sweet isn’t it? ;)

  • Comments Off
  • Filed under: Development, Microsoft, SQL, Tips and Tricks, Work
  • I was checking out this Silverlight Pivot Viewer where you can browse through 10yrs worth of MSDN Magazines; found it pretty neat fast loading interface but it’s annoying when you select an article and click either “Read Article” or “Download Code” link, it redirects you to the article page on the same viewer page. And when you want to go back, you have to relaunch the viewer and reenter the search criteria again. I wish they make the article links open in new window so we can still keep viewer open.

    Below are the screenshot of the article page cloud based on the search criteria I entered and the zoom in view of it.

    Silverlight Pivot Viewer Silverlight Pivot Viewer

    Anyways, it’s good that we can search all MSDN articles using this thing quite easily so I’m pretty satisfy with it.

    Saw this over at “In search of simplicity, quality and tranquility in software engineering“; a series of posts on SDLC – Software Development Lifecycle. Thought a good series to follow and read it over the weekend. Love the graphics on each post!


    1. SDLC – Software Development Lifecycle … what’s the point? (part 1 of many)
    2. SDLC – Software Development Lifecycle … closer look at basics (part 2 of many)
    3. SDLC – Software Development Lifecycle … exploring common models (part 3 of many)
    4. SDLC – Software Development Lifecycle … agility strikes back with energy (part 4 of many)
    5. SDLC – Software Development Lifecycle … is prototyping  part of the good, the bad and/or the evil? (part 5 of many)
    6. SDLC – Software Development Lifecycle … analyzing the battle ahead (part 6 of many)
    7. SDLC – Software Development Lifecycle … designing the blueprint (part 7 of many)
    8. SDLC – Software Development Lifecycle … testing, the moment of truth (part 8 of many)
    9. SDLC – Software Development Lifecycle … flashback, component-level design principles (part 9 of many)
    10. SDLC – Software Development Lifecycle … Visual Process & Estimating (Guessing) Software Deliverables
    11. To scrum or to Run … that is the agile question? (new)

  • Comments Off
  • Filed under: Development, Microsoft, News, Notes, Software, Technology
  • This is definitely something interesting for me to try out; I just read a short post on Blogging Pro about Microsoft Web Application Installerand thought it might interest some of you so just passing on.

    Previously, to deploy a php application eg. wordpress, on Windows, we have to use something like XAMPP (that’s what I used anyways) and the like, do some configurations, pull hair and throw some fits to be able to deploy successfully.

    Now they’ve released this thing called Microsoft Web Application Installer, which is a freeware and suppose to ease those pain while deploying.

    The Web Application Installer Beta is designed to help get you up and running with the most widely used Web Applications freely available for your Windows Server. Web AI provides support for popular ASP.Net and PHP Web applications including Graffiti, DotNetNuke, WordPress, Drupal, OSCommerce and more.

    System requirements

    • Supported Operating Systems are: Windows Vista RTM, Windows Vista SP1, Windows Server 2008
    • You must have administrator privileges on your computer to run Web Platform Installer Beta
    • .NET 2.0 Framework
    • Supported Architectures: x86 and 64-bit

    Detail feature reading and some Q&As here.

    Sounds simple enough. Oh yah, me want, me want, I want WP on my Vista!!!
    So lets test it out, download Microsoft Web Application Inataller here and instruction to install wordpress.

    Alrite, here I go…………..


    Just going through my feeds and this one interests me. There is an announcement of the next version of Visual Studio and .Net Framework: Visual Studio 2010 and .Net Framework 4.0.

    Visual Studio 2010 and the .NET Framework 4.0 mark the next generation of developer tools from Microsoft. Designed to address the latest needs of developers, Visual Studio and the .NET Framework deliver key innovations in the following pillars:

    • Democratizing Application Lifecycle Management
      Application Lifecycle Management (ALM) crosses many roles within an organization and traditionally not every one of the roles has been an equal player in the process. Visual Studio Team System 2010 continues to build the platform for functional equality and shared commitment across an organization’s ALM process.
    • Enabling emerging trends
      Every year the industry develops new technologies and new trends. With Visual Studio 2010, Microsoft delivers tooling and framework support for the latest innovations in application architecture, development and deployment.
    • Inspiring developer delight
      Ever since the first release of Visual Studio, Microsoft has set the bar for developer productivity and flexibility. Visual Studio 2010 continues to deliver on the core developer experience by significantly improving upon it for roles involved with the software development process.
    • Riding the next generation platform wave
      Microsoft continues to invest in the market leading operating system, productivity application and server platforms to deliver increased customer value in these offerings. With Visual Studio 2010 customers will have the tooling support needed to create amazing solutions around these technologies.
    • Breakthrough Departmental Applications
      Customers continue to build applications that span from department to the enterprise. Visual Studio 2010 will ensure development is supported across this wide spectrum of applications.

    Here is a full overview of Visual Studio 2010 and .NET Framework 4.0 and some more reading on vSTS 2010 (code-name “Rosario”): What’s new in Visual Studio Team System 2010. Read some more detail announcement on Somasegar’s (senior vice president of the Developer Division at Microsoft) post: What’s next for Visual Studio and .NET FX?

    Ok, that’s about it for now.

    Flickr Photos


    Twitter Status

    Goodie Links

    Mayvelous Friends

    I'm an Author for Global Voices