Sites anglophones


Discover how SQL Server can use Python to access any NoSQL engine

Publié le 26 octobre 2018 sur sqlblog.com
 

. Many companies these days keep their data assets in multiple data stores.  Many companies that I have worked at have used other database systems alongside SQL Server, such as PostgreSQL instances, Redis, Elasticsearch or Couchbase. There are sit …

My AWS Aurora Postgres instance is 100% CPU. What’s next?

Publié le 26 octobre 2018 sur sqlblog.com
 

I had to investigate today situation when my AWS Aurora PostgreSQL instance CPU was 100%.I have started to search for a root cause at the database statistic views level. There is a view pg_stat_activity which shows information related to the …

Filtered Indexes vs Parameterization (Again)

Publié le 26 octobre 2018 sur brentozar.com
 

At First I Was Like… This won’t work at all, because parameters are a known enemy of filtered indexes. But it turns out that some filtered indexes can be used for parameterized queries, whether they’re from stored procedures, dynamic …

Have your say on the future of data masking

Publié le 26 octobre 2018 sur sqlservercentral.com
 

Find out what Redgate have been doing with their data masking tool. Find out where they are heading next in terms of development and help them gain a deeper understanding of your requirements for the tool.

The Basics of Dynamic Data Masking

Publié le 26 octobre 2018 sur sqlservercentral.com
 

Learn the basics of how Dynamic Data Masking can be used to obfuscate data in SQL Server 2016+.

SQL Authroity News – Optimizing Lazy Spool – PASS Blog

Publié le 26 octobre 2018 sur journey to sqlauthority
 

I will be presenting a day-long pre-conference at SQLPASS on the topic – 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs and regular session as well. Lots of people are asking me what I will be covering …

New Intel Desktop Processor Families

Publié le 25 octobre 2018 sur sqlskills.com - glen berry
 

Intel formally announced its 9th generation Core mainstream desktop processors on October 8, 2018 at its Fall Launch Event in New York. So far, they have announced three members of this family. The prices below are the MSRP prices. Actual street prices …

Batch Mode For Row Store: Does It Fix Parameter Sniffing?

Publié le 25 octobre 2018 sur brentozar.com
 

Snorting The Future SQL Server 2019 introduced batch mode over row store, which allows for batch mode processing to kick in on queries when the optimizer deems it cost effective to do so, and also to open up row store queries to the possibility of Adap …

Spotting Unauthorized Configuration Settings in SQL Server

Publié le 25 octobre 2018 sur sqlservercentral.com
 

In this article, Phil Factor explains how to detect any changes in server or database configuration settings, using Extended Events, and a custom metric, in SQL Monitor. He’ll then refine the technique to report on unauthorized drift in the value …

Always On – Endpoint Ownership

Publié le 25 octobre 2018 sur sqlservercentral.com
 

Whoever creates an AlwaysOn group is, by default, the owner of the endpoint. This is generally not a problem…unless that person leaves the company and you need to delete the login.

SQL SERVER – Reporting Services Not Starting After Maintenance Window

Publié le 25 octobre 2018 sur journey to sqlauthority
 

This is the issue faced on my test server and I found something interesting. In this blog, we would learn about one of the reasons why SQL Server Reporting Services (SSRS) couldn’t start after regular maintenance. I stopped SQL related services w …

The 3rd edition of the ebook SQL Server Execution Plans

Publié le 24 octobre 2018 sur sqlblog.com
 

From Redgate website you can download (for free) the ebook SQL Server Execution Plans written by Grant Fritchey and technically reviewed by Hugo Kornelis.This ebook can not be miss in your digital library!Enjoy! 

SQL Server Diagnostic Information Queries for October 2018

Publié le 24 octobre 2018 sur sqlskills.com - glen berry
 

This month, I have just made some minor improvements to most of the query sets. I have a T-SQL script that you can use to check whether your instance of SQL Server has been patched to mitigate against the Spectre/Meltdown CPU vulnerability. This works …

Batch Mode For Row Store: What Does It Help With?

Publié le 24 octobre 2018 sur brentozar.com
 

SQL Server 2019 Introduces something pretty cool: the ability for row store indexes to be processed in batch mode. Batch mode is, of course, the preferred processing realm of column store indexes. If you’re still in the dark about column store, y …

Generate HTML Formatted Email of SQL Server Database Consistency Check Errors

Publié le 24 octobre 2018 sur sqlservercentral.com
 

In this tip we look at to create a SQL Server DBCC CHECKDB errors email formatted in an HTML table. This will report any errors for all of your databases on the server.


Pages :