Sites anglophones


SQL SERVER 2019 – Supports Compatibility Level from 2008 to 2019

Publié le 13 novembre 2019 sur journey to sqlauthority
 

Earlier last week SQL SERVER 2019 is Released. It has been an amazing experience to download and work with this new version. As I have been working for almost 20 years with SQL Server, I want SQL Server to be robust and stable, while performing better …

Introduction to DevOps: 10 Guidelines for Implementing DevOps

Publié le 12 novembre 2019 sur simple-talk.com
 

The series so far: Introduction to DevOps: The Evolving World of Application Delivery Introduction to DevOps: The Application Delivery Pipeline Introduction to DevOps: DevOps and the Database Introduction to DevOps: Security, Privacy, and Compliance In …

Windows 10 Version 1909 Available

Publié le 12 novembre 2019 sur sqlskills.com - glen berry
 

Microsoft has started making Windows 10, version 1909 generally available through Windows Update as an optional update, as you can see in Figure 1. This just started happening on November 12. I have already seen it on multiple systems with both AMD and …

Query Store Options in SSMS 18.4

Publié le 12 novembre 2019 sur SQLSkills.com - Erin Stellato
 

Last week the SQL Server Tools team released a new version of Management Studio, 18.4, and it dropped in the middle of my Query Store full day pre-con on Monday. Those two are related. There were some changes in SSMS 18.4 specific to Query Store, and f …

Announcing a New Live Online Class: How I Use the First Responder Kit

Publié le 12 novembre 2019 sur brentozar.com
 

During the hands-on labs for my Mastering classes, when I’m answering an attendee question, this kind of thing happens a lot: Attendee: “How would I find the query causing that missing index recommendation?” Me: “Oh, good questi …

SQL SERVER – 5 Resources from SQLPASS 2019 – Seattle

Publié le 12 novembre 2019 sur journey to sqlauthority
 

Earliest this week, I presented at SQLPASS, Seattle. It has been my 10th SQLPASS and I am very excited about it. I presented a session on Query Optimizer. In this blog post, we will see 5 important resources related to my session at SQLPASS 2019.  …

Take the 2020 State of Database DevOps Survey – win a new iPad

Publié le 12 novembre 2019 sur sqlservercentral.com
 

The post Take the 2020 State of Database DevOps Survey – win a new iPad appeared first on SQLServerCentral.

ASP.NET Core with GitOps: Dockerizing an API on AWS EC2

Publié le 12 novembre 2019 sur sqlservercentral.com
 

The post ASP.NET Core with GitOps: Dockerizing an API on AWS EC2 appeared first on SQLServerCentral.

ASCII Text Dump

Publié le 12 novembre 2019 sur sqlservercentral.com
 

Introduction Recently, I had the task of analyzing a varchar field for special characters. The field contained text entered by the user with a standard US keyboard; however, the proprietary software was breaking up the text and delimiting it with chara …

How to Think Like the SQL Server Engine: Included Columns Aren’t Free.

Publié le 11 novembre 2019 sur brentozar.com
 

In our last cliffhanger episode, I said that if we ran this query:UPDATE dbo.Users SET Age = Age + 1 WHERE Id = 643; And we had this index:CREATE INDEX IX_LastAccessDate_Id_DisplayName_Age ON dbo.Users(LastAccessDate, Id, DisplayName, Age); Then we wou …

SQL SERVER – Error 17182: Unable to Initialize SSL Support. The Client and Server Cannot Communicate, Because They do Not Possess a Common Algorithm

Publié le 11 novembre 2019 sur journey to sqlauthority
 

One of my existing clients contacted me to provide assistance in an issue where they were not able to install SQL Server 2014. In this blog, we would learn about fixing error “Unable to Initialize SSL Support. The client and server cannot communi …

Compare SQL Server Results of Two Queries

Publié le 11 novembre 2019 sur sqlservercentral.com
 

The post Compare SQL Server Results of Two Queries appeared first on SQLServerCentral.

Parameter pain

Publié le 11 novembre 2019 sur sqlservercentral.com
 

A forum question came up a few days ago regarding an abnormally large procedural cache. In an attempt to help out, I threw together a few ideas (some wrong, some right) and started looking at the types of query that were in the cache. A lot of the quer …

Why you should include the database in your 2020 IT strategy

Publié le 11 novembre 2019 sur sqlservercentral.com
 

The post Why you should include the database in your 2020 IT strategy appeared first on SQLServerCentral.

How to Write INNER JOIN Which is Actually CROSS JOIN? – Interview Question of the Week #250

Publié le 10 novembre 2019 sur journey to sqlauthority
 

Question: How to Write INNER JOIN Which is Actually CROSS JOIN?Answer: Experienced this question another day while working with a client on Comprehensive Database Performance Health Check. I noticed that they are writing all the Inner Join incorrectly. …


Pages :