Sites anglophones


2017 Brought More Open Standards for DevOps

Publié le 26 décembre 2017 sur sqlmag.com
 

The trend towards open standards will not only make life easier for DevOps, they will cut IT costs as well.

Next Christmas, How About Some Cybersecurity?

Publié le 26 décembre 2017 sur sqlmag.com
 

An ITPro Today writer says she doesn’t need anything next Christmas, but it would be nice if she can hold on to what she already has.

Public Cloud Vendors Found Unlikely Partners in 2017

Publié le 26 décembre 2017 sur sqlmag.com
 

Public cloud vendors like AWS and Google partnered with data center juggernauts in 2017 to bring enterprises to the cloud.

Microsoft in 2017: Quantum Computing Led the Way

Publié le 26 décembre 2017 sur sqlmag.com
 

Starting with Microsoft Quantum Computing, then following with Artificial Intelligence and Machine Learning, the company continued to grow their ability to provide customers with the right data at the right time to increase productivity across all aspe …

Cybersecurity Strategy: Top Security Resolutions for 2018

Publié le 26 décembre 2017 sur sqlmag.com
 

As the new year approaches, several IT analysts give their top cybersecurity strategy tips and key tasks to target to protect your company’s IT assets.

Rethink Server Sizing

Publié le 26 décembre 2017 sur sqlblog.com
 

Standardizing on 2 and 4 sockets systems for servers has been an established practice going back to 1996. There were very good reasons for this, but it was so long ago that they have been forgotten. Yet the practice continues unquestioned, almost as a …

Validation, Verification, and Modification

Publié le 26 décembre 2017 sur simple-talk.com
 

Over the years, I’ve stressed that a schema should support validation and verification of its data, but I’ve never really given a good discussion of what those terms mean. I’d like to add another desirable property, modification, to t …

Female DBAs Make Less Money. Why?

Publié le 26 décembre 2017 sur brentozar.com
 

The 2018 Data Professional Salary Survey is open now, and you can look at the live responses as they come in. (To get that in Excel, click File, Download.) As of this writing (Dec 23), there’s already over 2,500 responses, so I’m going to t …

Azure DWH part 22: Dynamic Management Views

Publié le 26 décembre 2017 sur sqlservercentral.com
 

The DMV are very effective and important to administer ASDWH. In this article we will show some important DMVs.

SQL SERVER – How to Install New Sample Database WideWorldImportersDW.bak

Publié le 26 décembre 2017 sur journey to sqlauthority
 

Last year, I have written a blog to install sample database WideWorldImporters SQL SERVER 2016 – How to Import New Sample Database WideWorldImporters. Recently, while I was showing demo to a client, they informed that I don’t have …

Set Up of Windows 10 on New Devices With These Tips

Publié le 25 décembre 2017 sur sqlmag.com
 

If you received a new computer over the holidays, it will likely be running Microsoft’s Windows 10. Take some time to get things sorted out before you begin using your new device — and use our guidelines to set up your new device for optimum per …

Cascading Update and Delete for SQL Server 2017 Temporal Tables

Publié le 25 décembre 2017 sur sqlservercentral.com
 

Ameena Lalani looks at cascading updates and deletes when using temporal tables in SQL Server.

Support for static data added to Source Control for Oracle

Publié le 25 décembre 2017 sur sqlservercentral.com
 

With the speed of software development increasing, more and more companies and organizations are recognizing that version controlling code is becoming as important for databases as it is for applications. In recognition of this, Source Control for Orac …

SQL SERVER – Error: 17300 – SQL Server Was Unable to Run a New System Task

Publié le 25 décembre 2017 sur journey to sqlauthority
 

One of my clients was performing load tests on timesheet application. They noticed that application jobs are failing with below error message about running a new system task. TimesheetSaveFailed (24014) – A severe error occurred on the current co …

How to List All ColumnStore Index with Table Name in SQL Server? – Interview Question of the Week #153

Publié le 24 décembre 2017 sur journey to sqlauthority
 

Question: How to List All ColumnStore Index (CL Index) with Table Name in SQL Server? Answer: As ColumnStore Indexes are getting more and more popular, I now a days see lots of questions related to columnstore index. One of the most popular question, I …


Pages :