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
514 reads
Blog Posts
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
558 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
481 reads
Being a Positive Influencer
I read a lot of self-help and improvement information. I’m always trying to hack my brain or my attitude to...
2017-08-18 (first published: 2017-07-31)
1,915 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
243 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
891 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
382 reads
Learning through gaming a SQL Server tale
I’ve been teaching my 17 yr old SQL Server and other various topics. I have quite a bit of experience...
2017-08-18 (first published: 2017-07-31)
2,434 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
511 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
57 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers