Syncing Releases
Is the future for product releases and upgrades, to be synchronized with point releases? Steve Jones relishes the possibility.
2009-06-03
569 reads
Articles
Syncing Releases
Is the future for product releases and upgrades, to be synchronized with point releases? Steve Jones relishes the possibility.
2009-06-03
586 reads
Tracking and Reporting Database Growth
An article from new author Lokesh Gunjugnur that shows how you can set up tracking for database growth on multiple servers and creating custom reports in Excel.
2009-06-02
14,566 reads
DBA:M and the SQL Backup 6.0 pre-release
Rodney Landrum, DBA manager in Pensacola, Florida, puts the pain of DBA:M into context as we learn about how SQL Backup can evolve to keep pace. Take a look at the changes we’ve got planned to help time-pressed DBAs in the forthcoming pre-release of version 6.0, including a new compression level and network resilience.
2009-06-02
2,217 reads
Formatted date in SQL Server 2008
Learn how to get most of the formats required by different countries and applications, using one common date function.
2009-06-02
3,748 reads
Introduction to SQL Server 2008 Extended Events
SQL Server 2008 Extended Events are the new low level, high performance eventing system in SQL Server. They use less system resources and provide better tracking of SQL Server performance than previous methods like Perfmon and SQL Trace/Profiler events.
2009-06-02
2,515 reads
The Problem Is You
Why doesn't SQL Server just run smoothly after it's installed? Steve Jones thinks the problem is you.
2009-06-02
97 reads
The Problem Is You
Why doesn't SQL Server just run smoothly after it's installed? Steve Jones thinks the problem is you.
2009-06-02
333 reads
The Problem Is You
Why doesn't SQL Server just run smoothly after it's installed? Steve Jones thinks the problem is you.
2009-06-02
89 reads
Why I Say Something about Running as Administrator
On a couple of recent webcasts, I pointed out the folks were running with the local Administrator account. To start this out, I'm not a big fan of security by obfuscation. Security by obfuscation (not code obfuscation, but security by obscurity, if...
2009-06-02
2,556 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