Windows Management And Scripting BlogA wealth of tutorials on various Windows Operating Systems related topics like setting up Windows 7/2003/2008/Azure SQL Server 2005,2008 and Azure, troubleshooting and more.

Use Xperf to granularly determine what function calls are eating up precious resources

Monitoring the kernel of the Windows operating system to make out performance issues can be a very challenging endeavor. Sure Perfmon, PAL and Xperf can show that the OS is costs x amount of time executing in kernel mode, but how can one determine what parts of the kernel (function calls) are consuming significant amounts of time?

In the past, it was necessary to force multiple thump dumps in an effort to profile where the kernel was costs its time. By forcing a memory dump, the debugger is able to show the stack traces …

Troubleshooting Exchange 2010 virtual directory re-creation

Ever since Exchange Server 2010 Service Pack 1 dropped, administrators have had two methods to recreate the six Exchange virtual directories: reset them or reinstall the client access server role. Files are occasionally misconfigured or hurt by third-party apps, even if, leaving virtual directories unusable. The virtual index re-creation process is straightforward and well-documented, but it doesn’t always work, and troubleshooting is sometimes necessary.

Exchange Server 2010 SP1 was the first version of Exchange to allow admins to re-initiation virtual directories via the Exchange Management Console (EMC). In the …

New T-SQL commands in SQL Server 2012 – part 2

I’d gladly acknowledge a dime for every time I’ve heard an Oracle programmer say to a SQL Server programmer, “You’re just getting that feature now? Why, we Oracle users have had that for years!” Well, here’s another case where Oracle those can finally stop thumbing their nose at SQL Server developers: the SEQUENCE object.

Sequences work a small like identity columns, except they’re not bound to a particular table but rather to a given schema. When made, the object follows particular rules to define the system. Sequences are …

SQL Azure Security should not be an issue but loose of control should be took in consideration

SQL Azure security terrifies IT, but loss of control might be real dread