Sites anglophones


The Perils Of VSS Snaps

Publié le 4 janvier 2018 sur brentozar.com
 

So much, so often Ah, backups. Why are they so tough to get right? You start taking them, you find out you’re not taking enough of them, or that they’re not the right kind, or that you’re not using checksums or compression, or that yo …

SQL Server Patches for Meltdown and Spectre Attacks

Publié le 4 janvier 2018 sur brentozar.com
 

The Meltdown and Spectre attacks are newly announced ways of hacking CPUs. They affect both Windows and Linux. If you’re running under virtualization or cloud IaaS, any other running guest can try to leverage the attacks to compromise your unrela …

A Brief History of Data Analysis

Publié le 4 janvier 2018 sur sqlservercentral.com
 

Take a look at Data Analysis from ancient times to current days

If you hear these phrases, you might need Microsoft Visual Studio Team Services

Publié le 4 janvier 2018 sur sqlservercentral.com
 

There are so many features in Microsoft Visual Studio Team Services that it can be difficult to wrap your head around what all they do and if you’re utilizing the tool to its fullest potential.

SQL Saturday Nashville: I’m Speaking

Publié le 4 janvier 2018 sur sqlblog.com
 

Going home y’all. On January 13th, I will be speaking at the Nashville SQL Saturday. I moved from Nashville less than 1 year ago, and I always look forward to making a trip up (and not just for hot chicken at Big Shakes , though it does figure into it. …

SQL SERVER – Puzzle – Why Does UNION ALL Work but UNION Produces Error?

Publié le 4 janvier 2018 sur journey to sqlauthority
 

You already know what UNION and UNION ALL operators do. They combine datasets while UNION keeps the distinct data UNION ALL will retain all the data. You can read more about that over here: SQL SERVER – Difference Between Union vs. Union All …

Azure Data Lake Store library for Delphi

Publié le 3 janvier 2018 sur sqlblog.com
 

From Microsoft-Docs on GitHub: Azure Data Lake Store is an enterprise-wide hyper-scale repository for big data analytic workloads. Azure Data Lake enables you to capture data of any size, type, and ingestion speed in one single place for operational an …

Network Issue or THREADPOOL waits?

Publié le 3 janvier 2018 sur brentozar.com
 

I’ve had a handful of clients that were experiencing significant THREADPOOL waits. This isn’t a wait type that I had any knowledge of prior to joining Brent Ozar Unlimited. Looking back, I am pretty sure that a few servers that I’ve b …

The top 10 considerations when designing a data platform

Publié le 3 janvier 2018 sur sqlservercentral.com
 

Designing a data platform for a new product or service is a fascinating and exciting challenge. It’s also a daunting one.

How to Turn on Instant File Initialization

Publié le 3 janvier 2018 sur sqlservercentral.com
 

Not having instant file initialization turned on slows down the process of adding pages to your database, because prior to allocating the data pages to your database, SQL Server needs to zero out the newly allocated pages.

Stairway to MDX – Level 4: The Order() Function: Beyond Cube Hierarchies

Publié le 3 janvier 2018 sur sqlservercentral.com
 

Bill Pearson continues his examination of the versatile Order() function, focusing upon its use in providing dataset sorts that reach beyond dimensional hierarchies

SQL SERVER – Slow Filestream Data Cleanup. What Should We Do?

Publié le 3 janvier 2018 sur journey to sqlauthority
 

One of my clients reported an issue where they were running low on free disk space on the drive where they have file-stream files. They are one of a heavy user of the filestream feature as compared to any of my previous clients. As per their observatio …

Amazon, Salesforce Shifting Business Away From Oracle

Publié le 3 janvier 2018 sur sqlmag.com
 

Amazon.com Inc. and Salesforce.com Inc., two of Oracle Corp.’s biggest customers, are actively working to replace Oracle software running on crucial business systems with lower cost open-source database software.

NVIDIA Wants to Block Use of Cheaper Consumer GPUs in Data Center

Publié le 2 janvier 2018 sur sqlmag.com
 

A change in software license agreement has drawn angry comments online, accusing the company of trying to steer users of GPUs for AI applications toward the expensive, high-end Tesla product line.

How to Remove 'Open PowerShell' from Windows 10 Context Menu

Publié le 2 janvier 2018 sur sqlmag.com
 

You may not want or need easy access to PowerShell. So why not clean up your context menu a bit?


Pages :