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
505 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
553 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
509 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
890 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
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
44 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...
2017-08-31 (first published: 2017-08-18)
3,801 reads
Friday Reading 2017-08-18
Cool week, I’ve been selected to present at SQL Saturday Holland & SQL Saturday Denmark this year. September and October are...
2017-08-18
378 reads
Blogs
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers