The Ongoing Costs of Building Software
There are lots of costs to building your own software, which Steve Jones notes might not be what you want to spend over time.
2019-09-05 (first published: 2016-01-13)
313 reads
Editorials
20 Years of Compare
When we started SQLServerCentral, there were originally 7 of us. We all decided to "invest" $50 to get the site going. With this seed money, we paid for a VM that hosted both SQL Server and IIS. This was enough money to run the site for 6+ months, and we set about building an online […]
2019-09-04
271 reads
2019-09-03 (first published: 2015-08-25)
273 reads
Too much information can be counter-productive
If you want to be an effective communicator focus on what your audience need to hear rather than what you want to say
2019-09-02 (first published: 2016-01-29)
378 reads
Always Check on the Basics
The basics are important, especially with regards to backup and restore in SQL Server.
2019-08-31
358 reads
Do You Deal with UTF-8?
UTF-8 is coming to SQL Server. Steve wonders today how many of you look forward to this, or if you are aware of potential issues.
2019-08-30
332 reads
Grounded
Some laptops are being banned from flights. This could be a hassle, but more, how can anyone tell if you have a banned one?
2019-08-29
420 reads
Protecting Code
We not only need to protect our systems, but the source code as well. Not for IP reasons, but for security.
2019-08-28
242 reads
Should Salary Information Be Confidential?
Today we have a guest editorial from Andy Warren as Steve is away from the office. Salary is a difficult topic for many, but Andy shares some thoughts.
2019-08-27 (first published: 2015-06-05)
622 reads
Growing and Changing
It can be hard to let go of old knowledge and try something new, but we need to find a balance.
2019-08-26
180 reads
Blogs
Generate Embeddings in SQL with Aurora and Bedrock
Most embedding pipelines on AWS have the same shape: a job reads rows out...
Resolving SQL Server Transaction Log Issues Efficiently
By Arun Sirpal
Transaction log issues are one of the quietest ways a healthy database turns into...
Adding an HTTP MCP Server to VSCode
By Steve Jones
I wrote earlier this week about the SQL MCP Server using the Data API...
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