Sites anglophones


DBAs and the ITIL Framework, Part II: Asset Management

Publié le 21 novembre 2017 sur sqlservercentral.com
 

See how the ITIL Framework’s Asset Management standards make the DBA’s job easier. Use the CMDB and DML to keep your data assets under tight control.

FAQs: Encryption With ExpressRoute; Understanding Which Capabilities Are Supported With ASR; Handling Files Downloaded From The Internet

Publié le 21 novembre 2017 sur sqlmag.com
 

Three times a week, John Savill tackles your most pressing IT questions.

CIA’s On-Prem Amazon Cloud Now Available to Other Agencies

Publié le 21 novembre 2017 sur sqlmag.com
 

Intelligence Community agencies with sub-Top Secret data secrecy classifications can now use the « air-gapped » cloud.

Researchers Discover Pentagon Intelligence Data on Open AWS S3 Buckets

Publié le 21 novembre 2017 sur sqlmag.com
 

Third-party government contractor left U.S. surveillance data on open AWS S3 buckets, researchers say

SQL SERVER – Error – Auto Close is Enabled. Only Databases with Auto Close Disabled can be Added to an Availability Group

Publié le 21 novembre 2017 sur journey to sqlauthority
 

As a part of my consulting job, I do work with clients who wanted to deploy AlwaysOn availability group. Sometimes there are some simple errors which are encountered, but new DBAs are not aware of such things. In this blog we would talk about one of su …

Summer 2018 classes in London open for registration

Publié le 20 novembre 2017 sur sqlskills.com - paul randall
 

Due to popular demand, we’re coming back to London in 2018 and I’ve just released our classes for registration! All classes have discounts for registering before the end of 2017! (details on the individual class web pages…) …

Security Sense: You Can Outsource the Work but Never the Risk

Publié le 20 novembre 2017 sur sqlmag.com
 

There have been many recent cases where organizations have suffered serious data breaches at the hands of third parties.

[Video] Office Hours 2017/11/15 (With Transcriptions)

Publié le 20 novembre 2017 sur brentozar.com
 

This week Brent, Erik, Richie, and Tara discuss Docker, writing to different servers in different locations, SAN Replication, reducing the size of a database, patching Availability Groups, getting rid of failover cluster instances, long-term backup sto …

Updated Stack Overflow Database Dump Importer v1.4

Publié le 20 novembre 2017 sur brentozar.com
 

The nice folks at Stack Overflow publish their entire data set (data included) in XML format. It’s tons of fun for demos, but you need a way to get it into a relational database. The Stack Overflow Data Dump Importer (SODDI) makes this …

The real origins of the Agile Manifesto

Publié le 20 novembre 2017 sur sqlservercentral.com
 

Many people think the Agile Manifesto was born in in February 2001, when 17 people met at the Snowbird ski resort in Utah. But there’s a problem, a big problem – in fact, one about the size of the USA’s first ever jet fighter. In this blog …

Importing Historical Stock Prices from Yahoo Finance into SQL Server

Publié le 20 novembre 2017 sur sqlservercentral.com
 

Rick Dobson demonstrate a clean end-to-end solution for importing historical stock ticker prices from Yahoo Finance into a SQL Server table using Python.

Automatic Plan Correction

Publié le 20 novembre 2017 sur sqlservercentral.com
 

SQL Server 2017 lets you solve parameter sniffing problems – Automatically!

SQL SERVER – Add Node Error – Rule “SQL Server Database Services Feature State” Failed

Publié le 20 novembre 2017 sur journey to sqlauthority
 

While deploying SQL Server 2016 cluster in my lab I ran into this problem when I was trying to add a second node to the SQL cluster. Let us learn about Add Node Error and how to solve it in this blog post. Rule “SQL Server Database Services featu …

How to Assign Multiple Variables in a Single T-SQL Query? – Interview Question of the Week #148

Publié le 19 novembre 2017 sur journey to sqlauthority
 

Question: How to Assign Multiple Variables in a Single T-SQL Query? Answer: I do remember answering this question many years ago, when it was newly introduced in SQL Server. It has been so long that I have forgotten that in which version of SQL Se …

How to Plan a Migration to AWS: The Cox Automotive Story

Publié le 19 novembre 2017 sur sqlmag.com
 

Sponsored by: AWS – Tuesday, 12/5/17 at 11 am PST/2 pm EST


Pages :