Tip of the Day

Tiny amounts of knowledge for a fast paced world!

Tip of the Day

Posts
  • 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...
  • (SQL) Tip of the Day: Active Geo-Replication

    Today’s (SQL) Tip… GeoDR or Geo-Replication allows you to have an active replica of your database on a different logical server or different region all together. The article sums it up the best: The Active Geo-Replication feature of Microsoft Azure SQL...
  • (SQL) Tip of the Day: Point in Time Recovery

    Today’s (SQL) Tip… The new SQL Azure editions will back up your database for you. Microsoft Azure SQL Database has automatic backup enabled for all Basic, Standard, and Premium databases. The backup service creates periodic databases backups and transaction...
  • (SQL) Tip of the Day: Gathering SQL Execution Plans

    Today’s (SQL) Tip… Today we are going to look at some SQL Query Plans. The easiest way and best way to do this is through SQL Server Management Studio. Go to Query -> Include Actual Execution Plan (or just press Control-M) and the queries you run through...
  • (SQL) Tip of the Day: SQL Azure Resource Usage

    Today’s (SQL) Tip… Today we will go over how you can see the resources your database is using on SQL Azure. The query below will allow you to view the amount of CPU, IOPS (i/o per second), memory, sessions, and workers you are using. If you are using...
  • (SQL) Tip of the Day: Analyzing Wait Types

    Today’s (SQL) Tip… Today I would like to talk about sys.dm_db_wait_stats. This DMV lets you get the wait stats from your SQL Azure Database, and for those of you familiar with it, it is the replacement for sys.dm_os_wait_stats from on premise SQL Server...
  • (SQL) Tip of the Day: Gathering Missing Indexes

    Today’s (SQL) Tip… This week I would like to go through the first few steps I like to send customers to troubleshoot their performance issues in SQL Azure. First and foremost, the easiest win we have is to check out missing indexes. Indexes can have a...
  • Tip of the Day: Disable Windows Help Tips

    Today’s Tip… If, like me, you are at a point where you no longer want to see Windows help tips, they can be disabled via policy. Admin Templates ->Windows Components ->Edge UI Title: Disable help tips
  • Tip of the Day: Safe Mode

    Today’s Tip… We often want to boot into Safe mode to see if the issue is possibly due to a third party applications. On Windows 8.1, we have the option of “Advanced Startup” that would help us to go into Safe mode on the next reboot in an easy convenient...
  • Tip of the Day: Unmap and iSCSI

    Today’s Tip… Occasionally, I see questions on discussion aliases and think to myself that they might make good tips. This one pops up every now and then. Q. Does Microsoft’s inbox iSCSI target support UNMAP? A. The quick answer is no. Windows Server 2012...
  • Tip of the Day: More about User Agent String

    Today’s Tip… Yesterday I sent out a tip about using the emulation settings in Internet Explorer, specifically about the user agent string setting. As it turns out, every single request made to the web server contains this user agent string. So I fired...
  • Tip of the Day: Emulation in IE 11

    Today’s Tip… Recently I was introduced to the emulation settings in Internet Explorer. These can be found in the Developer Tools interface either selecting Developer Tools in IE’s Tools drop down menu or by simply pressing F12 on the keyboard. One of...
  • (Cloud)Tip of the Day: Oracle on Windows Generally Available

    Today’s (Cloud) Tip… Although Oracle (WebLogic and Oracle Database) running on Linux in Windows Azure has been supported by Oracle for a while now, there has also been a push to get WebLogic and Oracle Database running on Windows supported in Windows...
  • (Cloud) Tip of the Day: Mooncake is live!

    Today’s (Cloud) Tip…Mooncake is live! Mooncake is the platform for Office 365 in China, supporting 18,000 Office 365 tenants 141 enterprise and 3195 web direct customers live on the platform using 15,381 compute cores, 1.7PB storage, 3803 IaaS VMs and...
  • Tip of the Day: Tile Resizing

    Today’s Tip… One of the handy little changes we got in Windows 8.1 is the ability to have more tile sizes available to use. This provides just another way to organize your start screen.
  • Tip of the Day: New DISM Switch

    Today’s Tip… One of the issues my team runs into from time to time is how much space is used by the component store, located in the %windir%\WinSXS directory. The size of this directory is very misleading a number of the files within it are ‘hard linked...
  • Tip of the Day: Un-dedup'ing

    Today’s Tip… Question: On Windows Server 2012 or newer, if I have a NTFS deduplicated volume and need to ‘un-dedup’ a certain folder, how do I accomplish this? Answer: You can use the Expand-DedupFile cmdlet in Windows PowerShell. dir g:\folder1 | expand...
  • (SQL) Tip of the Day: Premium Databases and the Alter Database Command

    Today’s (SQL) Tip… Did you know that while the feature is in Preview, or Beta, the “ALTER DATABASE” command article does not list “Premium” as a valid edition for the Modify Edition field? http://msdn.microsoft.com/en-us/library/windowsazure/ff394109...
  • (SQL) Tip of the Day: Query Plan Analysis

    Today’s (SQL) Tip… As mentioned in previous tips, the majority of the Windows Azure SQL Database questions we see are related to performance in some way. Because SQL Server plans out every move it makes before it makes it, we can often gain considerable...
  • (SQL) Tip of the Day: Four phases of performance troubleshooting

    Today’s (SQL) Tip… There are four distinct phases to SQL performance troubleshooting. If you stick to these phases, you can resolve almost any performance issue. Phase 1: Identify the top resource bottleneck. There are only four hardware bottlenecks and...
  • (SQL) Tip of the Day: Connecting with Management Studio

    Today’s (SQL) Tip… Recently, I have seen several occasions where customers could not connect a tool such as Management Studio to their Azure databases. There are a variety of reasons that connectivity failures can occur, but here's an initial checklist...
  • Tip of the Day: SMB 1.0 now removable

    Today’s Tip… In Windows Server 2012 R2, the SMB 1.0 features can be removed. They are still installed by default in case you are still using SMB 1.0 in conjunction with older SMB clients, such as Windows XP or Windows Server 2003. But if such clients...
  • Tip of the Day: Using Out-GridView

    Today’s Tip… The Out-GridView is a new addition to Windows PowerShell 3.0. Actually it was in Windows PowerShell 2.0 as well. But you had to install .NET Framework 3.0 to get it working. Basically this command can be used to send the output of any other...
  • Tip of the Day: Securing Lync Meetings

    Today’s Tip… By default, Lync uses the same meeting ID for every Lync meeting you create. This means that if you send a meeting request to customer A and then later send a meeting request to customer B, it is possible that both customer A and B could...