|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Disabling the CEIP | |
Under what situations can I disable the CEIP service? | |
Think you know the answer? Click here, and find out if you are right. |
Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
Checking Digital Signatures I have some character data in a table that is signed by a certificate. The signature is also stored in a table. How can I check that the data hasn't changed? Answer: Run VERIFYSIGNEDBYCERT() with the cert, the data, and the signature values Explanation: There is a way to do this. The VERIFYUSIGNEDBYCERT() function will check data against a signature, given the cert. Ref: VERIFYUSIGNEDBYCERT() - https://learn.microsoft.com/en-us/sql/t-sql/functions/verifysignedbycert-transact-sql?view=sql-server-ver16 |
Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Administration |
SQL Server Windows NT - 64 bit" in Task Manager: CPU high - Hello , The SQL Server Windows NT - 64 bit" in Task Manager: CPU high 56,961 MB , the overall server CPU is now 95 % kindly advise the solution. |
SQL Server 2016 - Development and T-SQL |
Create SFX Archive - 7zip in SSIS? - Hi everyone, I have created some XML files via SSIS package and compressed them as well using 7-zip. There is an option in 7-zip to Create SFX Archive which converts the .7z file to .exe How can I achieve this from SSIS? |
Grant user permissions to a view but the base tables live in another database - I have two databases on the same server. I have a service account I want to have access to SELECT off some view in the "Staging" database. The view calls on tables in our Finance database. If I run the SELECT as myself or other "normal" users it works fine because those accounts have access […] |
The ORDER BY clause is invalid in views - Hi, I'm trying to run the below SQL code but I'm getting this error: An error occurred while checking the query syntax. Errors: The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified. I'm still learning SQL so any […] |
Administration - SQL Server 2014 |
Restore Stumper - Metadata error - I am attempting to restore a database from a server in one domain to another. The Source server is 2014 (SP3-CU4-GDR) (KB5014164) - 12.0.6439.10 (X64) Dev edition and the destination server is the same, the only difference being that the source server has the DB as part of an AG and the destination has no […] |
SQL Server 2012 - T-SQL |
find missing records - I want to find all customers that have a certain prlist, but within that same customer grouping that don't contain records for prlist like (cb% or ab%) In the example provided Customer 123 matches and would be excluded from my output list. Customer 347 has the pli-(prlist), but doesn't have the others like (cb% or […] |
SQL Server 2019 - Administration |
Crashed OS, now SQL will not accept inbound connections - Hi, We have a VM running SQL. This VM crashed and since coming back up we cannot connect to the SQL instance running on it from outside of the VM itself. SSMS works fine when connecting to the local instance. Also, the SQL Server service will now only start if the domain account used is […] |
Change tracking - Date a row changed - We have change tracking enabled on one of our databases and I am looking for a query where I could get the timestamp/date on when a row changed. Any help is greatly appreciated. Thanks a lot. |
Data replication tools and review - Hello expertise, Could you please suggest best tool for database replication? data replication on transactional basis and using for filtering option like DELETE transaction not replicate to target database due to data should maintain long term in target database instance. Thanks. |
SQL Server 2019 - Development |
Problem extracting Data from JSON string - Hi there I have a JSON sample and struggling to extract data from it. This is my query Declare @JSON varchar(max) SET @json = N' { "ChannelReadings": [ { "ReadingsDto": [ { "Si": 54.03, "Raw": 0, "Conversion": 0, "TimeStamp": "2022-04-22T14:20:57" }, { "Si": 53.97, "Raw": 0, "Conversion": 0, "TimeStamp": "2022-04-22T14:22:57" }, { "Si": 54.01, "Raw": […] |
I must be loosing my mind. Odd data issue - I have a guest table on two servers. Call them prod1 and prod2. The Prod1 database is backed up and restored to the prod2 server everyday. The backup starts around 11 pm and the restore the prod2 finishes around 10:30 am --this is to check what records exist on prod1 that dont exist on prod2 […] |
How to insert data from same set of tables selecting different id from the same - I am trying to insert same set of records with student id 1234 (All 4 records with student id 1234 needs to be inserted into same table but instead of student id 1234. i want the id to be selected 9876) Below is the sample data Student ID 1234 below points to specific case from […] |
Increment max value by over a complete dataset - In a weird situation where I have limited say in the ultimate solution. Switching from a table with an identity column to a table that does not have an identity column, odd I know. I can get the MAX(ID) with out an issue. I am having issues generating the next set of IDs for the […] |
How to run a query multiple times with different values in date - I'm very new to the sql and am wondering what is the easiest way to run the same query multiple times with different dates (ideally is the last day of each month). Can I create a loop so that I don't need to manually change the value in Date? Values in date are 31Jan2022, 28Feb2022, […] |
Amazon AWS and other cloud vendors |
Version Controlling Lambdas - I know there are lambda versions. But I want to know if this can be done using GitHub, can we integrate it with CodePipeline and create something like a centralised repo for all our Python lambdas and then update those functions with every push. |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |