SQL Server 2005 supports Database Instant File Initialization which skips zeroing out data pages that can reduce the time when performing operations like creating databases, adding files to an existing database, increasing the size of an existing database file manually or thru autogrowth or restoring a database or filegroup. I’ve written an article in MSSQLTips.com […]
I was privileged enough to do another presentation for the PASS Community Summit this year in Seattle, WA. PASS stands for Professional Association for SQL Server. While this may be a technical conference, my session topic isn’t. I will be speaking on Using Emotional Intelligence in Information Technology. My goal for presenting at PASS is […]
You definitely know this if you were required to memorize nursery rhymes when you were a kid. Who would ever imagined a nugget of truth embedded behind those lines Humpty Dumpty sat on a wall. Humpty Dumpty had a great fall. All the king’s horses and all the king’s men Couldn’t put Humpty together again. […]
>I was asked by a friend of mine to check why a specific batch file was not being called by a job in Task Scheduler. The first thing I did was to check if the account that was used to run the job had the appropriate permissions. The account used was a domain account with […]
I normally create VMWare images using my laptop for testing and then deploy on servers for production. My laptop only has an Intel Centrino CPU but the target servers have multiple CPUs. My problem lies where VMWare supports multiple CPUs. This means that configuring my VMWare image on my laptop would not take advantage of […]