Monday Coffee: Posting error messages
I posted a couple of messages on twitter over the weekend giving any new bloggers advice that was given to...
2017-08-21
289 reads
Microsoft Azure – How to Check the availability of cloud services using PowerShell
Hello friends, in this blog we will learn how to check whether a cloud service is available to use with...
2017-08-21
477 reads
Database Issue: The transaction log for database ‘db_name’ is full due to ‘ACTIVE_BACKUP_OR_RESTORE’.
Today, I was called in the early hours because the transaction log of one of the SQL Server 2016 database was full. I logged onto the SQL server instance...
2017-08-20
24 reads
Database Issue: The transaction log for database ‘db_name’ is full due to ‘ACTIVE_BACKUP_OR_RESTORE’.
Today, I was called in the early hours because the transaction log of one of the SQL Server 2016 database...
2017-08-20
503 reads
Query Store functionality in earlier versions of SQL Server
One of the best features introduced in SQL Server 2016 was the Query Store. Having the ability to see which...
2017-08-19
552 reads
Power BI FAQ Chat Bot 9000 lives!
So I’ve been working on a fun little project over the past couple weeks. A lot of my customers have...
2017-08-18
508 reads
31 Days of Disaster Recovery Revisited
A few years ago, I did a blog post series dedicated to disaster recovery (backups, restores, corruption, etc). 31 blog...
2017-08-18
478 reads
Fixing You’ll need a new app to open this ms-word
It should come as no surprise that we rely heavily on SharePoint for sharing documents at Microsoft. For the most part it is a great solution with few issues....
2017-08-18
241 reads
Fixing You’ll need a new app to open this ms-word
It should come as no surprise that we rely heavily on SharePoint for sharing documents at Microsoft. For the most...
2017-08-18
889 reads
Using Time Zones in SQL Server
The usage of time zones in applications becomes inevitable, especially with the globalization of the applications. Reports need to be run in different time zones. Services have to consider...
2017-08-18
11 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers