Sites anglophones


SQL SERVER – How Do I Evaluate Monitoring Tools?

Publié le 8 mai 2019 sur journey to sqlauthority
 

From last many years, I have been working with SQL Server focusing on Performance Tuning and Optimization. I often get asked what is my favorite monitoring tool. I have previously written about this subject on the blog and there are five part blog seri …

How to Build an Efficient Request Process for SQL Server DBAs

Publié le 8 mai 2019 sur sqlservercentral.com
 

The post How to Build an Efficient Request Process for SQL Server DBAs appeared first on SQLServerCentral.

MDX (MultiDimensional Expressions) in 148 minutes

Publié le 8 mai 2019 sur sqlservercentral.com
 

If you want to understand the fundamentals of MDX in less than 3 hours – this article can be helpful. I came to the conclusion that the best way of learning are video tutorials. 143 minutes of watching and 5 minutes of reading. Let’s get started. Some …

Developers: Azure SQL DB Serverless can save you money.

Publié le 7 mai 2019 sur brentozar.com
 

If you’ve got a database that doesn’t need to be on all the time, Azure SQL DB Serverless is in public preview now. It makes a lot of sense for those development databases you have to keep around, but don’t really want to pay for. If …

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 …


Pages :