Sites anglophones


Privacy Settings: The Good, The Bad, and The Ugly

Publié le 18 octobre 2015 sur sqlblog.com
 

I’ve spent more time than I’ve wanted today looking for and fiddling with privacy settings. Social media users can’t have privacy, but there are at least some things we can do to reduce annoyances from having an online presence. Targe …

New Dynamic Management Views in SQL Server 2016 Part 2: dm_exec_session_waits

Publié le 18 octobre 2015 sur sqlmag.com
 

SQL Server 2016 is rapidly approaching release and in this continuing series Tim Ford exposes some of the new Dynamic Management Objects available in the latest version of Microsoft’s flagship database platform. read more

Interview Question of the Week #041 – What is a Merge Join?

Publié le 18 octobre 2015 sur journey to sqlauthority
 

Question: What is a Merge Join? Answer: The Merge Join transformation provides an output that is generated by joining two sorted data sets using a FULL, LEFT, or INNER join. The Merge Join transformation requires that both inputs be sorted and tha …

SQL SERVER – Script Upgrade Mode on Failover – Why?

Publié le 17 octobre 2015 sur journey to sqlauthority
 

Troubleshooting Cluster related queries is always a challenge and every once in a while I get mails around these. One of my friend wrote email to me and it caught my attention and I took couple of days to explore and felt worth to share it here: <EM …

Datazen Mobile Dashboards with Analysis Services and Drill-through

Publié le 16 octobre 2015 sur sqlmag.com
 

Paul Turley Use Datazen with Analysis Services and MDX queries to create fast and effective mobile dashboard solutions. User drill-through actions to navigate to details and pass selections from one dashboard to another. read more

SQL Server Migration and Upgrade Checklist (video and eBook)

Publié le 16 octobre 2015 sur brentozar.com
 

What could go wrong?It’s time to upgrade your SQL Server! But do you know exactly what you need to do? We’ve got a checklist and video to help make your migration go smoothly. You’ll learn what you need to script and document from you …

Low priority locking wait types

Publié le 16 octobre 2015 sur sqlskills.com - paul randall
 

SQL Server 2014 (and Azure SQL Database V12) added some cool new functionality for online index operations to allow you to prevent long-term blocking because of the two blocking locks that online index operations require. At the start of any online ind …

SQL Solutions Group Marks 5th Anniversary with SQL FreeCon

Publié le 16 octobre 2015 sur sqlservercentral.com
 

To mark five years in business helping companies across the United States with their SQL Server needs, SQL Solutions Group will host a day of free SQL training Tuesday, Oct. 27, in Seattle.

Idle Connection Resiliency

Publié le 16 octobre 2015 sur sqlservercentral.com
 

Describes the idle connection resiliency feature, which allows ODBC and SqlClient data access applications to maintain their connections to SQL Server 2014 or an Azure SQL Database.

An Introduction to the SQLCMD Mode in SSMS (SQL Spackle)

Publié le 16 octobre 2015 sur sqlservercentral.com
 

Using SQLCMD Mode in SSMS is easy. This short piece will show you how to get started. Library of articles for Database Lifecycle ManagementDiscover a collection of articles covering important checkpoints on the journey of database lifecycle management …

The Milestone- Linchpin People – Notes from the Field #100

Publié le 16 octobre 2015 sur journey to sqlauthority
 

[Note from Pinal]: This is a 100th episode of Notes from the Field series. This is amazing and shows the true dedication. Almost two years ago, Team Linchpin and I discussed that we want to share something differegive nt. When we started none of u …

Geek City: Q&A

Publié le 15 octobre 2015 sur sqlblog.com
 

I’ve done it again… I’ve neglected my blog so long that my name has been removed from the list of SQLBlog contributors on the right-hand side of the main page. So I need to fix that. I have been accumulating a list of questions that …

Hardware rant 2015

Publié le 15 octobre 2015 sur sqlblog.com
 

It has been a while so I suppose it is time for another rant on hardware. There are two systems I would like: One is a laptop. The second is a server capable of demonstrating extreme IO performance, with the secondary objective of being small enough to …

What’s New in Master Data Services – SQL2016 CTP2.4(September) Release

Publié le 15 octobre 2015 sur sqlblog.com
 

SQL Server 2016 Community Technology Preview 2.4 is publicly released and the latest SQL Server bits can be found at http://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016 . MDS Excel Add-in can be found at : https://www.microsoft.com/en-us …

Announcing Brent’s SQLSaturday DC Pre-Con: Performance Tuning When You Can’t Fix the Queries

Publié le 15 octobre 2015 sur brentozar.com
 

Your users are frustrated because the app is too slow, but you can’t change the queries. Maybe it’s a third party app, or maybe you’re using generated code, or maybe you’re just not allowed to change it. Take heart – there …


Pages :