The transaction log for database 'ABC' is full due to 'ACTIVE_BACKUP_OR_RESTORE'
I have recently had a client with a problem each morning where they were having processes fail with this message...
2015-12-22
20,055 reads
Immunizations – Not Just for Kids
It’s the ‘get your flu shot’ time of the year, which is also a good time to review your immunizations....
2015-12-22
641 reads
How to Compare Tables in SQL Server
One of our customers has recently asked me the following question (I changed just the business case):
The Problem
“I have a...
2015-12-22
547 reads
Fixing Truncation Issues with T-SQL Flex
If you’ve worked with SQL Server for any length of time, you’ve run into this error:
Msg 8152, Level 16, State...
2015-12-21
1,051 reads
Goodness-of-Fit Testing with SQL Server, part 3.2: D’Agostino’s K-Squared Test
By Steve Bolton
…………In the last edition of this amateur series of self-tutorials on goodness-of-fit testing with SQL Server, we discussed...
2016-01-04 (first published: 2015-12-21)
2,119 reads
Monday Morning SQL Break – December 21, 2015
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2015-12-21
455 reads
Thanks to Rodney & Karla
Sometime in the next couple weeks Rodney & Karla Landrum are moving from Orlando to Pensacola (home). I’m happy for them...
2015-12-21
622 reads
Learning R: Hard Lessons
I’ve always found the best way to learn a new programming language is to start building stuff, solving problems, using...
2015-12-21
969 reads
What is the current database context?
Every now and again it can be very helpful to know what the current database context is when you are...
2015-12-21
677 reads
Use Compression to Combine Data Quality and Performance
We’ve been using the wrong data types for all the wrong reasons. DBAs, developers, data architects, etc. have all been...
2015-12-21
988 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers