Sites anglophones


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 …

Recorded Class Instant Learning – SQL Server Performance Tuning Practical Workshop

Publié le 1 mai 2019 sur journey to sqlauthority
 

SQL Server Performance Tuning Practical Workshop is one of my most popular training.  Every month I get tons of request to deliver this class but there is a limitation of how many classes, I can deliver in person. This class is built on my most po …

SQL Server Trigger on View Example

Publié le 1 mai 2019 sur sqlservercentral.com
 

The post SQL Server Trigger on View Example appeared first on SQLServerCentral.

SQL in the City Summits – US & Down Under

Publié le 1 mai 2019 sur sqlservercentral.com
 

The post SQL in the City Summits – US & Down Under appeared first on SQLServerCentral.

The Curious Case of… trying to find an MDF file in a RAW disk

Publié le 30 avril 2019 sur sqlskills.com - paul randall
 

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …

Oracle for Absolute Beginners: Problem-Solving as a New Developer

Publié le 30 avril 2019 sur simple-talk.com
 

Hi.  My name is David. If you’ve heard of me, there’s a good chance it’s from my Oracle for Absolute Beginners series which I write for Simple Talk. (Either that, or you got here from googling the famous NFL sportsman who has the …

Updated First Responder Kit and Consultant Toolkit for April 2019

Publié le 30 avril 2019 sur brentozar.com
 

This month, lots of improvements and bug fixes, including checking for paused resumable index operations, Evaluation Edition expiration dates, sp_BlitzCache shows the number of duplicated plans for each query, sp_BlitzIndex will skip a list of database …

What is Automation?

Publié le 30 avril 2019 sur simple-talk.com
 

Today I got a bit closer to a meaningful definition of automation as it applies to the software development process. I’ve been turning this concept over in my head for a while, which is partly related to the dreaded question of licensing. Why sho …


Pages :