You can. If you use Transparent Data Encryption, then everything is encrypted and Excel can just query.

If you want just specific columns, you likely will want a stored procedure to...

You can also create a table as:

create table dbo.mytable(myid int)

You will have to understand what type of encryption is being used. If PHP is doing the encryption, then you may or may not need to decrypt the data. You...

First, there is no first and second records. Records in a database have no ordering. You'll have to better explain what you are looking for here, or what results are...

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...