Sites anglophones


SQL SERVER – Becoming a More Effective DAX Developer with DAX Studio – Notes from the Field #134

Publié le 28 juillet 2016 sur journey to sqlauthority
 

[Note from Pinal]: This is a new episode of Notes from the Field series. I personally have no problem accepting that I do not know many topics. One of the such topics is DAX Studio. I always wanted to learn more and I finally got the opportunity t …

Where Do Missing Index Requests Come From?

Publié le 27 juillet 2016 sur brentozar.com
 

Be honest, here You don’t care about most indexing problems. Duplicates, Borderline Duplicates, Unused, Wide, Non-aligned Partitions… All you’re here for are the Missing Indexes. Wham, bam, your query finishes in less than a second, …

Stairway to U-SQL Level 5: Databases and Tables in Azure Data Lakes with U-SQL

Publié le 27 juillet 2016 sur sqlservercentral.com
 

A guide to using databases, schemas and tables in Azure Data Lakes, using (of course!) U-SQL.

Temporal Data Part 2 – Creating and Deleting System-Versioned Tables

Publié le 27 juillet 2016 sur sqlservercentral.com
 

Greg Larsen expands on his topic of how to modify an existing table to take advantage of the new temporal data feature in SQL Server 2016. In this article he shows you how to create and deleted system-versioned tables and the associated history tempora …

SQL SERVER 2016 – Learn Installation of SQL Server 2016 in 2 Minutes Video

Publié le 27 juillet 2016 sur journey to sqlauthority
 

Every time when new SQL Server version arrives, lots of people want to install it, however the biggest hesitance is the fear of unknown. Lots of people do not try out new software because they are worried what would happen if the installation does not …

IsCloseEnough(): I Ain’t Afraid of No Float

Publié le 26 juillet 2016 sur sqlblog.com
 

Friends, in this year of the Ghostbusters revival, I would like to talk about some paranormal phenomena: floating point value migration. The problem statement here is simple: We have a large collection of numbers in one system We copy those numbers to …

SQL Server 2016 Cumulative Update 1

Publié le 26 juillet 2016 sur sqlblog.com
 

Microsoft has released the Cumulative Update 1 for SQL Server 2016 (RTM):KB 3164674 Download Build number: 13.0.2149.0 Enjoy!

Leveraging Windows Server 2016 with SQL Server 2016

Publié le 26 juillet 2016 sur sqlmag.com
 

Windows Server 2016 is expected to be officially released at the September Ignite 2016 conference in Atlanta with appearance on the price list on October 1st. SQL Server has always had tight integration with Windows Server, and that is definitely the c …

Logging Activity Using sp_WhoIsActive – Take 2

Publié le 26 juillet 2016 sur brentozar.com
 

We’ve already covered how to log activity using sp_WhoIsActive, but I wanted to share how I’ve seen it done in the wild. The difference between the two methods is that this version logs everything to the same table and is for continuous …

Leverage INTERSECT to apply relationships in DAX

Publié le 26 juillet 2016 sur sqlblog.com
 

If you are used to virtual relationships in DAX (see Handling Different Granularities in DAX), you probably use the following pattern relatively often: [Filtered Measure] := CALCULATE (     <target_measure>,     FILT …

Azure SQL Limitations compared with a SQL Server Enterprise

Publié le 26 juillet 2016 sur sqlservercentral.com
 

In this article, we will compare a traditional SQL Server Enterprise Edition with an Azure SQL Database and see the differences.

Redgate’s 2016 Roadmap

Publié le 26 juillet 2016 sur sqlservercentral.com
 

What do you get for your Support & Upgrades package? Read this blog post to learn about the new functionality and improvements Redgate is releasing this year. Find out more.

SQL Server 2016 Cumulative Update #1 Released

Publié le 26 juillet 2016 sur sqlmag.com
 

Microsoft has released the first update for SQL Server 2016 which fixes 192 issues. read more

SQL SERVER – System Stored Procedures I Use to Get Started

Publié le 26 juillet 2016 sur journey to sqlauthority
 

Call me an old school or whatever – there are certain things I believe in strongly. I have a working style and these in my opinion have evolved over the years. I keep innovating myself as I learn on my way, but there are few things I do that alwa …

SQL Server 2014 Service Pack 2

Publié le 25 juillet 2016 sur sqlblog.com
 

Microsoft has released the Service Pack 2 for SQL Server 2014: Microsoft SQL Server 2014 SP2  Microsoft SQL Server 2014 SP2 Express  Microsoft SQL Server 2014 SP2 Feature PackThese are the details of SQL Server 2014 SP2: It contains all fixes …


Pages :