Sites anglophones


SQL SERVER – Script to Get Compiled Plan with Parameters From Cache

Publié le 7 mai 2019 sur journey to sqlauthority
 

Lots of people often ask me as I share pretty everything on the blog – Do I have any Business Secrets. Actually, the answer is no, I never keep any secrets. I always share everything I know and I want my customers and readers learn along with me. …

Microsoft SQL Server: Current Identify Column Value in a Table

Publié le 7 mai 2019 sur sqlservercentral.com
 

The post Microsoft SQL Server: Current Identify Column Value in a Table appeared first on SQLServerCentral.

Using Azure Data Studio with TFVC

Publié le 7 mai 2019 sur sqlservercentral.com
 

Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles on how the tool works, shown here: Getting Started with Azure Data Studio Getting Comfortable Writing Code in Azure Data Studio Using Notebooks in Azu …

The Silent Bug I Find in Most Triggers

Publié le 6 mai 2019 sur brentozar.com
 

Get Notebook – FAQ I don’t have a problem with triggers. They get the job done when you need to implement business logic in a hurry, and you’re not allowed to change the application. As long as you keep the number of statements to a m …

SQL SERVER – Script to Kill All Inactive Sessions – Kill Sleeping Sessions from sp_who2

Publié le 6 mai 2019 sur journey to sqlauthority
 

I consider myself fortunate that I get to work with so many different clients while engaged in Comprehensive Database Performance Health Check. Recently we found out that one of the third party application for the client is not closing the connections …

Enable SQL Server Agent Mail Profile

Publié le 6 mai 2019 sur sqlservercentral.com
 

The post Enable SQL Server Agent Mail Profile appeared first on SQLServerCentral.

How to List Dirty Pages From Memory in SQL Server? – Interview Question of the Week #223

Publié le 5 mai 2019 sur journey to sqlauthority
 

Question: How to List Dirty Pages From Memory in SQL Server?Answer: I recently received this question today during my SQL Server Performance Tuning Practical Workshop. To my surprise, I have already blogged about this in detailed earlier so during the …

SQL SERVER – Error: 9642 – An error occurred in a Service Broker/Database Mirroring transport connection endpoint

Publié le 4 mai 2019 sur journey to sqlauthority
 

During my consultancy engagement, my client’s DBA team was checked ERRORLOG and asked me the possible cause of below error about service broker.DateTime spid74s      Error: 9642, Severity: 16, State: 3.DateTime spid74s …

SQL SERVER 2008 R2 – I Support You Beyond July 9 2019

Publié le 3 mai 2019 sur journey to sqlauthority
 

One of my clients is primarily using SQL Server 2008 R2 for most of their application. They are also using the same for their own clients and are managing over 100 installations of various versions of SQL Server. They have frequently hired me for Compr …

Change Not For Replication Value for SQL Server Identity Columns

Publié le 3 mai 2019 sur sqlservercentral.com
 

The post Change Not For Replication Value for SQL Server Identity Columns appeared first on SQLServerCentral.

Are your CPU-intensive queries running slowly? Check your VM type.

Publié le 2 mai 2019 sur brentozar.com
 

When you build a VM for SQL Server in Amazon EC2, Azure VMs, or Google Compute Engine, it’s all too easy to overlook the CPU speeds that you’re getting. Most of the time, it doesn’t really matter because SQL Server isn’t us …

SQL SERVER – Global Variable @@DEF_SORTORDER_ID – Old and May be Deprecated

Publié le 2 mai 2019 sur journey to sqlauthority
 

I always blog about things which are new and updated but today we are going to write about something which is very old and it is near deprecated. We are going to about the global variable @@DEF_SORTORDER_ID. Let us see what it is and how it was used on …

Introduction to SQL Server Security — Part 5

Publié le 2 mai 2019 sur sqlservercentral.com
 

The post Introduction to SQL Server Security — Part 5 appeared first on SQLServerCentral.

A Self-Serve System to Refresh Databases – Part 1

Publié le 2 mai 2019 sur sqlservercentral.com
 

I am not sure I could count the number of times I have restored a backup from production to a test or dev server. It has happened enough times I finally wrote a system so the developers could do it themselves. This series of articles will review this s …

Pop Quiz: SQL 2000 Bug or SQL 2017 Bug?

Publié le 1 mai 2019 sur brentozar.com
 

2002: Me and Bailey, mom’s Great Dane When I was thinking about this site’s 17th birthday, I started wondering: back in 2002, what bug might I have been working with in SQL Server? I started reading back to the list of bugs fixed in SQL Ser …


Pages :