Sites anglophones

SQL Server 2014 RTM Cumulative Update 7 Available

Publié le 23 avril 2015 sur - glen berry

Microsoft has released SQL Server 2014 RTM Cumulative Update 7, which is Build 12.0.2495. This cumulative update has 41 public hot fixes, several of which look pretty significant. I have updated my recent blog post Performance and Stability Related Fix …

SQL Server 2014 Cumulative Update #7 is available!

Publié le 23 avril 2015 sur

Microsoft has released Cumulative Update #7 for SQL Server 2014. See this blog post for more information. KB Article: KB #3046038 41 fixes listed publicly at time of publication (47 total) Build number is 12.0.2495 Relevant for @@VERSION 12.0.2000 thro …

Are Index ‘Included’ Columns in Your Multi-Column Statistics?

Publié le 23 avril 2015 sur

Internals Cat populates the density vector When you create an index in SQL Server with multiple columns, behind the scenes it creates a related multi-column statistic for the index. This statistic gives SQL Server some information about the relationshi …

PASS Business Analytics Conference 2015: Day 2

Publié le 22 avril 2015 sur

The PASS Business Analytics Conference 2015 is for Data Analysts, Data Scientists and Data Engineers who work primarily within the Microsoft set of tools, whether locally or on Azure. Today was the end of the second and final data of the conference. It …

Geek City: Point in Time Recovery for Operations on Memory—Optimized Tables

Publié le 22 avril 2015 sur

In my class in Budapest last week, someone asked if point-in-time recovery was supported for transactions on memory-optimized tables. I couldn’t think of a reason why not, but I had never tried it. And just because there is not a technical inhibi …

PASS Business Analytics Conference 2015: Day 1

Publié le 22 avril 2015 sur

If you’re involved in the analysis of data as a data engineer, data analyst or data scientist and you’re using the tools from the Microsoft stack, chances are you are in Santa Clara California attending the 2015 PASS Business Analytics Conference. Just …

DAX measures in Power BI Designer – and new DAX syntax finally here

Publié le 22 avril 2015 sur

The last update of Power BI Designer allows you to create measures (not calculated columns yet). Download the new version of Power BI Designer and you will see the New Measure button. The editor is much better than anything you have seen in Excel 2010/ …

And Party and Alt Shift

Publié le 22 avril 2015 sur

This is a cool SSMS trick I picked up a while back Though not nearly as far back as I wish I had. It’s so cool I made a .gif of it in action. When you’re done putting your socks back on, I’ll tell you how it works. This .gif was broug …

Time Slots – An Essential Extension to Calendar Tables

Publié le 22 avril 2015 sur

After answering many forum entries from developers asking for help with dealing with SQL that involved time intervals and ranges, Dwain dreamed of a generalized tool that sets up time slots of various sorts without the need to experiment; that could do …

Performance and Stability Related Fixes in Post-SQL Server 2014 RTM Builds

Publié le 21 avril 2015 sur - glen berry

As of April 20, 2015, there have been seven Cumulative Updates (CU) for the RTM branch of SQL Server 2014. There have been a fairly high number of hotfixes in every one of these Cumulative Updates, as more people are using SQL Server 2014. If you are r …

Transaction IO Performance on Violin

Publié le 21 avril 2015 sur

Back in Feb, I went on a diatribe-rant against the standard SAN Vendor configuration practice. The Problem with Standard SAN Configuration IO Performance , article and accompanying post , showed IO performance metrics for a batch driven transaction pro …

Beware of the Native Microsoft NVMe Driver!

Publié le 21 avril 2015 sur - glen berry

Non-Volatile Memory Express (NVMe) is a specification for accessing solid-state drives (SSDs) attached through the PCI Express (PCIe) bus. It gives lower storage latency and much higher queue depths. Even though this technology is most relevant for ser …

How to Evaluate NoSQL Case Studies [Video]

Publié le 20 avril 2015 sur

Every now and then, one of our clients considers adopting an alternative database platform – sometimes NoSQL, sometimes a brand new relational database. They’ll ask for our help in evaluating the vendor’s solution. One of the best way …

Mobile BI with SQL Server Reporting Services

Publié le 20 avril 2015 sur

For users to get the information they need from mobile reports, we frequently have to tailor the way we design those reports to the characteristics of the target device. Adam Aspin demonstrates some of the ways that we can deliver easy-to-use Business …

Deploying and Optimizing SQL Server for Virtual Machines

Publié le 19 avril 2015 sur

This paper provides guidance to those who have or who are considering deploying SQL Server on a virtual machine and how to optimize SQL Server’s performance for key critical resource areas: CPU, memory, network, and disk (storage). read more

Pages :