Jay's Blog

[coding, debugging, and troubleshooting with Microsoft Technologies]

Browse by Tags

Tagged Content List
  • Blog Post: Using Windows 2008 R2 as a workstation (and a lab)

    Lately there seems to be an increasing number of people that want to run Windows 2008 R2 Server as their primary OS on their laptop or desktop systems as opposed to Windows Vista or Windows 7.  I’ve been doing this for some time now, and I thought I’d share my experience.   I first started...
  • Blog Post: Proper I/O Capacity Planning and Configuration Resources for SQL Server

    To understand and perform proper IO Capacity Planning for SQL Server, you must understand the IO characteristics and data access patterns of the workload that will be sent to the SQL Server.   Unless you are using a vendor or 3rd party product, the workloads will be specific to each customer...
  • Blog Post: Why is using “Instant File Initialization” on my SQL Server a potential security issue?

    Starting in SQL Server 2005 and onward, data files can be “instantly” initialized.  This helps to drastically reduce the amount of time required for creating large databases, adding files to an existing database, increasing the size of an existing data file (i.e. an auto-grow operation), or restoring...
  • Blog Post: Cool Windows 7 Feature…

    I’d have to say that one of my favorite new features from Windows 7 – that doesn’t seem to be all that well known – is the new Problem Steps Recorder. It’s a great way for someone to show you the steps they’ve taken when encountering an issue, or for you to document...
  • Blog Post: How can I create a dump of SQL Server?

    You can create a memory dump of the SQL Server process space in several ways. There are many external tools that can help you accomplish this such as userdump.exe, debugdiag.exe, and ADPlus.exe. In this post, I’ll cover 3 common ways to accomplish this for SQL Server: The most common way (sqldumper...
  • Blog Post: Windows 7 God Mode

    Was browsing through my RSS feeds today and saw this on Channel 9: http://www.downloadsquad.com/2010/01/03/stupid-windows-7-trick-unlock-the-secret-god-mode-folder/ You can create a special folder that has shortcuts for just about every task one can imagine performing on Windows 7. Pretty interesting…...
Page 1 of 1 (6 items)