Viewing 15 posts - 1,996 through 2,010 (of 39,771 total)
Microsoft has published container images for SQL Server 2017 and 2019, but they use their own registry. mcr.microsoft.com
https://github.com/microsoft/containerregistry
If you query from the docker CLI, you can get the tags....
May 12, 2021 at 3:31 pm
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...
May 12, 2021 at 3:25 pm
You can also create a table as:
create table dbo.mytable(myid int)
May 12, 2021 at 3:14 pm
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...
May 12, 2021 at 3:11 pm
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...
May 12, 2021 at 3:05 pm
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
May 7, 2021 at 5:23 pm
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...
May 6, 2021 at 4:14 pm
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...
May 6, 2021 at 4:05 pm
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...
May 6, 2021 at 4:03 pm
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...
May 6, 2021 at 3:59 pm
GRANT with GRANT was listed at the top. This permission was given.
May 6, 2021 at 3:50 pm
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...
May 6, 2021 at 3:49 pm
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...
May 6, 2021 at 3:41 pm
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...
May 6, 2021 at 3:35 pm
Viewing 15 posts - 1,996 through 2,010 (of 39,771 total)