News Articles Databases News

Game changer settings # MAXDOP and Cost threshold for parallelism from Blog Posts – SQLServerCentral

I got a performance tuning assignment for an esteemed customer in the Financial Services domain. I went through the wait stats of SQL Server using the built-in SQL Server Report, called Performance Dashboard. I found CPU – Parallelism referred to as CXPACKET was leading the list, followed by Buffer IO, Lock, and Latch. Parallelism in SQL Server refers to two settings – MAXDOP and Cost threshold […]

Easy Monitoring: Application Timeouts in SQL Server with XEvents from Blog Posts – SQLServerCentral

One of my least favorite feelings in the IT world is to be caught by surprise. Not just any type of surprise. I am talking about the kind of surprise that comes from an end user letting me know that the Database is broken. Afterall, the monitoring and efforts I put into place should let […]

2020 Year In Review from Blog Posts – SQLServerCentral

TL;DR – It was great and not great I think we can all pretty much agree that in some regards 2020 was horrible, globally. So lets move on… Good stuff: COVID-19 Vaccines are hitting the market and being distributed! Boeing 737 MAX is cleared to fly again (Boeing is a Dow 30 component and LOTS… […]

Happy New Year! from Blog Posts – SQLServerCentral

Happy New Year!! Looking back at my Happy New Year![1] post from the start of 2020, I of course, didn’t realize the brute force of the global pandemic that was about to hit.  Even with the dumpster fire that was 2020, good things still occurred even in the midst of the world burning.  Babies were […]

Daily Coping 1 Jan 2021 from Blog Posts – SQLServerCentral

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle[1], which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag[2].  Today’s tip is to choose to give or receive the gift […]

Your Quick Introduction to Extended Events in Analysis Services from Blog Posts – SQLServerCentral

The Extended Events (XEvents) feature in SQL Server is a really powerful tool and it is one of my favorites. The tool is so powerful and flexible, it can even be used in SQL Server Analysis Services (SSAS). Furthermore, it is such a cool tool, there is an entire site dedicated to XEvents[1]. Sadly, despite […]

Logging the history of my past SQL Saturday presentations from Blog Posts – SQLServerCentral

(2020-Dec-31) PASS (formerly known as the Professional Association for SQL Server) is the global community for data professionals who use the Microsoft data platform. On December 17, 2020 PASS announced that because of COVID-19, they were ceasing all operations effective January 15, 2021. PASS has offered many training and networking opportunities, one of such training streams […]

Storage savings with Table Compression from Blog Posts – SQLServerCentral

In one of my recent assignments, my client asked me for a solution, to reduce the disk space requirement, of the staging database of an ETL workload. It made me study and compare the Table Compression feature of SQL Server. This article will not explain Compression but will compare the storage and performance aspects of […]

Daily Coping 31 Dec 2020 from Blog Posts – SQLServerCentral

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle[1], which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag[2].  Today’s tip is to plan some new acts of kindness to […]

Hope! from Blog Posts – SQLServerCentral

2020 was a rough year. We’ve had friends and family leave us. Jobs lost. Health scares a plenty and that’s without counting a global pandemic. The end of PASS. US politics has been .. nail biting to say the very least. All around it’s just been a tough year. On the other hand, I’m still […]

Firewall Ports You Need to Open for Availability Groups from Blog Posts – SQLServerCentral

Something that never ceases to amaze me is the frequent request for help on figuring out what ports are needed for Availability Groups in SQL Server to function properly. These requests come from a multitude of reasons such as a new AG implementation, to a migration of an existing AG to a different VLAN. Whenever […]

Experiments With Go Arrays and Slices from Blog Posts – SQLServerCentral

Simplicity Over Syntactic Sugar As I’ve been learning Go, I’ve grown to learn that many decisions to simplify the language have removed many features that provide more succinct expressions in languages such as Python, PowerShell, C#, and others. The non-orthogonal features in the languages result in many expressive ways something can be done, but at […]

Creating an HTML URL from a PowerShell String–#SQLNewBlogger from Blog Posts – SQLServerCentral

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.[1] I wrote about getting a quick archive of SQL Saturday data[2] last week, and while doing that, I had some issues building the HTML needed in PowerShell. I decided to work through this a […]

2020 was certainly a year on the calendar from Blog Posts – SQLServerCentral

According to my blog post schedule, this is the final post of the year. It’s nothing more than a coincidence, but making it through the worst year in living memory could also be considered a sign. While it’s true that calendars are arbitrary, Western tradition says this is the end of one more cycle, so let’s-> […]

Daily Coping 30 Dec 2020 from Blog Posts – SQLServerCentral

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle[1], which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag[2].  Today’s tip is to bring joy to others. Share something which […]

How to Easily Grant Permissions to all Databases from Blog Posts – SQLServerCentral

A recurring need that I have seen is a means to grant a user or group of users access to all databases in one fell swoop. Recently, I shared an introductory article[1] to this requirement. In this article, I will demonstrate how to easily grant permissions to all databases via the use of Server Roles[2]. […]

Daily Coping 29 Dec 2020 from Blog Posts – SQLServerCentral

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle[1], which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag[2].  Today’s tip is to congratulate someone for an achievement that may […]

Time to Set Service Dependencies for SQL Server, it’s Easy from Blog Posts – SQLServerCentral

In the previous article[1] I mentioned the need for setting certain dependencies for SQL Services startup. As promised, this article is a follow-up to that article to help you easily set the service dependencies for SQL Server. Setting service startup dependencies is an essential step to take to help ensure a seamless startup experience and […]

Sitemap | Terms | Privacy | Cookies | Advertising

Senior Software Developer

Creator of @LzoMedia I am a backend software developer based in London who likes beautiful code and has an adherence to standards & love's open-source.