Soft Skills: Controlling your career
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
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
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
The post Backup Techniques Available Exclusively When Using Azure VMs appeared first on SQLServerCentral.
DBA Training Plan 22: Where to Learn More
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
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
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
The post Partitioning Data in SQL Server without using Partitioned Tables appeared first on SQLServerCentral.
DBA Training Plan 21: Building a New SQL Server
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
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
The post A fresh new look for Redgate University appeared first on SQLServerCentral.
Working with React Components
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
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
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
(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 …