Sites anglophones


SQL SERVER – DMV to Get Host Information – sys.dm_os_host_info

Publié le 20 janvier 2018 sur journey to sqlauthority
 

There was a time when SQL Server used to run on only Microsoft Windows. However, the time has changed, and SQL Server now runs on Linux as well. This is indeed a great move as I believe database such as SQL Server should be running on multiple platform …

SQL Server Cumulative Updates (January 2018)

Publié le 19 janvier 2018 sur sqlblog.com
 

Microsoft has released the following Cumulative Updates for SQL Server:Cumulative Update 3 for SQL Server 2017 RTMKB 4052987DownloadBuild number: 14.0.3015.40SQL Release Services Blog PostCumulative Update 7 for SQL Server 2016 SP1KB 4057119D …

SQL Server: Avoiding a Sort with Descending Order

Publié le 19 janvier 2018 sur sqlmag.com
 

In this month’s column I focus on queries that need to process data in descending order.

How Much Can One Row Change A Plan, Part 4

Publié le 19 janvier 2018 sur brentozar.com
 

Monte Carlo Or Bust In Part 3, I showed you how two queries with TOP clauses can produce wildly different plans. To figure some stuff out about why the plans changed, let’s focus on the Nested Loops Join plan. Why? Because when I force the Hash J …

A new home for my SQLBlog content…

Publié le 19 janvier 2018 sur sqlblog.com
 

I’ve moved my content over to sqlblog.org . Read more details……(read more)

How to identify blocking in SQL Server

Publié le 19 janvier 2018 sur sqlservercentral.com
 

Blocking happens when one connection from an application holds a lock and a second connection requires a conflicting lock. This forces the second connection to be blocked until the first connection completes.

Keeping track of history: SQL Compare and Temporal Tables

Publié le 19 janvier 2018 sur sqlservercentral.com
 

SQL Compare 13 introduces support for deploying changes to temporal tables, which were introduced in SQL Server 2016. This means that any changes made to the definition of a temporal table in a source database, including to the retention policy for tha …

Data Quality Components for SQL Server

Publié le 19 janvier 2018 sur sqlmag.com
 

Sponsored by: Melissa

SQL Server Intergration Services

Publié le 19 janvier 2018 sur sqlmag.com
 

Sponsored by: Melissa

SQL SERVER – How to Make SQL Server GDPR Compliance?

Publié le 19 janvier 2018 sur journey to sqlauthority
 

I am really not sure how many times I have been asked about GDPR Compliance in the recent months. You must bookmark this page and share with your organizations if you are doing business with European Union or firm based out of European Union. It is qui …

Checking Your SQL Server Instance for Spectre/Meltdown Patches

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

If you are running SQL Server 2008 through SQL Server 2017, you should be thinking about what you should be doing to protect your systems from the Meltdown and Spectre vulnerabilities. Microsoft has a number of KB articles that address this issue from …

How Much Can One Row Change A Plan, Part 3

Publié le 18 janvier 2018 sur brentozar.com
 

All The Rage We’ve asked how much one column and even one row can change a plan before. The doctor says I’m not allowed to read blog comments anymore on account of my blood pressure, but the AI I wrote in PowerShell assures me the …

Finding code smells using SQL Prompt: old-style join syntax

Publié le 18 janvier 2018 sur sqlservercentral.com
 

SQL Prompt implements a static code analysis rule which will check code automatically for occurrences of non-ANSI standard JOIN syntax – here’s how it works.

Formatted ASCII Results from a SELECT

Publié le 18 janvier 2018 sur sqlservercentral.com
 

Generate aligned output from SELECT statement for code comments using a simple stored procedure.

SQL SERVER – Activity Monitor – Active Expensive Queries

Publié le 18 janvier 2018 sur journey to sqlauthority
 

Recently during Comprehensive Database Performance Health Check, I had a fascinating conversation. SQL Server has introduced Activity Monitor many version earlier. I think everybody is now pretty familiar with this tool and use it frequently. …


Pages :