Sites anglophones


Soft Skills: Controlling your career

Publié le 19 septembre 2019 sur sqlservercentral.com
 

Technical skills come and go while soft skills will serve you throughout your life. They will have the greatest influence over your career, job and role.  For some people soft skills come naturally.  As an Aspergers person (Aspie) I have to p …

Entry-Level 1080P AMD Gaming PC Build Guide

Publié le 18 septembre 2019 sur sqlskills.com - glen berry
 

Since I often get questions and requests related to selecting components for different types desktop PCs, I thought I would put together a few quick build guides for some different categories of machines at different price points.Any desktop machine is …

SQL SERVER – Check for Update in SSMS

Publié le 18 septembre 2019 sur journey to sqlauthority
 

Just last week, I had a very interesting consulting engagement with large financial technology organizations. DBAs and Devs had many interesting questions during the Comprehensive Database Performance Health Check. One of the question was related to ho …

Backup Techniques Available Exclusively When Using Azure VMs

Publié le 18 septembre 2019 sur sqlservercentral.com
 

The post Backup Techniques Available Exclusively When Using Azure VMs appeared first on SQLServerCentral.

DBA Training Plan 22: Where to Learn More

Publié le 17 septembre 2019 sur brentozar.com
 

Whew. We’ve worked through a couple dozen posts together in this DBA Training Plan, and you’re still just getting warmed up. First, pick your specialty. Here’s some of the more popular specializations in the SQL Server business: Produ …

SQL SERVER – Brief Note About RESOURCE_SEMAPHORE_QUERY_COMPILE Wait Type Resource

Publié le 17 septembre 2019 sur journey to sqlauthority
 

dmvust the other day, I wrote a blog post about SQL SERVER – Enable Lock Pages in Memory LPIM. I have received some amazing feedback about it and also lots of question. Though, I never expected I signed up four new clients for Comprehensive Datab …

“Included columns” for non-clustered indexes explained

Publié le 17 septembre 2019 sur sqlservercentral.com
 

Microsoft SQL Server has the feature to use “Included columns” for the creation of non-clustered indexes. This feature and its benefits and disadvantages will be explained in the following article. Included columns can be used to create a c …

Partitioning Data in SQL Server without using Partitioned Tables

Publié le 17 septembre 2019 sur sqlservercentral.com
 

The post Partitioning Data in SQL Server without using Partitioned Tables appeared first on SQLServerCentral.

DBA Training Plan 21: Building a New SQL Server

Publié le 16 septembre 2019 sur brentozar.com
 

I have a secret setup checklist. Oh sure, our free First Responder Kit has a SQL Server setup checklist that walks you through a few things you need to do before you install, plus a few things to do immediately afterwards. That’s good. …

SQL SERVER – Enable Lock Pages in Memory LPIM

Publié le 16 septembre 2019 sur journey to sqlauthority
 

One of my recent clients had a very interesting situation of memory pressure, which we detected during the Comprehensive Database Performance Health Check. In most of the cases, my clients have either CPU pressure issue or the disk/IO issue. However, i …

A fresh new look for Redgate University

Publié le 16 septembre 2019 sur sqlservercentral.com
 

The post A fresh new look for Redgate University appeared first on SQLServerCentral.

Working with React Components

Publié le 16 septembre 2019 sur sqlservercentral.com
 

The post Working with React Components appeared first on SQLServerCentral.

How to List All DML Triggers Created or Modified in the Last N Days in SQL Server? – Interview Question of the Week #242

Publié le 15 septembre 2019 sur journey to sqlauthority
 

Question: How to List All DML Triggers Created or Modified in the Last N Days in SQL Server?Answer: Before we talk more let us see the script to list all All DML Triggers Created or Modified in the Last N Days in SQL Server.SELECT o.name as [Trigger Na …

September 2019 Trainings – 21 Essential Scripts: Performance Tuning

Publié le 14 septembre 2019 sur journey to sqlauthority
 

I will be delivering four classes on my most popular training on 21 Essential Scripts: Performance Tuning in Europe in the month of September 2019. Here is the quick schedule and how you can register for the class.DateLocationRegistration LinkSept …

Glenn’s Tech Insights For September 13, 2019

Publié le 13 septembre 2019 sur sqlskills.com - glen berry
 

(Glenn’s Tech Insights… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally releva …


Pages :