DBCC CHECKDB Azure SQL Database
Who should be running DBCC CHECKDB for Azure SQL Database? Should it be Microsoft or should customers be scheduling it?...
2017-09-04
759 reads
All About SQL
SSMS and MFA support for Azure SQL DB
Quite a mouth full for a title but never the less very exciting. With the new version of SQL Server...
2017-08-30
2,247 reads
[Video] SQL Server Deadlocks
SQL Server Deadlocks – Also known as “The deadly Embrace” occurs when there are 2 processes and neither can advance and...
2017-09-08 (first published: 2017-08-24)
2,004 reads
Azure SQL Database – Scaling up
Scaling up and down your SQL Database is something that is quite common to do. I want to discuss the...
2017-09-01 (first published: 2017-08-23)
1,312 reads
Azure Automation and SQL Index Maintenance
Azure does a lot for your SQL Database, from backups to automatic tuning but it still doesn’t have an index...
2017-08-21
971 reads
SQL Server – So you like to shrink do you?
If you do – shame on you and shame on me because I do.
Moving on, I found strange behaviour within SQL...
2017-08-16
385 reads
Azure Cloud “Fear” Busting #4 – Losing Control?
So the decision to move to the cloud has been made but there is a fear from people that once...
2017-08-25 (first published: 2017-08-14)
930 reads
Interviews and Oranges
What a great topic for this month’s T-SQL Tuesday hosted by Kendra Little https://littlekendra.com/2017/08/01/tsql-tuesday-93-interviewing-patterns-anti-patterns/
The topic being: Interviewing Patterns and Anti-Patterns....
2017-08-08
318 reads
Azure Cloud “Fear” Busting #3 – There is no going back?
Once you go cloud, there is no going back. This is false and from a database perspective you can migrate...
2017-08-07
437 reads
Azure Cloud “Fear” Busting #2 – Seeking for Better Performance
We all want high performing applications and when you are in the cloud that is no different, if anything it...
2017-08-07 (first published: 2017-07-20)
1,378 reads
Blogs
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Generate Embeddings in SQL with Aurora and Bedrock
Most embedding pipelines on AWS have the same shape: a job reads rows out...
Forums
Symmetric Key Encryption
Comments posted to this topic are about the item Symmetric Key Encryption
The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Building Your Own Software
Comments posted to this topic are about the item Building Your Own Software
Question of the Day
Symmetric Key Encryption
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers