Question We have source control in Visual Studio Database Projects (SSDT). To make cross database references, we utilize something like this below in Project References. We need Project references, since Otherdatabase, can choose between two options at our company. Most of the time, its 90% … [Read More]
Question We’ve been building a replication network of DBs to give us some degree of Always On without paying the full price tag. Currently we have a publisher DB which replicates to a handful of subscribers, so that if the publisher goes down, we can … [Read More]
Back in January, Malathi Mahadevan asked me if I would participate in a book she was working on. The book, “Data Professionals At Work”, is part of Apress Media’s “…At Work” series, an anthology of interviews with Microsoft-focused data professionals
Question We’re working on migrating some SQL Server VMs to Azure SQL Managed Instances. We did an initial backup/restore without a problem: After doing testing, we now need to do a fresh restore from our SQL VMs. We started doing the same process we initially … [Read More]
In 2016, I organized an (unofficial) PASS Summit LGBT Meetup. It was a bit of a last-minute party, and more than once I found myself saying, “Worst case scenario, I’ll end up having a chill cocktail party with some friends.” Turns out, I under estimated … [Read More]
Question I have system where my database gets restored every night, and off late the restore is taking a lot longer from past few days. Here is server config: ES 2637 XEON @ 3.5 Ghz Windows virtual server 2012 R2 hosted in a Hyper V … [Read More]
Question At what size should we consider applying Columnstore Index on a table? Is there a SQL Server storage or design guidance? Our Data Warehouse is 5TB total. Additionally, we have tables which are 100GB to 1TB which compose the database. Just curious if SQL … [Read More]
Question I’m stuck in a way that how to do sum on a column let’s say first column of a table (result from another query) without knowing the column name with something like column position id. it’s something like this Or if it’s in single … [Read More]
On my flight home from a conference in Europe, I found myself watching a documentary on Fred Rogers. This prompted me to reflect on some of the extra special people in my life that have helped me get where I am.
On October 2, 2018 at 11PM EDT, I’ll be joined by John Q. Martin (blog|twitter) for a webinar on Azure SQL Database Managed Instance. To sign up, register here. You can access the recording of the session here. Follow-up Q & A from the live … [Read More]
Copyright © 2025 | Andy Mallon | am2.co