Tip of the Day

Tiny amounts of knowledge for a fast paced world!

Tip of the Day

Posts
  • Tip of the Day: Dedup'ing VHDx files

    Today’s Tip… In Windows Server 2012, dedup was more focused on consolidation for files at rest and that have gone unchanged for x days, where x=5 by default. Windows Server 2012 R2 provides deduplication that consolidates files which are more in use,...
  • Tip of the Day: USB support in Hyper-V...sorta

    Today’s Tip… The Windows-To-Go USB drives allow you plug in said device, and present it to virtual machine in Hyper-V (you would simply attach it to a virtual SCSI controller). This works in Windows Server 2012 or newer.
  • Tip of the Day: Reading the USN Journal

    Today’s Tip… While FSUTIL has been able to provide users with the ability to query and control the USN journal (the change journal for NTFS) for some time now, Windows 8.1/Server 2012 R2 added the ability to read the data within the journal. fsutil usn...
  • Tip of the Day: Is a hotfix installed? Part 2

    Today’s Tip… Yesterday I sent out a tip about querying to see if a hotfix is installed by using SYSTEMINFO. And while I did already sent a tip some time ago about how to do this using Windows PowerShell, I wanted to share some of the ideas that people...
  • Tip of the Day: Is a hotfix installed?

    Today’s Tip… We often want to verify if a specific hotfix is installed on a particular system or not. It is quite a task to bring up the Windows Update à Installed Updates and search for the specific hotfix. Here is a simple command that would enable...
  • (SQL) Tip of the Day: High Availability and Disaster Recovery for SQL Server in Azure Virtual Machines

    Today’s (SQL) Tip… “Microsoft Azure virtual machines (VMs) with SQL Server can help lower the cost of a high availability and disaster recovery (HADR) database solution. Most SQL Server HADR solutions are supported in Azure virtual machines, both as Azure...
  • (SQL) Tip of the Day: SQL 2014 Buffer Pool Extension

    Today’s (SQL) Tip… Buffer Pool Extension was added in SQL 2014 and allows you to use SSDs to add to the speed of your database. With this you can get the benefits of SSDs without having to have your whole database hosted on them. You can check out more...
  • (SQL) Tip of the Day: AlwaysOn Availability Groups Supported between Microsoft Azure Regions

    Today’s (SQL) Tip… Availability Groups are now supported between different Azure Regions. Any regions available today (4 in United States, 2 in Europe, 2 in Asia Pacific, 2 in Japan, and 1 in Brazil). This builds on top of Microsoft Azure’s new support...
  • (SQL) Tip of the Day: SQL on an Azure VM Checklist

    Today’s (SQL) Tip… We have recently released a checklist of all the steps you should follow to create the best possible performing VM in Azure for SQL. The checklist goes through all of the steps you should take to configure both your VM and the disks...
  • (SQL) Tip of the Day: Common Pitfall in SQL Azure Geo-DR

    Today’s (SQL) Tip… Now that we have released Active Geo-Replication for SQL Azure I have helped a few customers set it up. One pitfall that we have run into (and often isn’t noticed until you try to use the replica) is that there are additional security...
  • Tip of the Day: Taking notes in OneNote with your Voice

    Today’s Tip… Did you know you can takes notes in OneNote with your voice on your phone? On Windows Phone 8.1 On iOS On Android
  • Tip of the Day: Replacing a disk

    Today’s Tip… Over the last couple of days I’ve talked about the NumberOfColumns and NumberOfDataCopies for Storage spaces in Windows Server 2012 (and it works the same in 2012 R2). One last thing to take into account when adding disks is how to replace...
  • Tip of the Day: Number of Data Copies

    Today’s Tip… Yesterday I reviewed the NumberOfColumns in a storage space (aka virtual disk). We learned that to add space to an existing storage space, you needed to add a number of disks equal to the NumberofColumns. While this is true for both simple...
  • Tip of the Day: NumberOfColumns

    Today’s Tip… In Storage Spaces, there is a concept called NumberOfColumns. I have tried on a number of occasions to write about them in a quick, easy to understand format, but always I end up over doing it and confusing my audience. So I’m going to make...
  • Tip of the Day: Improvement in NTFS Deduplication

    Today’s Tip… In Windows Server 2012, NTFS deduplication was introduced. In Windows Server 2012 R2 we made some improvements. I submitted a tip a while back about how to use the new Expand-DedupFile cmdlet to re-inflate a deduplicated file. But there is...
  • Tip of the Day: Putting OneDrive on Windows Server 2012 R2

    Today’s Tip… Recently I’ve needed to connect a Windows Server 2012 R2 system to my Microsoft OneDrive (not the OneDrive Pro). I went around in circles for a little while and then I just installed it from the Windows Essentials download. http://windows...
  • (SQL) Tip of the Day: SQL 2014 Smart Backup

    Today’s (SQL) Tip… SQL Server Managed Backup (also known as Smart Backup) to Windows Azure manages and automates SQL Server backups to the Windows Azure Blob storage service. The backup strategy used by SQL Server Managed Backup to Windows Azure is based...
  • (SQL) Tip of the Day: SQL 2014 In-Memory OLTP

    Today’s (SQL) Tip… In-Memory OLTP is a new feature introduced in SQL Server 2014. It allows you to store tables (up to 250 GB) wholly in memory for faster read and write access of the data. From the article: “To use In-Memory OLTP, you define a heavily...
  • (SQL) Tip of the Day: SQL Azure Database Firewall

    The firewall in SQL Azure is an area that comes up in support calls often. Most of the issues could be resolved by reading this article once through http://msdn.microsoft.com/en-us/library/azure/ee621782.aspx . What you need to know: You can’t access...
  • (SQL) Tip of the Day: Transaction Log Limits in SQL Azure

    Today’s (SQL) Tip… This is a common issue I run into on a near daily basis. You have a very large table and you notice your performance is degrading, the next step is to rebuild your indexes to make sure they are not fragmented. After letting the rebuild...
  • Tip of the Day: Disk Usage

    I probably could have made a career just on explaining disk usage to people. And while I did do a blog entry on the subject for AskCore , some of that information is aging out. The NTdebugging Blog just released part 3 of their series on NTFS Misreports...
  • WIMBoot Service

    Today’s Tip… Over the last couple of days I have been sending out tips about WIMBoot. Today I will be building on that to talk about WOF. WOF.SYS is a file system driver that makes all the WIMBoot magic happen. It intercepts access to the Windows files...
  • Tip of the Day: WIMBoot Limitations

    Today’s Tip… Yesterday I sent out a tip about WIMBoot. Today I’d like to add some information about its limitations. Can only be used on Windows 8.1 + 8.1 Update. No server versions. I actually mentioned this yesterday, but WIMBoot is available only for...
  • Tip of the Day: WIMBoot

    Today’s Tip… The Windows 8.1 Update that released in spring has a new functionality called WIMBoot. This is a method of saving space used by Windows by placing system files on compressed WIM files. These WIM files are placed in a new partition which replaces...
  • Tip of the Day: Sysinternals updates

    Last year I did a tip about updates that were done to some of my favorite SysInternals tools. There have been a number of updates since then. Some tools have been updated a few times. Autoruns v11.70 : Autoruns is a utility for enumerating and disabling...