THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server 2012   (RSS)
Showing page 1 of 7 (70 total posts)
  • Fix performance issue of pivot tables with Tabular models

    If you use SSAS Tabular, this is a very important news! Microsoft released a very important update for Analysis Services 2012 that provides performance improvements to pivot tables connected to an Analysis Services Tabular model: it is SQL Server 2012 SP2 Cumulative Update 8. Microsoft discussed some of these improvements in this blog post: ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 22, 2015
  • White Paper on Analysis Services Tabular Large-scale Solution #ssas #tabular

    Since the first beta of Analysis Services 2012, I worked with many companies designing and implementing solutions based on Analysis Services Tabular. I am glad that Microsoft published a white paper about a case-study using one of these scenarios: An Analysis Services Case Study: Using Tabular Models in a Large-scale Commercial Solution. Alberto ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on June 5, 2014
  • Write DAX queries in Report Builder #ssrs #dax #ssas #tabular

    If you use Report Builder with Reporting Services, you can use DAX queries even if the editor for Analysis Services provider does not support DAX syntax. In fact, the DMX editor that you can use in Visual Studio editor of Reporting Services (see a previous post on that), is not available in Report Builder. However, as Sagar Salvi commented in ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 21, 2014
  • Amazingly Useful SQL Server Articles on SQLPerformance.com

    Me and Aaron Bertrand, SQL Sentry flagbearers.One of the things we've been working on at SQL Sentry is building up institutional knowledge for the SQL Server community. There are three main ways that we're doing that on-line:Hard-core tech articles on SQLPerformance.com, edited by long-time SQL Server MVP Aaron Bertrand ...
    Posted to Kevin Kline (Weblog) by KKline on March 3, 2014
  • One Preparation that makes SSMS Crash Dumps Easy to Survive

     Uh oh!So you're plugging along in SQL Server Management Studio (SSMS) when it suddenly goes belly up. Now you're staring at various dialog boxes telling you that SSMS crashed. Usually the first dialog box you get will ask you if you'd like to close OR the program. If you choose to close the program, you'll be presented with the opportunity ...
    Posted to Kevin Kline (Weblog) by KKline on February 10, 2014
  • Will you be at the PASS Summit?

     Don't forget about the cool services from SQL Sentry for Summiteers, like the free area shuttle and the printed area maps! Details are in a 5-part series by our CEO, Greg Gonzalez, at http://greg.blogs.sqlsentry.net/.  Are you coming to Charlotte next week for the PASS Summit?  Let's connect!  When ever it's open, ...
    Posted to Kevin Kline (Weblog) by KKline on October 11, 2013
  • Wait Statistics in Microsoft SQL Server

     (Originally appearing at http://kevinekline.com/2013/10/09/wait-statistics-in-sql-server/).When it comes to troubleshooting in relational databases, there's no better place to start than wait statistics.  In a nutshell, a wait statistic is an internal counter that tells you how long the database spent waiting for a particular ...
    Posted to Kevin Kline (Weblog) by KKline on October 9, 2013
  • Now Playing on SSWUG TV!

    Hi friends, I know a lot of you regularly read my blog either on my home page at KevinEKline.com, on SQLBlog.com, or one of the locations where it's syndicated. And you may also regularly take in my content on SQLSentry.TV or my monthly column on Database Trends & Applications magazine.   Click the ...
    Posted to Kevin Kline (Weblog) by KKline on September 10, 2013
  • Windows Azure and SQL Database News

    This morning Microsoft released some great updates to Windows Azure.  These new capabilities include:SQL Server AlwaysOn Support: General Availability support with Windows Azure Virtual Machines for High Availability and Disaster RecoveryNotification Hubs: General Availability Release of Windows Azure Notification Hubs (broadcast ...
    Posted to Kevin Kline (Weblog) by KKline on August 14, 2013
  • What's the Data Modeling Standard for Business Intelligence Systems?

    I had the good fortune to overhead some of my good friends and fellow MVPs discussing the process of data modeling for business intelligence systems.  So what are the industry standard approaches for modeling dimensional data modelling?The short answer is that Kimball's dimensional modeling is the most widely adopted standard for any sort of ...
    Posted to Kevin Kline (Weblog) by KKline on July 2, 2013
1 2 3 4 5 Next > ... Last »
Privacy Statement