How to install PowerShell SQLServer module in a specific directory
Troubleshoot error - Install-Module: Administrator rights are required to install modules in 'C:Program FilesWindowsPowerShellModules.'
2022-01-13
93 reads
Blog Posts
Troubleshoot PowerShell-No match was found for the specified search criteria,module FailoverClusters
Troubleshoot PowerShell-No match was found for the specified search criteria, module FailoverClusters
2022-01-13
69 reads
A Little Current Date Arithmetic in Powershell–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw a fun post on Twitter recently...
2022-01-12
41 reads
Daily Coping 12 Jan 2022
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...
2022-01-12
28 reads
Identifying Recompile Causes
Strictly speaking, a recompile isn’t really a performance tuning problem. In fact, a lot of time, recompiles are desired because they reflect changes in statistics which are likely to...
2022-01-12 (first published: 2022-01-03)
293 reads
Purging a SQL Server Express Database
This is not another IRL post, but rather is more of “Help, my SQL Express database is full!” post. I was contacted by a lawyer that was using a...
2022-01-12 (first published: 2021-12-30)
342 reads
SQL Database Error - BACKUP LOG cannot be performed because there is no current database backup
SQL Database Error - BACKUP LOG cannot be performed because there is no current database backup
2022-01-12
61 reads
SQL Server 2019 on Apple Silicon redux: it actually works
Last month I wrote a blog post suggesting that it was not possible to get SQL Server 2019 running on Apple Silicon. I hedged my statement by saying you...
2022-01-12
184 reads
Troubleshoot “Database might contain bulk-logged changes that have not been backed up” in SQL Server
Troubleshoot “Database might contain bulk-logged changes that have not been backed up” in SQL Server
2022-01-12
152 reads
T-SQL query to check SQL Server min server memory(MB) and max server memory(MB)
T-SQL query to check SQL Server min server memory(MB) and max server memory(MB)
2022-01-12
87 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers