Viewing 15 posts - 1 through 15 (of 697 total)
When you declare @id, its initial value is NULL. When you concat NULL to any other string, the default CONCAT_NULL_YIELDS_NULL connection setting will result in a NULL string.
Initialize @id with...
December 30, 2023 at 9:31 pm
Also check what the product is doing - I've been places where threat scanning involved a product throwing a laundry list of known exploits at each of the SQL Servers...
December 14, 2023 at 6:41 pm
There's a free SQL database option: https://learn.microsoft.com/en-us/azure/azure-sql/database/free-offer?view=azuresql
100,000 vCPU minutes/month, 32GB max DB size. You can set the "Behavior when free limit reached" option to 'Auto-pause the database until...
November 16, 2023 at 4:12 am
You're working too hard. You can do decimal math on datetime values; 1.0 = one full day, 0.5 = 12 hours, etc:
SELECT getdate() AS [Now], getdate() +...
November 15, 2023 at 7:22 am
ADF feels like 'the next version of SSIS, but in the cloud', IMHO. SSIS/SSDT are free; if you have access to materials to help you learn the on-prem tools, then...
November 6, 2023 at 9:23 pm
During restore, the restoring thread will take an X lock on the whole...
November 4, 2023 at 3:53 pm
I previous worked for a very large SaaS software company. Here's the approach they took, which works to solve the A vs B problem:
November 3, 2023 at 7:56 pm
With the exception of adding a step #0 to start the session, I repeated your posted steps on SQL2022 in the same order, Viewing Target Data after the CREATE DATABASE...
November 3, 2023 at 2:01 pm
Did you start the session?
ALTER EVENT SESSION [testsession] ON SERVER
STATE=START;
November 3, 2023 at 3:08 am
Is there a DDL Trigger on the CREATE LOGIN event that's blocking you, either intentionally or because of a bug in the trigger code?
SELECT * FROM sys.server_triggers
October 19, 2023 at 9:04 pm
TDE certificates don't expire (from the docs for CREATE CERTIFICATE - EXPIRY_DATE entry at https://docs.microsoft.com/en-us/sql/t-sql/statements/create-certificate-transact-sql?view=sql-server-ver15): "However, expiration is not enforced when the certificate is used for database encryption...
October 12, 2023 at 1:08 am
IOCP = I/O (disk) Completion Port - After SQL Server makes an asynchronous storage request to the host OS, the OS will return data and notifications through the I/O Completion...
August 29, 2023 at 3:39 pm
CREATE STATISTICS ... WITH AUTO_DROP is only available on AzureSQLDB, Azure Managed, and SQL2022.
The package was created with the wrong target SQL Server version.
August 23, 2023 at 6:23 pm
After booting them out of the ddl_admin role, you can GRANT and DENY permissions to them directly on the Schema, which will carry through all objects within the schema. Include...
August 21, 2023 at 2:34 pm
Note: Availability Groups are Mirroring version 2.x; you can repurpose the mirrors into AGs that include an AG Listener that will redirect clients after a failover.
Convert the separate mirrors of...
August 16, 2023 at 6:11 pm
Viewing 15 posts - 1 through 15 (of 697 total)