Sites anglophones


Using Microsoft DiskSpd to Test Your Storage Subsystem

Publié le 20 août 2015 sur sqlservercentral.com
 

Glenn Berry gives a thorough guide on using DiskSpd, a command-line tool that measures the performance characteristics of your storage subsystem.

Database Documentation Survey

Publié le 20 août 2015 sur sqlservercentral.com
 

Documentation often gets left behind in software development, perhaps even more so when it comes to developing the database schema. How do you keep yours up-to-date? Do you even think you should?

SQL SERVER – Rewriting Database History – Notes from the Field #094

Publié le 20 août 2015 sur journey to sqlauthority
 

[Note from Pinal]: This is a 94th episode of Notes from the Field series. When I read the title of this article – I was extremely intrigued with it – Rewriting Database History! When I was a kid, history was my favorite subject and til …

Are You Ready For Power BI?

Publié le 19 août 2015 sur sqlmag.com
 

Microsoft has positioned Power BI to be the industry-leading tool for simple self-service desktop data mashups but it has great heritage of serious business analytics.  I’ve had numerous conversations lately with new consulting clients; both …

Looking forward to Containers

Publié le 19 août 2015 sur sqlmag.com
 

Virtualization has long been a staple when it comes to computing. In essence, virtualization is really just the use of abstraction to make things either easier to manage or more fault-tolerant. Disks, for example, have long been virtualized in the sens …

How Do You Manage DBAs? Part 2: Training Budgets

Publié le 19 août 2015 sur brentozar.com
 

Your DBA wants to get better at what they do, but … they don’t know exactly what it is they do, or how to get the business to pay for it. Here’s how. My I Need to Learn List – man, where do I even begin – by Luis Lle …

Conferences and Seminars 2015 Q3 and Q4

Publié le 19 août 2015 sur sqlblog.com
 

I am finishing my list of conferences and seminars I am attending in the second half of the year 2015. Here is my list. Kulendayz 2015 – September 4th-5th. Although I will have huge problems to get there on time, I would never like to miss it. I …

Live Query Statistics in SQL Server 2016

Publié le 19 août 2015 sur sqlservercentral.com
 

SQL Server 2016, which at the time of writing is in preview release CTP 2.1, has a great new feature called Live Query Statistics. In this article, Koen Verbeeck introduces the new feature which allows you to view a live execution plan of an active que …

Powershell Tool Time: The Tool Framework

Publié le 19 août 2015 sur sqlservercentral.com
 

Start learning Powershell (PoSh) for SQL Server and improve your ability to write utilities that will make your job easier.

SQL SERVER – Login failed for user . Reason: Token-based server access validation failed with an infrastructure error

Publié le 19 août 2015 sur journey to sqlauthority
 

This is one of the most common error searched on my blog search (http://search.sqlauthority.com) and lately I realized that I have not written any blog about the cause of such error and fixing that. If you ever talk to an SQL Expert about login failed …

SQL Server 2014 SP1 Cumulative Update 2

Publié le 18 août 2015 sur sqlskills.com - glen berry
 

On August 17, 2015, Microsoft released SQL Server 2014 SP1 Cumulative Update 2, which is Build 12.0.4422. This CU has 44 hotfixes in the public fix list, which is a relatively high number. This shows that Microsoft has been busy fixing important SQL Se …

Performance Benefits of Unique Indexes

Publié le 18 août 2015 sur brentozar.com
 

sql server loves unique indexes Why? Because it’s lazy. Just like you. If you had to spend all day flipping pages around, you’d probably be even lazier. Thank Codd someone figured out how to make a computer do it. There’s some code be …

DAX Formatter now supports Power BI Desktop and Excel 2016 #dax #powerbi

Publié le 18 août 2015 sur sqlblog.com
 

If you use DAX, you should try DAX Formatter. Now it supports all the new functions introduced in Power BI Desktop and in Excel 2016. There are more than 70 new functions, even if half of them corresponds to Excel functions with the same name (see the …

Getting the Measure of Your Application

Publié le 18 août 2015 sur sqlservercentral.com
 

The idea of ‘instrumenting’ an application often seems to puzzle application developers. Modern IDEs are so full of code-tracers, debuggers and profilers that developers seem to resent the idea that applications should be designed and devel …

Connect to Salesforce Data as a Linked Server

Publié le 18 août 2015 sur sqlservercentral.com
 

Use the TDS Remoting feature of the ODBC Driver to set up a linked server for Salesforce data.


Pages :