Sites anglophones


Historical Stock Prices and Volumes from Python to a CSV File

Publié le 5 janvier 2018 sur simple-talk.com
 

Python’s rich web connectivity capabilities offer a convenient way to collect data from the Internet, and its ability to write csv files provide a medium for sharing collected data. This article focuses on enabling you to output end-of-day ticker …

Building a Custom Blocked Process Report

Publié le 5 janvier 2018 sur simple-talk.com
 

The blocked process report was introduced with SQL Server 2005 and it hasn’t changed much since then. From one SQL Server version/edition to another, it helps us troubleshoot blocking by generating an XML document which describes who the blocker …

Questions about Data Masking That You Were Too Shy to Ask

Publié le 5 janvier 2018 sur sqlservercentral.com
 

The General Data Protection Regulation (GDPR) will be in effect in May of 2018. Data masking is one technique that can help your organization comply with this and other regulations. William Brewer answers those questions about data masking that you wer …

Critical SQL Server Patches for Meltdown and Spectre

Publié le 5 janvier 2018 sur sqlservercentral.com
 

Everyone needs to learn about these hardware bugs and apply patches as soon as possible.

SQL SERVER – Error: 17142 – SQL Server Service has Been Paused. No New Connections Will be Allowed

Publié le 5 janvier 2018 sur journey to sqlauthority
 

Recently I was looking around in my virtual machine to find a topic to blog. Within a few minutes, I was having an idea. In this blog we would talk about an interesting feature “Pause SQL Server”. As stated via official Microsoft documentat …

Microsoft SQL Server Updates for Meltdown and Spectre Exploits

Publié le 4 janvier 2018 sur sqlskills.com - glen berry
 

Over the last couple of days, you have probably heard quite a bit of chatter and speculation about some newly disclosed ways to attack various processors. The initial reports were that only Intel processors were affected, but some sources indicate that …

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.


Pages :