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
35 reads
Blog Posts
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
18 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)
281 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)
318 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
35 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
153 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
136 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
38 reads
#TSQL2sday – Preconceived Notions About Who Is Smart
For this month’s #TSQL2day, Andy Yun asked folks to share about “something you’ve learned, that subsequently changed your opinion/viewpoint/etc. on something.” Now, there are technical subjects I could share...
2022-01-11
43 reads
Azure Database for MySQL
SQL Server is not the only database you build and deploy into Azure. Another very popular option is MySQL. Going back many years, this was actually my first database...
2022-01-11
57 reads
Blogs
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Monday Monitor Tips: Oracle Custom Metrics
By Steve Jones
One of the popular features of Redgate Monitor has been the ability to add...
Walking Through a Planned Failover: SQL Server Always On Availability Groups on Kubernetes
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
Forums
Are Akashic Records Course Fees Worth It? IIVS Review & Opinions
I’ve been exploring different platforms to learn about spirituality in a more structured way,...
Troubleshooting WQL in custom PBM conditions?
Hi, I'm currently trying to implement policy based mgmt with a condition to query...
Analysis of Locking Issues on Secondary Replicas in AlwaysOn Availability Groups
We have an AlwaysOn architecture with four replicas: two running in synchronous commit mode...
Question of the Day
The Vector Data Type
What is the vector data type in SQL Server?
See possible answers