Sites anglophones


Cloudera Vs Hortonworks

Publié le 20 octobre 2015 sur sqlservercentral.com
 

A look at Haddop and the two main distributions: Cloudera Vs Hortonworks

SQL SERVER – Log Shipping Restore Job Error: The file is too recent to apply to the secondary database

Publié le 20 octobre 2015 sur journey to sqlauthority
 

If you are a DBA and handled Log-shipping as high availability solution, there are a number of common errors that come that you would over a period of time become pro on resolving. Here is one of the common error which you must have seen: Message 2015- …

Free SQL Server Training: Architecture, 2016, Metrics, Index Maintenance, and More

Publié le 19 octobre 2015 sur brentozar.com
 

No, we won’t teach you how to paddleboard, because we already forgot. Do you like to shake sticks? Because we’ve got more upcoming SQL Server webcasts than you can shake a stick at: Easy Architecture Design for HA and DR – Cluste …

What you should have read 🙂 during the weekend – weekly SQL Server blogs review part 4

Publié le 19 octobre 2015 sur sqlblog.com
 

Hello ! Here are my weekly reading and tips for you :).  Maybe you find something interesting there, too!!! Enjoy the Monday!   Author Title Link Michael Swart Don’t abandon your transactions http://bit.ly/1kjukEf Thomas LaRock Improve …

Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator

Publié le 19 octobre 2015 sur sqlservercentral.com
 

This paper provides an overview of the primary changes made to the cardinality estimator functionality by the Microsoft query processor team, covering how to enable and disable the new cardinality estimator behavior, and showing how to troubleshoot pla …

Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes

Publié le 19 octobre 2015 sur sqlservercentral.com
 

When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL’s rich metadata makes this very easy to automate in a robust fashion.

SQL SERVER – ColumnStore Frequently Asked Queries

Publié le 19 octobre 2015 sur journey to sqlauthority
 

This blog talks about troubleshooting scenarios in FAQ format when dealing with ColumnStore Indexes inside SQL Server. Use a combination of trace flags, query hints, performance counters, extended events discussed in various blogs to gather relevant da …

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.


Pages :