Sites anglophones


SQL SERVER – Not Auto-Updating Statistics with STATISTICS_NORECOMPUTE

Publié le 4 août 2020 sur journey to sqlauthority
 

Recently I found an interesting situation with one of my clients when working on Comprehensive Database Performance Health Check. It was about one particular statistics not getting auto-updated on the table. After careful investigation, we figured out …

New release: Redgate Change Control now integrates with Git

Publié le 4 août 2020 sur sqlservercentral.com
 

The post New release: Redgate Change Control now integrates with Git appeared first on SQLServerCentral.

Calling a Stored Procedure from PowerShell

Publié le 4 août 2020 sur sqlservercentral.com
 

One of the DBAs at our company recently wanted to execute a stored procedure to get data from some of our databases. We have a number of databases that are used by different customers, all of which are the same in terms of the schema and objects. The d …

SQL Server Management Studio Connection to Integration Services Error Class Not Registered

Publié le 4 août 2020 sur sqlservercentral.com
 

The post SQL Server Management Studio Connection to Integration Services Error Class Not Registered appeared first on SQLServerCentral.

[Video] The Top 10 Developer Mistakes That Won’t Scale on Microsoft SQL Server

Publié le 3 août 2020 sur brentozar.com
 

You’re a C# or Java developer building an application that stores data in Microsoft SQL Server, and you want to avoid common pitfalls that will cause you scalability problems down the road. In this session from my live stream, you’ll learn …

How to Uninstall SQL Server 2019 Instance? – SQL in Sixty Seconds #093

Publié le 3 août 2020 sur journey to sqlauthority
 

Earlier this week, I had posted a video about how to install SQL Server 2019. I received lots of comments and feedback about this one. Many people said that they have realized that installing SQL Server 2019 is very easy but the real challenge is to un …

Change the Instance Collation by Rebuilding Databases in SQL Server 2017

Publié le 3 août 2020 sur sqlservercentral.com
 

As a part of my DBA activities, I do a lot of SQL Server installations every week. Most of the time, I install the instance with the default collation. A collation is a configuration setting in SQL Server that determines how the database engine should …

How to Install SQL Server 2019? – Interview Question of the Week #287 – SQL in Sixty Seconds #092

Publié le 2 août 2020 sur journey to sqlauthority
 

Question: How to Install SQL Server 2019?Answer: This is one of the unique blog posts in the history of SQLAuthority where I am merging two of the blog post category together 1) SQL in the Sixty Seconds 2) SQL Interview Questions and Answers.Lots of pe …

SQL SERVER 2019 – Disabling Scalar UDF Inlining

Publié le 1 août 2020 sur journey to sqlauthority
 

I have been blogging for over 13 years and have been working with SQL Server Performance Tuning for an over a decade and everyone always ask me where do I get new content to write from every single day. My answer is very simple, I actually get new thin …

Temporary Tables in SQL Server

Publié le 1 août 2020 sur simple-talk.com
 

Temporary tables are just that. They are used most often to provide workspace for the intermediate results when processing data within a batch or procedure. They are also used to pass a table from a table-valued function, to pass table-based data betwe …

Recovering Scripts After SSMS Crash

Publié le 31 juillet 2020 sur sqlskills - jonathan kehayas
 

It happens to the best of us and this post is more of a reminder for myself the next time it happens to me than anything else.  You are working in SQL Server Management Studio, you have a few tabs open (OK, it was 123 this time, but lets stay focu …

A One-Slide Summary of the Differences Between TDE and Always Encrypted

Publié le 31 juillet 2020 sur brentozar.com
 

The folks on Twitter liked this, so sharing it here: It’s a one-slide summary from a SQL Critical Care client’s deck, so obviously it’s abridged, but I think it does a pretty good job of summing things up. Some highlights of the conve …

Install MongoDB on Windows – SQL in Sixty Seconds #091

Publié le 31 juillet 2020 sur journey to sqlauthority
 

SQL Server is my passion and I have been keeping busy most of the time in my career doing. While SQL Server is my primary expertise, I also focus on MariaDB, PostgreSQL, MySQL and many other relational databases. However, in the real world, it is not a …

Tracking use of Deprecated SQL Server Features

Publié le 31 juillet 2020 sur sqlservercentral.com
 

The post Tracking use of Deprecated SQL Server Features appeared first on SQLServerCentral.

SQL in Sixty Seconds – Need Your Feedback

Publié le 30 juillet 2020 sur journey to sqlauthority
 

I have been writing about SQL Server Blog for over 13 years now and I have been also creating various different videos on SQL Server Performance Tuning topics. I have recently decided to spend more time in building the videos and have created three vid …


Pages :