Mid-Range 1440P AMD Gaming PC Build Guide
Continuing the series I started yesterday, I thought I would put together a build guide for a Mid-Range 1440P AMD Gaming PC. I am classifying a mid-range gaming machine as costing between about $750.00 to $1500.00 for the main components.Any desktop ma …
SQL SERVER – Regular Table or Temp Table – A Quick Performance Comparison
Recently I received a very interesting question from my client who is a recently hired me for Comprehensive Database Performance Health Check. The question was a very simple but interesting one and I have decided to answer it with the proof and working …
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 …