SQL Server KBs and Blogs

Quick access to blogs posts from SQL Server Support Team., Some of the new KBs published for SQL and SQL Content news

SQL Server KBs and Blogs

Featured
    No blog posts have yet been created.
  • Do we really need AAD DirSync?

    There has been some confusion regarding what is actually needed to use the Analysis Services Connector for Power BI. Originally there was a requirement that Azure Active Directory DirSync was required to get this to work. However, this was altered to...
  • Can we share items between Tenants?

    NOTE: Information listed here is good as of 3/6/2015 and is subject to change. There has been confusion with the new Power BI Public Preview and Sharing. Currently, the only item that can be shared is the Dashboard. People have asked if they can just...
  • Can I add a domain to my Tenant?

    I got a question regarding the ability to add a Domain to an existing O365 Tenant. From the customers perspective, they wanted to have users in their tenant that were from a different domain than their primary one. In the context of Power BI, you can...
  • What is a Tenant?

    I’ve received a lot of questions regarding confusion about what a Tenant is. This has been in the context of Power BI. Specifically with the new Public Preview and how a Tenant plays into that. So, I wanted to get something out there to try and explain...
  • AlwaysOn Availability Group Returns Failover Partner for Legacy Mirror Application Connectivity

    Availability Groups Simulate Database Mirroring Connection Behavior Given the following scenario, SQL Server will return the failover partner server name to a connection request: The availability group has a single secondary replica. The availability...
  • Does rebuild index update statistics?

    I recently did a talk to a group of SQL users.  Quite a few facts ended up surprising the audience.   I thought I’d share a few and wanted to start with index rebuild. If someone asks you the question “Does rebuild index update statistics...
  • Recommendations for Index Maintenance with AlwaysOn Availability Groups

    SYMPTOMS Consider the following scenario The database is part of AlwaysOn Availability Groups You run long and log-intensive transactions like Index maintenance/rebuilds You observe one or more of the following symptoms:...
  • How It Works: MAX DOP Level and Parallel Index Builds

    I have been working on an issue where rebuilding an index leads to additional fragmentation.   Using XEvents I debugged the page allocations and writes and was able to narrow in on the behavior. There are lots of factors to take into account...
  • Running SQL Server on Machines with More Than 8 CPUs per NUMA Node May Need Trace Flag 8048

    Applies To:   SQL 2008, 2008 R2, 2012 and 2014 releases Note :  The number of CPUs is the logical count, not sockets.   If more than 8 logical CPUs are presented this post may apply. The SQL Server developer can elect to partition...
  • Ability to disable Sign ups for the Free Power BI

    NOTE: Information listed here is good as of 2/18/2015 and is subject to change. If you are an Admin for an Office 365 Tenant, you may not want users to be able to sign up for the Power BI service without you knowing about it. This could be for users that...
  • Sqoop Job Performance Tuning in HDinsight (Hadoop)

    Overview Apache Sqoop is designed for efficiently transferring bulk data between Apache Hadoop and structured datastores such as relational databases. HDInsight is Hadoop cluster deployed in Microsoft Azure and it includes Sqoop. When transferring small...
  • A look at the Analysis Services Connector

    NOTE: Information listed here is good as of 2/17/2015 and is subject to change. The Analysis Services Connector is a new item with the Public Preview of Power BI. The idea behind this is that it allows you to stream live data to use with your reports...
  • Azure PowerShell 0.8.14 Released, fixes problems with pipelining HDInsight configuration cmdlets

    We recently pushed out the 0.8.14 release of Azure PowerShell . This release includes some updates to the following cmdlets to ensure that values passed in via the PowerShell pipeline, or via the -Config parameter, are maintained: Set-AzureHDInsightDefaultStorage...
  • Setting up Azure Active Directory with Office 365

    NOTE: Information listed here is good as of 2/6/2015 and is subject to change. You may be wondering why this is posted on the Power BI Support Blog. Azure Active Directory ties into Power BI when you want to use the Analysis Services Connector. The Analysis...
  • Problems When Using a Shared Default Storage Container with Multiple HDInsight Clusters

    We have seen several cases come in to Microsoft Support that ended up being caused by having multiple HDInsight clusters using the same Azure Blob Storage container for default storage. While we don't currently block you from creating clusters using...
  • Snapshot agent fails with Error: 241, Severity: 16, State: 1 (Conversion failed when converting date and/or time from character string)

    ISSUE Let’s say you are monitoring Replication Agent status and noticed that the Snapshot Agent has failed with the following error while generating a snapshot, particularly during creation of BCP files. Error: 241, Severity: 16, State: 1 Conversion failed...
  • How to perform an IT Admin Takeover with O365

    NOTE: Information listed here is good as of 2/6/2015 and is subject to change. This will look at the process to perform an IT Admin Takeover for an O365 Tenant. You may ask why you would need to do that. This relates to the Information Worker (IW) sign...
  • Power BI Sign Up Walkthrough (Public Preview)

    NOTE: This is preview material and is subject to change. Information listed here is good as of 2/6/2015. This is to show you how to sign up for the new Power BI service. This is in regards to the Free/Preview service. In order to start, we need to go...
  • “Setting up…” on Power BI Icon for O365 Grid after signing up (Public Preview)

    NOTE: This is preview material and is subject to change. Information listed here is good as of 2/5/2015. If you go to http://www.powerbi.com and sign up, you will get to the Public Preview. If from there you go to http://portal.office.com you may see...
  • Frequently used knobs to tune a busy SQL Server

    In calendar year 2014, the SQL Server escalation team had the opportunity to work on several interesting and challenging customers issues. One trend we noticed is that many customers were migrating from old versions of SQL Server running on lean hardware...
  • 1,000,000 Power BI Licenses

    This question has come up a few times regarding why you would be seeing 1,000,000 licenses for Power BI in your O365 Tenant. To show you what this looks like we can go to the O365 Admin portal, go to Billing and then Licenses . From a subscription standpoint...
  • Troubleshooting Memory Issues with Reporting Services

    We had a case where Reporting Services was crashing with the following error. Failed allocate pages: FAIL_PAGE_ALLOCATION 2 The number at the end can be different.  In the customer’s case it was a 1.  In my local repro it was a 2.  This...
  • SQL Server and SSDs – RDORR’s Learning Notes - Part 1

    I am very hesitant to post anything that I don’t have the full details on.  However, with SSD deployments moving so rapidly I thought it might be helpful to share some of my learning's to date. I make no claims of being an expert in this area...
  • #Error When Rendering Report

    Last week a case was brought to me where the customer was getting a #Error for a field within their report.  The field value was normally a number, but they wanted to change it to something like “1&1”.  That is when they would see the #Error...
  • Do I really need to use DTC Transactions?

    It is sometimes common practice to enable Distributed Transaction (DTC) behavior but it can be unnecessary, and adds unwanted overhead.   DTC has the ability to determine single phase vs two phase commit requirements.  A DTC transaction...