Sites anglophones


SQL SERVER Management Studio – ALT + SHIFT Keys Trick to Select Vertical Text

Publié le 11 octobre 2019 sur journey to sqlauthority
 

Today we are going to see a quick tip which is suggested by SQL Server Expert Nicklas Bågvinge, whom I met in the Gothenburg earlier this week during a SQL Training. He recently sent me an email about a very interesting SQL Server Management Stud …

Find SQL Server Installation Date for all Instances with PowerShell

Publié le 11 octobre 2019 sur sqlservercentral.com
 

The post Find SQL Server Installation Date for all Instances with PowerShell appeared first on SQLServerCentral.

Free Solution Brief – Dedicated Database Environments for Dev, Test and CI

Publié le 11 octobre 2019 sur sqlservercentral.com
 

The post Free Solution Brief – Dedicated Database Environments for Dev, Test and CI appeared first on SQLServerCentral.

How to Think Like the SQL Server Engine: Adding an ORDER BY

Publié le 10 octobre 2019 sur brentozar.com
 

We started out the How to Think Like the Engine series with a simple query with a WHERE clause: Now let’s add an ORDER BY:SELECT Id FROM dbo.Users WHERE LastAccessDate > ‘2014/07/01′ ORDER BY LastAccessDate; Here’s the updated plan …

SQL SERVER Management Studio – Removing Completion Time in Messages

Publié le 10 octobre 2019 sur journey to sqlauthority
 

Earlier, I wrote a blog post about SQL SERVER Management Studio – Completion Time in Messages. This was newly introduced in the recent version of SQL Server Management Studio. Since the blog post, I have received many curious emails and questions …

The Basics of INCLUDE

Publié le 10 octobre 2019 sur sqlservercentral.com
 

I saw a post recently that discussed performance of a table with no keys or indexes. That’s a recipe for poor performance in queries if this table grows large. In this case, I’ll demonstrate how an index might change the performance of a qu …

Handling Tricky Data Migrations during State-based Database Deployments

Publié le 10 octobre 2019 sur sqlservercentral.com
 

The post Handling Tricky Data Migrations during State-based Database Deployments appeared first on SQLServerCentral.

SQL Server 2017 CU17 Released

Publié le 9 octobre 2019 sur sqlskills.com - glen berry
 

On October 8, 2019, Microsoft released SQL Server 2017 CU17, which is Build 14.0.3238.1. There are 34 public hot fixes in the cumulative update. Starting with SQL Server 2017, Microsoft is not using Service Packs as a servicing mechanism for SQL Server …

Why Query Plans Can Look Different on Different Servers

Publié le 9 octobre 2019 sur brentozar.com
 

In the first post in my How to Think Like the Engine series, I started by doing a pretty simple query: But I noted that if you were following along on your computer, you might see a different execution plan. If I tweak just one thing about my SQL Serve …

SQL SERVER – Installation Error: 25641- For target, “package0.event_file”, the parameter “filename” passed is invalid. Target parameter at index 0 is invalid

Publié le 9 octobre 2019 sur journey to sqlauthority
 

While installing SQL Server 2012 in a client environment, they faced an interesting error about for target. Here is the information that is taken from SQL Server ERRORLOG. If you don’t know how to find Errorlog, please refer to my earlier blog. S …

Getting Started with SQL Server Azure Container Instances ACI

Publié le 9 octobre 2019 sur sqlservercentral.com
 

The post Getting Started with SQL Server Azure Container Instances ACI appeared first on SQLServerCentral.

SQL Compare 14 now available on Linux

Publié le 9 octobre 2019 sur sqlservercentral.com
 

The post SQL Compare 14 now available on Linux appeared first on SQLServerCentral.

T-SQL Tuesday #119 Changing Your Mind

Publié le 8 octobre 2019 sur sqlskills.com - glen berry
 

This post is a response to this month’s T-SQL Tuesday #119 prompt by Alex Yates.  T-SQL Tuesday is a way for the SQL Server Community to share ideas about different database and professional topics every month. This month’s topic asks …

Establishing a DevOps Organisation

Publié le 8 octobre 2019 sur simple-talk.com
 

The radical pace of development promised with DevOps can make some people nervous, especially if they have spent years with the waterfall development model. The very first question that comes to mind is: How do you expedite your development withou …

SQL SERVER Tools I Use and Recommend (Updated: October 2019)

Publié le 8 octobre 2019 sur journey to sqlauthority
 

I just returned from the long road trip to teach 21 SQL Server Performance Tuning Scripts Course. One of the most popular questions, I had received what tools I use personally when I work with SQL Server. Though I had answered them during the training …


Pages :