A Basic Bot using Azure Bot Services
I wanted to break out my comfort levels and do something different from Azure SQL Database or straight SQL Server....
2017-12-19
584 reads
All About SQL
SQL Server DBCC CHECKDB – Going Parallel
DBCC CHECKDB has the ability to perform parallel checking of objects. However, it absolutely depends on the edition of SQL...
2017-12-18
320 reads
SQL Server Failed to Open Loopback Connection – What?
I could not read my error log on one of my local SQL Servers, when I executed the following code:
EXEC...
2017-12-12
823 reads
Moving to an Azure SQL Database via Command Line
I have moved many databases to Azure via different methods but I recently came across a new way. Well technically...
2017-12-19 (first published: 2017-12-07)
1,556 reads
Azure SQL Database – Using sp_BlitzIndex
I was doing some normal activities on one of my Azure SQL Databases, I went to make a cup of...
2017-12-14 (first published: 2017-12-05)
1,701 reads
I have a new Passion
Yes, I like to blog, maybe slightly more on Azure than SQL Server. I enjoy it and it probably explains...
2017-11-28
361 reads
Azure SQL Database – Service Tiers
Naturally the cost of Azure SQL Database directly relates to what tier and performance level you are using. Starting from...
2017-11-23
491 reads
SQL Server – DBCC CHECKTABLE
If you know about DBCC CHECKDB then most likely you will know about DBCC CHECKTABLE. Quite simply this command performs...
2017-11-20
462 reads
Azure SQL Database Alerting
It’s good to be proactive and one way is to setup alerts and it is no different when using Azure...
2017-11-16
512 reads
Folks Who Have Made a Difference
TSQL Tuesday time hosted by Ewald (https://sqlonice.com/tsql-tuesday-96-folks-who-have-made-a-difference/) and quite simply one man has morphed me into who I am today...
2017-11-14
319 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