Three Reasons to (Temporarily) Change Max Worker Threads
When you go to the deli, there’s a “take a number” dispenser where you tear off a number and wait for your number to be called. If you walked into a deli and you saw 50 people lined up all waiting their turn, and you went to take a nu …
SQL SERVER 2019 – New Values in Sys.Configurations
Since the release of SQL Server 2019, I have written quite a few blogs about this release. In this blog, we would see the new options available in sys.configurations catalog view. If you are not familiar with this, then you need to correlate this with …
Portable Objects in PowerShell with CLIXML
The post Portable Objects in PowerShell with CLIXML appeared first on SQLServerCentral.
[Video] You shouldn’t dynamically create/alter/drop triggers.
Let’s get one thing out of the way first: this isn’t about the relative good or evil of triggers. I kinda like triggers, in fact – they’re good for enforcing business logic in a hurry when you can’t redo code across an ent …
Centralpoint – Digital Experience Platform with Artificial Intelligence
The biggest advantage of my consulting job is that I get to learn new things every single day when I am helping different organizations solve their SQL Server Performance problems. While working with one of my largest technology clients, I came across …
SQL SERVER 2019 – How to Enable Lock Paged in Memory LPIM?
With the release of SQL Server 2019, there were enhancements that are known and talked about. There are few minor changes in SQL Server Configuration Manager which were un-noticed. In this blog, I would talk about enhancement in SQL Server 2019 Configu …
A tale of updating a legacy system bug
I am sure many of you have worked, or are working, with a legacy system. Some system that was created long before you arrived. It may not have the best design, so you have to work around it since often the design or code can’t be chan …
SQL Server Security Best Practices for an Application Installed on SQL Server
The post SQL Server Security Best Practices for an Application Installed on SQL Server appeared first on SQLServerCentral.
New class: Immersion Event on Using and Administering SSRS and Power BI
By popular demand, we’ve added Tim’s reporting class to our Spring line-up in Chicago! It’s a two-day class called IEReporting: Immersion Event on Using and Administering SSRS and Power BI and includes Power BI Report S …
The Curious Case of… a truncated log file after a revert from snapshot
(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 …
The 2020 Data Professional Salary Survey Results Are In.
We asked what you make, and 1,734 of you in 63 countries answered. Altogether, you made $170,753,936 this year. Damn, y’all are bringing home the bacon! Download the 2020, 2019, 2018, & 2017 results in Excel. A few things to know about it: Th …
SQL SERVER 2019 – How to Turn On or Enable Instant File Initialization?
Learning never stops with SQL Server. In this blog, we would find new ways to find information. In this blog, we would see the current setting of instant file initialization and how to make the modification. Last year I wrote a few blogs about Instant …
ASP.NET Core with GitOps: Orchestrating Your Containers with Kubernetes
The post ASP.NET Core with GitOps: Orchestrating Your Containers with Kubernetes appeared first on SQLServerCentral.
Setting up Management Studio for remote SQL Server
Problem Most of us, developers, love to write SQL code on our local machines not only because they’re executed faster, but also because we have a lot more control over the data as it is used only by us and is not team dependent. This was the case in my …
How to Map Network Drive as Fixed Drive? – Interview Question of the Week #258
Question: How to Map Network Drive as Fixed Drive in SQL Server?Answer: The command to map any drive as a fixed drive is Windows command and you can run that in the SQL Server with the help of the extended stored procedure. Here is the script for the s …