Systems Engineering and RDBMS

Archive for the ‘Windows’ Category

Enterprise Features of Windows 7

Posted by decipherinfosys on February 24, 2009

InfoWorld had a good post on the enterprise level features of Windows 7.  You can read more on it over here.

Posted in Windows | Leave a Comment »

Data Access Tracing

Posted by decipherinfosys on February 18, 2009

We have covered ODBC tracing before on our blog.  While troubleshooting an issue for a client, came across this wonderful MSDN article from MSFT on how to do data access tracing for applications using SQL Server 2008.

Posted in .Net Development, SQL Server, Windows | Leave a Comment »

Creating an empty file in Unix and Windows

Posted by decipherinfosys on February 15, 2009

Recently at a client site, we came across a situation where we had to create empty files with a specific size on Windows.  We had to do this for R&D purposes in order to be able to mimic ASM in Windows environment without actually having different disks.

Windows has a utility called fsutil.exe. This is a command line utility. Mainly it is used for maintaining file and disk properties and is an advance level utility. But one of its fine usages is to create the empty file of a specific size. Following is the command to create an empty file.

C:\>fsutil file createnew c:\ttt.txt 2048
File c:\ttt.txt is created

C:\>dir ttt.txt
Volume in drive C is C-Drive
Volume Serial Number is 2482-1E9C

Directory of C:\

02/12/2009 05:10 PM 2,048 ttt.txt

Similarly in Unix, there is a touch command. The touch command updates the access and modification times of each file specified by the parameter or command line argument. If time value is not specified then touch command will use current time. If we specify a file that does not exist, it will create that file with current date time unless –c flag is specified. When –c flag is specified it will not create the file, if it does not exist. Following command shows that.

$ touch -c ttt.txt
$ ls -l ttt.txt
ls: 0653-341 The file ttt.txt does not exist.

Now let us issue same command without using –c flag.

$ touch ttt.txt
$ ls -l ttt.txt
-rw-r–r– 1 b01234 uga 0 Feb 13 17:19 ttt.txt

Posted in Linux, Unix, Windows | 1 Comment »

Windows – Disabling the Shutdown Event Manager Screen

Posted by decipherinfosys on February 9, 2009

Recently, while helping a client production staff with installation of their vendor application, there were several instances when we had to reboot the server every now and then and the client production staff (a Linux and Unix system admin) was becoming disgruntled by the Shutdown Event Manager Screen which asks for entering a comment prior to the reboot.  Now, there is a good reason why it is in place since besides the obvious “reboot by mistake” issue, it also helps you to keep record of the planned/unplanned reboots along with the comments but folks rarely enter a valid comment in there.  So, if you do not want that screen to come up when you reboot the machine, you can simply disable that functionality.  Follow these simple steps:

1) Start/Run, type gpedit.msc and press enter.

2) Open up Computer Configuration, then Administrative Templates and then System.  You will see “Display Shutdown Event Tracker” in the right pane.  Double click it.

3) And then disable it.


Posted in Windows | Leave a Comment »

Cloud Computing: Azure Services Platform

Posted by decipherinfosys on February 8, 2009

Here is an excellent whitepaper from David Chappell that goes over the basics of the Azure Services Platform and what it has to offer to the developers and corporations to build the next generation applications:

Posted in .Net Development, Cloud Computing, SQL Server, Technology, Windows | Leave a Comment »

SQL Server 2008 install on Windows Server 2008

Posted by decipherinfosys on January 26, 2009

Recently, we got a chance to play with Windows 2008 Server and one of the things that we needed to do was to install SQL Server 2008 on it.  The steps are pretty much the same as we had on Windows 2003 with the only difference being that the firewall is enabled by default in Windows 2008 Server and thus we got the warning message during the install about it.  We had covered the SQL Server 2008 install on Windows 2003 Server in the past in our document here.

Here is another document which gives screenshots for the step by step basic install of SQL Server 2008 on Windows 2008 Server.

Posted in SQL Server, Windows | Leave a Comment »

MSFT offers freebies to Startups

Posted by decipherinfosys on November 6, 2008

We are a big fan of OM Malik’s articles and posts – clear, concise piece of information and very well written. So, today morning when I read the news about MSFT offering freebies to startups, we wanted to share that with everyone else as well. Their newest effort BizSpark is a boon for smaller companies. You can read all about it at Om’s blog post here.

Posted in News, Technology, Windows | Leave a Comment »

Windows Azure and Azure Services Platform

Posted by decipherinfosys on November 2, 2008

MSFT launched their much talked about cloud OS – Windows Azure and will be using the SSDS (SQL Server Data Services) as the data storage. SSDS is now being called as SQL Services. Windows Azure will provide developers with an on demand computing and storage to be able to host and manage their web based applications on the internet via MSFT data centers.  It’s designed for cloud computing and is a new services based OS which has been specifically designed for SAAS (Software As A Service) model.  The Azure Services platform consists of the Windows Azure OS, and these services at the top of it:

  1. SQL Services (all data services)
  2. .Net Services
  3. Sharepoint Services
  4. Dynamics CRM Services, and
  5. Live Services

More links on this topic:

Posted in Cloud Computing, Technology, Windows | Leave a Comment »

Perfmon Tools

Posted by decipherinfosys on October 17, 2008

We have covered perfmon before in a couple of articles and blog posts. In today’s post, we are going to take a look at some of the freebies that MSFT offers in order to make working with perfmon even easier. It is already easy enough but these tools provide a wizard as well as extract the data in different formats and also allow us to manage and schedule the performance counters. There are three such tools:

1) Performance Monitor Wizard: You can download this tool from here. It provides a wizard to simplify the creation and management of the performance monitor logs. It is a pretty simple tool but does have limited collection methods – you can have OS Counters, Exchange counters etc. and you can select from three different types of collection methods – Standaard, High CPU and Advance Configuration.

It does not have any SQL Counters though. You can use the wizard and then later on add your own objects to monitor once you have the perfmon set up.

2) Relog and 3) Logman are other two very nice utilities. We had blogged about those before and you can read more on those over here.

Posted in Windows | Leave a Comment »

Database Instant File Initialization

Posted by decipherinfosys on August 30, 2008

Not many people know about Database File Initialization that can be done in SQL Server 2005. This MSDN post mentions it pretty clearly what the benefits are by initializing the data and log files. So, what is the advantage of this feature and how can we make use of this feature are the two questions that come to mind immediately.

The advantages are that when performing operations like database creation, file additions to an existing user database, restoring a database or a filegroup and increasing the size of the database, having database instant file initialization can reduce the time of these operations. This feature skips out the zeroing out of the data on the disk and thus does not overwrite the data written on the disk. The OS allocates the disk space and the contents of the file is written down to the disk. This is available on all editions of SQL Server 2005 on Windows Server 2003 and Windows XP on NTFS filesystem.

But in order to make use of this feature, you would need to configure your instance to take advantage of this feature. Here is what you need to do in order to configure the instance to take advantage of this feature:

1) Open up Local Security Settings after going to Start/All Programs/Administrative Tools/Local Security Policy.

2) The screen that will come up will be this:

3) Double click on “Perform volume maintenance tasks” entry and add the SQL Server Service account or the local group SQLServerMSSQLUser$instancename.

Also remember that this is just for the data files so in case you have a large txn log file, the data file will be initialized instantaneously but not the log file. The log file has to be zeroed out before being written to the disk.

Posted in SQL Server, Windows | Leave a Comment »