Sites anglophones


New Versions of SSMS and SSDT Available

Publié le 16 novembre 2016 sur sqlblog.com
 

It’s Release Day! 🙂 New versions of SQL Server Data Tools (SSDT) are available here . SSDT 16.5 and 17.0 (RC1) are available. Also available are Data-Tier Application Framework (DacFx) versions 16.5 and 17.0 (RC1). New versions of SQL Server Man …

SQL Server vNext Evaluation Edition Now Available

Publié le 16 novembre 2016 sur sqlblog.com
 

You can download SQL Server vNext Evaluation Edition here. Today! :{>…(read more)

SQL Server 2016 SP1 shocks the world!!!

Publié le 16 novembre 2016 sur sqlblog.com
 

The entire World has been shocked today! We have never expected to see something like this. Go, grab SQL Server 2016 SP1 and you get all those: (picture from SQL Server Release Services page) Holly Molly!!!! Now in SQL Server 2016 Express you have (for …

SQL Server 2016 Service Pack 1 and SQL Server 2016 RTM CU3

Publié le 16 novembre 2016 sur sqlskills.com - glen berry
 

Microsoft has released SQL Server 2016 RTM CU3 (Build 13.0.2186.6), with 31 fixes in the public fix list. They have also released SQL Server 2016 Service Pack 1 (Build 13.0.4001.0). As they previously did for SQL Server 2014 SP2, Microsoft has managed …

Major Changes for SQL Server 2016 Standard Edition

Publié le 16 novembre 2016 sur sqlskills.com - glen berry
 

At today’s Connect() event, Microsoft announced some pretty major changes for SQL Server 2016 Standard Edition, which are implemented in SQL Server 2016 Service Pack 1 (which was also released today). Many very useful SQL Server features that wer …

SQL Server 2016 Standard Edition Now Has Many Enterprise Edition Features.

Publié le 16 novembre 2016 sur brentozar.com
 

Starting with today’s release of SQL Server 2016 Service Pack 1, Standard Edition now has a lot more of the features of Enterprise Edition. Here’s the list from Microsoft’s announcement post: Performance features – in-memor …

SQL Authority News – Download SQL Server 2016 Service Pack 1 (SP1)

Publié le 16 novembre 2016 sur journey to sqlauthority
 

Microsoft has earlier released SQL Server 2016 Service Pack 1 (SP1). This particular SP1 is one of the kind service pack and I will say it is a milestone move by Microsoft. Now with this SQL Server 2016 Service Pack 1, Standard Edition will have many o …

SQL Server 2016 SP1 is now Available

Publié le 16 novembre 2016 sur sqlblog.com
 

  Some big news today in the world of SQL Server and Visual Studio announced at Connect.  One of the announcements that will spark the interest of most of the people here on this blog is that SP1 for SQL Server 2016 is available for download …

Why Is This Query Sometimes Fast and Sometimes Slow?

Publié le 16 novembre 2016 sur brentozar.com
 

You swear you didn’t change anything, but all of a sudden the SQL Server is going doggone slow. What happened? Parameter sniffing might be the problem, and to explain it, let’s see how it works. I’m going to use the StackOverflow data …

Using Power BI Desktop to Visualize SQL Server Metadata

Publié le 16 novembre 2016 sur simple-talk.com
 

Microsoft’s Power BI Desktop provides a powerful tool for creating visualizations based on data from SQL Server and other sources. Importing SQL Server data into Power BI Desktop is a simple, straightforward process, and once you have the data yo …

Stairway to U-SQL Level 11: Stored Procedures

Publié le 16 novembre 2016 sur sqlservercentral.com
 

To finish off our look at the core database objects, we inspect how the venerable stored procedure works in U-SQL.

Logical Query Processing Part 8 : SELECT and ORDER BY

Publié le 16 novembre 2016 sur sqlmag.com
 

Logical query processing defines the conceptual interpretation of queries. A good understanding of this topic is key to writing correct and robust queries. read more

SQL SERVER – Unable to Bring Resource Online – Error – Could Not Find Any IP Address that this SQL Server Instance Depends Upon

Publié le 16 novembre 2016 sur journey to sqlauthority
 

When it rains, it pours. In the last few days last few contacts from my customers were for cluster related issues. Once again, SQL Server resource was not coming online in failover cluster manager. I asked them to check if ERRORLOG is being generated a …

Updated First Responder Kit: sp_Blitz, sp_BlitzCache, sp_BlitzIndex

Publié le 15 novembre 2016 sur brentozar.com
 

These improvements go great with cranberries. The food, not the b – actually, they go pretty well with the band, too. sp_Blitz Improvements #568 – @RichBenner added a check for the default parallelism settings sp_BlitzCache Improvements by …

Stupid Things I’ve Done With SQL

Publié le 15 novembre 2016 sur brentozar.com
 

I Always Enjoy Reminiscing And that header is a lie. I do enjoy thinking about stuff I used to have to do at work, because I don’t have to do it anymore. While we mostly gripe about the on-call stuff, the late night maintenance windows, etc., we …


Pages :