When should I test?
To test or not to test. That is the question. Or is it? Shouldn’t we always test? That was the...
2016-03-30
794 reads
SQL Agent Job Schedules
SQL Agent job schedules should be easy to read for humans if for nothing else than the fact that you have to provide this information to the auditors from...
2016-03-29
8 reads
SQL Agent Job Schedules
Many moons ago, I posted a script to help report on the human friendly scheduling information for SSRS subscriptions. You...
2016-04-12 (first published: 2016-03-29)
2,629 reads
Certain DBs in an AG not Backing Up
Last week, I received an alert that the percentage of transaction log in use on one of our production databases...
2016-03-29
998 reads
My latest presentations
I frequently present at user groups, and always try to create a brand new presentation to keep things interesting. We...
2016-03-29
918 reads
Monday Morning SQL Break – March 28, 2016
It’s Tuesday, and the Monday post is late. A weekend of smoking quite a few pounds of pork kept me in...
2016-03-29
932 reads
Protecting the SA Account
The sa account is a well, known, built in account for SQL Server. Years ago, in previous
versions, I’d see...
2016-03-29
973 reads
SQL Server 2016 features: Query Store
Given that SQL Server 2016 is coming ‘real soon now’, it’s probably well past time that I write up some...
2016-03-29
492 reads
SQL Server 2016 features: Query Store
Given that SQL Server 2016 is coming ‘real soon now’, it’s probably well past time that I write up some...
2016-03-29
957 reads
Update to TRUNCATE TABLE in SQL 2016 (partition support)
Continuing my obsession with partitioning I thought I’d write this quick post about a cool change in SQL Server 2016.
This...
2016-04-12 (first published: 2016-03-29)
2,802 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