Database Maintenance Without Breaking The Bank
Database maintenance does not have to be expensive. There are free tools out there that will make your life easier. Of...
2018-02-22 (first published: 2018-02-13)
3,169 reads
Blog Posts
dbachecks – A different approach for an in-progress and incremental validation
dbachecks is a new PowerShell module from the SQL Server Community! For more information, read introducing dbachecks. If you don't...
2018-02-22
504 reads
dbachecks – Configuration Deep Dive
Today is the day that we have announced dbachecks a PowerShell module enabling you to validate your SQL Instances. You...
2018-02-22
1,072 reads
dbachecks – Using Power BI dashboards to analyse results
For the last couple of months, members of the dbatools team have been working on a new PowerShell module called...
2018-02-22
862 reads
Log Shipping – Error: Failed to update database “DATABASE NAME” because the database is read-only
Here’s a strange one that I’ve recently come across. I had a customer report that their log shipping restore jobs...
2018-02-22
737 reads
Obsessing over query operator costs
A common problem when looking at execution plans is attributing too much meaning and value of the costs of operators.
The...
2018-02-22 (first published: 2018-02-13)
2,209 reads
4 Rules of Right When Running a Query
Last month in January, I participated in the Idera #sqlchat. This is a monthly chat meeting that is organized by...
2018-02-21 (first published: 2018-02-09)
3,119 reads
Activate Conference 2018: Three days of Tech Learning
Tomorrow I'll be giving two workshops at the super-slick-brandedActivate Conference 2018 in Baton Rouge at the Louisiana Technology Park, a...
2018-02-21
287 reads
Automating Database Deployment: Part 3 Running RoundhousE
Now that we have a basic understanding of RoundhousE database deployment from the first two parts of this series let’s get to the good stuff. If you haven't read...
2018-02-21
31 reads
Azure SQL Elastic Pools
In this video tutorial David talks you through the benefits of Azure SQL Elastic pools. Elastic pools allow you to...
2018-02-21
726 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers