Sites anglophones


New class: Immersion Event on Azure SQL Database and Azure VMs

Publié le 20 avril 2017 sur sqlskills.com - paul randall
 

We have a really cool new class debuting this October in Chicago: Immersion Event on Azure SQL Database and Azure VMs. It’s a 2-day class, taught by Tim Radney. Azure is getting more and more popular, and we’re seeing many cl …

SQL Server 2017–all sessions from Microsoft Data Amp are online! Complete list of links!!!

Publié le 20 avril 2017 sur sqlblog.com
 

Hello I have just gathered all sessions (deep dive ones) that you might have seen live on 4/19. Look how many sessions are there!!!! Security on Linux with Tommy Mullaney – http://bit.ly/2onopRi Build globally-scaled mobile apps in minutes with Kirill …

What’s new in SQL Server 2017 CTP 2.0 for Analysis Services

Publié le 19 avril 2017 sur sqlblog.com
 

Today is a great day. I have been able to take part in the #MSDataAmp conference. While listening to Scott Guthrie I found that SQL Server 2017 CTP 2.0 is available for download I like to way Microsoft changes the Analysis Services engine over the time …

Wanna speak at the PASS Summit? Here’s how.

Publié le 19 avril 2017 sur brentozar.com
 

The PASS Summit is the biggest SQL Server community event, and a lot of us speakers have “present at PASS” on their bucket list. Getting in is legendarily difficult because competition is fierce. Many sessions are submitted for ea …

Using and optimizing DirectQuery in #powerbi and #ssas #tabular

Publié le 19 avril 2017 sur sqlblog.com
 

More than one year ago, I and Alberto Ferrari started to work on DirectQuery, exploring the new implementation appeared in Analysis Services 2016 for the Tabular models, which uses the same engine of Power BI. The previous version of DirectQuery appear …

Package Parts – First Impressions

Publié le 19 avril 2017 sur sqlservercentral.com
 

This article gives an overview of some good and not-so-good features of SSIS package parts.

SQL SERVER – Msg 3035, Level 16 – Cannot Perform a Differential Backup for Database “SQLAuthority”, Because a Current Database Backup Does not Exist

Publié le 19 avril 2017 sur journey to sqlauthority
 

If we look at the error in the subject line, it is very clear that a full backup is needed so that the differential backup chain can be initiated. If this happens to a newly created database, then it makes sense and there is no need for me to write a b …

Speaking at the Nashville SQL Server User’s Group on April 28th.

Publié le 19 avril 2017 sur sqlblog.com
 

And they say you can’t go home again.. On the 28th of April I will be returning back to my old home of Nashville to speak at the Nashville SQL Server User’s Group. (And where I moved to was very near the home I lived in when I was in high school.) The …

SQL Server 2014 SP2 Cumulative Update 5

Publié le 18 avril 2017 sur sqlskills.com - glen berry
 

Microsoft has released SQL Server 2014 Service Pack 2 Cumulative Update 5, which is Build 12.0.5546.0. There are 24 hotfixes in the public fix list. In my opinion, you should be on the SP2 branch by now. If you have not made that move, you should be ma …

How to Join the SQL Server Community Chat in Slack

Publié le 18 avril 2017 sur brentozar.com
 

Just another day on Slack Slack is a team chat system where you can: Go to SQLslack.com to get a free instant invite, and then join Go to https://SQLcommunity.Slack.com, or download the Slack app Meet cool people and join their chat rooms Chat rooms at …

New Cumulative Updates for SQL Server 2014

Publié le 18 avril 2017 sur sqlblog.com
 

  Microsoft announced two new CU’s for SQL Server 2014 yesterday. Below are the links to the KB’s and some quick facts for each CU. Cumulative Update 12 for SQL Server 2014 SP1 SQL Server 2014 Service Pack 1 Cumulative Update #12 Quick …

Scaling out SSRS on SQL Server Standard Edition 

Publié le 18 avril 2017 sur sqlservercentral.com
 

The ability to scale out SSRS, so that multiple report server instances can access a single report server database, is an Enterprise Edition-only feature. So when Rodney Landrum was tasked with implementing a scale-out solution, with failover, for SSRS …

Working with Tables in Azure SQL Data Warehouse

Publié le 18 avril 2017 sur sqlservercentral.com
 

In this next installment of our series on Azure SQL Data Warehouse, we’ll look at tables and the options for how we decide to create them for optimum performance.

Moving from application automation to true DevOps by including the database

Publié le 18 avril 2017 sur sqlservercentral.com
 

Tom Austin talks about the challenges that arise from trying to include the database in your DevOps process. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to fi …

SQL SERVER – Login Failed. The Login is From an Untrusted Domain and Cannot be Used with Windows Authentication

Publié le 18 avril 2017 sur journey to sqlauthority
 

In SQL Server, there are error few messages which can be caused due to multiple reasons. One of the famous example is “Login Failed for User” error message. If you have seen this earlier, you would know that this message can come due to inc …


Pages :