This might help: https://stackoverflow.com/questions/30939180/change-logical-and-physical-file-name-when-deploying-dacpac

I'll post a note and see if anyone has an idea

You are adding the log and data files together?

There might be some rounding here, though that seems high. Can you provide exact values you see and how you are getting...

No simple answer here. Clustering, AGs, both work, but have limitations, pros, and cons. Best bet is to engage a consultant to talk through some ideas for an hour. I...

Redgate's SQL Compare will get the schema back (Disclosure, I work for Redgate Software)

For data, we have data compare, but depending on how much data, this may or may not...

What are you looking to do? If you want to visualize this data, PowerBI can help. If you need to join data from 30 spreadsheet tables because they are all...

GRANT with GRANT was listed at the top. This permission was given.

I don't think you're going to master something. You're doing to dip into a stream, get some skill and competence, and much of that will continue to be valuable over...

Can you explain more what you are doing and seeing? What differences do you see? When you look in the folder, it's unclear what you are checking here. Is it...

This works for me:

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE OR alter PROCEDURE spPackageHistory_Tblu
AS
SELECT GETDATE(), 'test', 'test'


GO

IF EXISTS ( SELECT 1 FROM tempdb.dbo.sysobjects WHERE ID = OBJECT_ID(N'tempdb..#PackageMainTblu') )
DROP TABLE...

There are no service packs anymore, only cumulative updates. The non SA license does get CUs, but it doesn't give you upgrades, and some HA rights. The SA allows you...

I would have thought most people would look to adopt a PaaS approach, often because of cost, but that's not the case. PaaS often requires more application changes and code...

Yep, apparently testing and copy/pasting doesn't work well.

answer edited.

with your permission set, if I grant that to a user, I get this error for the grant for a procedure:

Msg 15151, Level 16, State 1, Line...

A number of people have asked for more programmability, but the QO/QP team needs to support this. They tried functions, but the implementation wasn't good. Even with the changes in...

I've thought about that myself. Power is a big issue out here, but I was considering trying to make a zero energy space with solar, a few batteries, etc.