Top 5 SSMS Time Saving Tips
In this article we look at how you can use SSMS to filter objects, debug, drag and drop object names, add custom reports and use of operators for emails.
2020-10-15
Articles
What is Oracle ASM to Azure IaaS?
Kellyn Pot'Vin-Gorman explains Oracle Automatic Storage Management and why it’s impossible to do a comparison to Azure IaaS.
2020-10-14
What’s new in Flyway 7.0
Flyway version 7.0 has just been released, and with it comes brand new features that enhance deployment flexibility. Version 7.0 also introduces Flyway Teams, which combines the Pro and Enterprise editions into one comprehensive offering. Join us today at 4pm BST to find out more.
2020-10-14
Branching in Git with SQL Database Projects
Learn how to use Git with SQL Server Data Tools to allow branching for development and how to merge development changes.
2020-10-13
2020-10-12
1,984 reads
Computed Column Performance in SQL Server
Computed columns may be the cause of hard to track down performance issues. In this article, Robert Sheldon reviews the issues and some ways to get around them.
2020-10-12
Create AT&T Network Hierarchy Diagrams using SQL Server Data
Diagrammatic support for large, complex hierarchical data structures in SQL Server.
2020-10-09 (first published: 2018-09-04)
3,262 reads
Auto Scaling Azure SQL DB using Automation runbooks
Learn how to auto scale an Azure SQL Database with Azure runbooks and using an existing runbook from the runbooks gallery.
2020-10-09
Welcome to Redgate Deploy and Cross-platform Database DevOps
Until now, organizations wanting to introduce database DevOps have had to rely on – and purchase – different tools and solutions for different databases. A new cross-platform database DevOps solution, Redgate Deploy, changes the rules. Find out why in this latest blog post.
2020-10-09
PowerShell Day by Day: Filtering Objects
In my last article, The Basics of PowerShell Day By Day, I covered some basics of getting started. These articles aren't intended to replace some of the getting started information in things like the Stairway to PowerShell. Instead, I am covering some of the tips, tricks, techniques, and bits of knowledge that I wish I'd […]
2020-10-08
2,912 reads
Blogs
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
Have a Plan for Your Personal Downtime
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Forums
PowerQuery.... don't meet SSIS
I have a powerQuery that reads and transforms a table in a PDF. Works...
Count of Total Appointments within 30 days of each Appointment Date
Good Afternoon. I have a Table where each Record: 1) Represents an Appointment. 2)...
Reporting Services in Managed Instance
Hi , one of my on-premises servers one server is having databases and one...