T-SQL Tuesday 85 - Backup & Recovery
Shout out to Kenneth Fisher (b|t) for hosting this month's #tsql2sday. This month is about backup and recovery and here...
2016-12-13
275 reads
Blog Posts
Using ReadyRoll to Automate Database Migrations
I like ReadyRoll, and this week at SQL in the City 2017, I get to show some of the product...
2016-12-13
437 reads
A Shortcut for Parameterizing Settings in SSIS
I’ve written quite a bit about the benefit of externalizing changing values in SSIS packages. Moving static values such as...
2016-12-12
348 reads
Combining statement with conditional operators
Operators “AND”, “OR”Sometime we need to combine two or more TSQL statement based on some conditions, that we can achieve...
2016-12-12
229 reads
Database synchronization in the Software Development Life Cycle
Reading the title, most of you are probably thinking: What does database synchronization have to do with the Software Development...
2016-12-12
817 reads
Database synchronization in the Software Development Life Cycle
Reading the title, most of you are probably thinking: What does database synchronization have to do with the Software Development Life Cycle (SDLC)? Stick around, because I'll get to...
2016-12-12
11 reads
How to use DTA (Database Tuning Advisor) with Plan Cache option?
SQL Server 2012 comes up with new workload option in DTA (Database Tuning Advisor). In addition, on existing options File...
2016-12-12
2,650 reads
I use Elastic database pools – for now
When you have many SQL databases that are required to run your environments and they show signs of specific usage...
2016-12-12 (first published: 2016-12-02)
1,442 reads
Manual v Automation
I’ve got my work cut out for me. This week is SQL in the City 2017. One of the sessions...
2016-12-12
492 reads
Monday Coffee 2016-12-12
Speaking and presenting
One of my biggest fears is public speaking and judging by this article, I’m not alone.
However it’s something...
2016-12-12
287 reads
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers