Sites anglophones


Index Maintenance Madness

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

When we look at a new server, we check out their database maintenance jobs, making sure their server is in a safe place before we dig into their pain points. We verify if their backups and DBCC CHECKDB jobs can meet their RPO/RTO goals. We also check o …

First Responder Kit Release: Treating Object References Like Object Instances, Man

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

Object reference not set to an instance of an object. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1281 We’ve lowered the priority of Query Store being disabled. It’s just not as important as the …

Introducing the updated HTML comparison report in SQL Compare 13.1

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

In SQL Compare 13.1, Redgate have updated the interactive HTML comparison report type, providing simpler cleaner reports that focus on the differences between the compared databases. This blog post looks at the details of what’s new.

Keeping tables online during loading with schema swapping using SSIS

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

In this article, we discuss how schema swapping method can be used to keep tables online during the load process.

SQL SERVER – Msg 3743: The Database is Enabled for Database Mirroring. Database Mirroring Must be Removed Before you Drop the Database

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

One of my clients contacted me for quick assistance. They had Database Mirroring configured for a database. Due to some unknown issue their database mirroring went for a toss. Their end goal was to drop the database so that they can configure database …

Gartner Says Hire Programmers to Your Infrastructure and Ops Team

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

As traditional enterprises increasingly behave like platform companies, their IT and ops teams should change accordingly.

Savill's FAQs: How to Patch a Container Image

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

Three times a week, John Savill tackles your most pressing IT questions. Today, he explains patching Container Images, the size of Nano Server in Version 1709, and Project Honolulu Communications with servers.

SQL Server Missing Indexes Feature and Trace Flag 2392

Publié le 4 décembre 2017 sur sqlskills.com - glen berry
 

Background Since the SQL Server 2005 release, SQL Server has had the default ability to collect metrics about what the query optimizer thinks are “missing” row store indexes, i.e. indexes that the query optimizer thinks would reduce the cos …

AWS Launches Cloud9 Integrated Developer Environment

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

Cloud9, which AWS acquired in 2016, is tightly integrated with a wide range of AWS services to allow users to write their code in the cloud.

Using Delivery Reports in Microsoft Exchange Server 2016

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

How to use the delivery report feature in Microsoft Exchange Server 2016.

Researchers Combat Gender and Racial Bias in Artificial Intelligence

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

Machine learning, image recognition and other AI tools have big blind spots that particularly effect women and minorities.

PASS SQL Saturday #687 Slovenia 2017 Sponsors Showcase

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

Please take a minute and check this brief introduction of our wonderful gold, silver, and bronze sponsors. Comtrade is a dynamic and well established technology group, with a 25-year track record of innovation and steady development of some of the worl …

A day in the life of a developer with SQL Prompt

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

There is a lot more to SQL Prompt than IntelliSense and code completion. Tony Davis takes a developer’s eye view of its features, as they slot into a typical day of database development work, covering Prompt’s snippets, Actions, custom code styling, sa …

Is This Database Being Used?

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

Can we delete this database, or is someone still using it?

SQL in the City Streamed – Virtual Event on December 13 2017

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

Just like everyone, I love free quality education. However, the biggest challenge we see in the technology world is that even though we have free education available, after a while the relevance of the education is limited. Technology field is continuo …


Pages :