|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
The Migration Tool to Use II | |
Which migration tool is suited to migrate DB2 to an on-premises SQL Server? | |
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) |
Regenerating the Master Key I have a database encrypted with TDE. I want to regenerate the database master key and use the new key to protect the certificate. What should I do? Answer: run alter master key with regenerate Explanation: The database master key is one part of the TDE hierarchy and only protects the certificate used to encrypt the DEK. The ALTER MASTER KEY WITH REGENERATE will create a new master key nad move the encryption to the existing certificates (and other keys). Ref: ALTER MASTER KEY - https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-master-key-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 |
MDF size increasing without table size increase - We have a database whose data file size was 1500 GB and used space within the file was around 900 GB on Friday. Today when I checked, the file has grown to 5200 GB and it is growing continuously. When I did the breakup of table sizes, its still 920 GB, which is expected. How […] |
SQL Server 2016 - Administration |
Node quarantined status not cleared - Hi, Two node AG cluster nodes . one of the node went to quarantined state due to we had network issues multiple times. Quarantined state remain same more than 14 hours. Node status green color up & running also cluster resource online and AG role also running. I tried below PowerShell commands Get-Cluster | Format-List […] |
SQL Server 2016 - Development and T-SQL |
Query for abnormal differences / find ouliers - Hi , I am trying to build a query that will identify 'abnormal' differences in the values column between each successive date record available for each individual account. The table will have multiple accounts and I want to identify the abnormal differences. The difference threshold to be identified is an absolute value of 80. thanks […] |
SQL Server 2019 - Administration |
Need TABLE DDL to define finite list of column values - Looking for sample DDL syntax to CREATE a TABLE w/ a COLUMN that includes list of finite values. For example, I only want 4 allowable SQL Versions stored in the column SQLServerVersion below. What is the correct DDL to accomplish this? CREATE TABLE MyTable (ID INT IDENTITY(1,1) NOT NULL, MySQLServerName NVARCHAR(40) NOT NULL, SQLServerVersion NVARCHAR(40) […] |
how to remove schemabinding from all functions and view in one go. - I want to remove the schema binding from all my functions, then want to apply but in one go, how can it be done? 2) I have few cols with columns in my database where collations is specified, i want to remove them in one go, how both things can be done with few […] |
last time index was re-org or rebuilt? - i'm unable to find such script online. i found some that had last stats updated but it's not the same thing i'm looking for. any ideas/suggestions? thx |
ACCELERATED_DATABASE_RECOVERY and increase in database size - Hello , I am looking please for your feedback on the activation of "ACCELERATED_DATABASE_RECOVERY" In SQL server 2019 Especially on the size of the database because I'm worried if I see this SQL Server 2019 - Bug? Databases Auto Growing Out of Control Thanks |
SQL on Virtual Machine - Hello Fellow Database Enthusiasts, I am an old guy and virtual machines are new to me, normally on a SQL server installation that you are going to have several or more instances running, you would have separate partitions that the instances are installed on, is that necessary on a VM machine running Windows server 2019? […] |
SQL Server 2019 - Development |
Renaming JUST THE EXTENSION OF multiple files in a folder using SSIS - Hi, I have three files in a folder - SourceFolder ABC.edifact DEF.edifact NJF.edifact I need to rename these three or more files which drop into the above folder every day to ABC.txt DEF.txt NJF.txt The folder should remain the same, I just need to rename the extension of all files in a folder. I tried […] |
Problem : Passing a Variable is not working in Dynamic Query - Hi all, I am not able to pass the table name as a constant in Dynamic Query: The logic is to loop through a list of tables name stored in a table 'tbl_names' and produce an output of tbl_name, row count My code is a follows: /* Table tbl_names has 3 column (id, tbl_name varchar […] |
Unable to add NOT NULL constraint (Msg 102, Level 15, State 1) - Beginner here and trying to solve a problem from which I cannot find any clear solutions. I am supposed to alter a table. I am supposed to add two constraints, these being the addition of a primary key and the addition of a foreign key (Some_ID). However, Some_ID is NULL and I am supposed to […] |
Pivot columns to get 0 /1 flag columns - Hi, I have a dataset of employees with different "Paytypes" in a single column. I am trying to pivot the table on the Paytype column so that each paytype can be treated as a flag column, i,e, the only possible values in this column should be 1 or 0 Below is a sample code with […] |
Amazon AWS and other cloud vendors |
AWS Managed Grafana authentication - Hello. I have built a small project where I call Lambda which parses some data from a website with Selenium and then stores the results to RDS (Postgres). I'd like to visualize this data. It is timeseries data, so I would need something where I can drill down to a certain date, month, year... So […] |
Reporting Services |
world map and errors loading map for VS 2022 - [Updated 9/6/22] What is the easiest way to get a world map into the map gallery so that I can embed into my report? Also, Using Visual Studio 2022. Any map I load from the map gallery (US only maps there), I get an error when previewing the report: "An attempt was made to load […] |
General |
What should I have done with this? - I received this in the mail today. Any thoughts? |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |