Category: SQL Server Database

Few thoughts on the SQL Server 2014 launch event in San Francisco

I just finished watching the hosted customer even in San Francisco where the Microsoft CEO Satya Nadella, COO Kevin Turner, CVP of Data Platform Group Quentin Clark and the SQL Server Product Marketing GM Eron Kelly officially introduced the new release of the SQL Server 2014. In this post I am not going to give

Continue reading

Kerberos Configuration Manager for SQL Server

Anybody who has had to worry about implementing security in a SharePoint environment has at some point run into challenges with impersonating end users and passing their credentials all the way to the analysis services cube for authorization. The dreaded two hop challenges necessitated having to implement Kerberos authentication which has caused a lot of

Continue reading

SAP Hana vs Microsoft SQL Server, the war is on…

and the Germans are making the first move… I have written two posts about Hana vs. xVelocity (Part I and Part II) making the basic point that there is nothing truly visionary or revolutionary in SAP Hana from the technology perspective and that a customer can get all the benefits (or rather alleged benefits as

Continue reading

Microsoft makes big announcements at SQL PASS

I will have a more detailed write-up of everything later but still wanted to give a quick summary of the new announcements: Updateable Column store – Project Hekaton will be released in the next major release of SQL Server and will allow us create updateable clustered column store indexes. This is huge, 20-50 performance increases

Continue reading

Using AlwaysOn to offload read-only workloads

Microsoft has posted a white paper that discusses how to physically partition your hardware in order to optimize read-write vs read only workloads on your transactional system. Why is this important? Well, there are certain ERP vendors who claim that any access to their data outside of what they explicitly support (or certify) compromises their solution

Continue reading

Microsoft SQL Server 2012 Fast Track White Paper is now available

Microsoft has updated its excellent Fast Track ( Microsoft Data Warehouse reference architecture) white paper for latest versoin of SQL Server (2012).  Whether you decide to follow this architecture or not (and there are good reasons for and against it given your budget and objectives), you will find a wealth of great and useful information that will help you

Continue reading

Drillable charts in Mcrosoft Office 15

I believe that Microsoft has delivered a very solid release with SQL Server 2012.  I love MDS V2, I am giddy with excitement about columnstore indexes (still trying to hunt down any hints that would substantiate the claimed availability of this technology for Analysis Services), I think that PowerView will be a huge success, although

Continue reading

colummstore compression for analysis services

Microsoft is claiming that xVelocity technology will be available across SQL Server database engine, PowerPivot AND Analysis Services… This technology works great for the first two, however, I couldn’t find anything on column store for the Analysis Services…. This would be a huge new improvement for SSAS…