Identifying SQL Server Performance Problems Part 2
Performance Monitoring Tools In this second post we are diving into what tools you can use to capture the important performance metrics you need to gather for baselining your...
2021-02-10
40 reads
Blog Posts
Launching On-Demand Training Platform SQLibrium
I am thrilled to announce the launch of a new education initiative called SQLibrium. For years, I’ve traveled the world educating technical audiences on deep-dive topics around how data and...
2021-02-10 (first published: 2021-02-02)
264 reads
Power of Unlearning
(2021-Jan-31) Working on DIY home projects is always fun, choosing the right tools: whether I handle paperhanging scissors to cut my wallpapers, or create an opening and trim my drywall...
2021-02-10 (first published: 2021-02-01)
261 reads
Professionalism in the age of COVID-19
Some years ago, I wrote about what it means to be “professional” (and that it doesn’t mean having to wear a suit and tie). Recently a conversation broke out...
2021-02-10
174 reads
Daily Coping 9 Feb 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-02-09
22 reads
Getting SQL Agent Jobs and Job Steps Configuration
Recently I needed to take a look at all of the SQL Server Agent Jobs and their Jobs Steps for a customer. Specifically, I needed to review all of...
2021-02-09 (first published: 2021-02-03)
712 reads
Granting ADLS Gen2 Access for Power BI Users via ACLs
It’s common that users only have access to certain folders in an Azure Data Lake Storage container. These permissions are provided not through Azure RBAC (role-based access control) roles...
2021-02-09 (first published: 2021-02-04)
208 reads
Query DB2 From PowerShell
Story time: A few months ago I was in a meeting where we were all asked how we could take on a complex, but very necessary task. As they...
2021-02-09
13 reads
Server Review Essentials for Accidental and Junior DBAs—Client Onboarding (Part 2)
It’s time for the fourth post in my series about performing regular server reviews. In the first post, we took a look at setting up your local environment. The...
2021-02-09
32 reads
Showcase Your Figma Designs on WordPress P2
Figma — one of the most popular and fastest growing digital design tools today — was recently voted “the most exciting design tool of 2021.” In many organizations, a...
2021-02-09
15 reads
Blogs
TRY_PARSE Limitations: #SQLNewBlogger
By Steve Jones
I got a notification from a question I’d posted at SQL Server Central: Getting...
SQL Server sa Account Security: Rename, Disable & Best Practices
By SQLPals
SQL Server sa Account Security: Rename, Disable & Best Practices In...
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
Forums
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
A Limited Startup
Comments posted to this topic are about the item A Limited Startup
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers