Adding Reporting Services to an existing SQL Server installation
In this tip we look at the process of installing Reporting Services on a server that is already running Database Services.
Configuring SQL Server memory settings
Learn about SQL Server memory needs and settings including RAM amounts, how to enable AWE, maximum server memory and the differences of 32- and 64-bit platforms.
It's the Bits
A woman sues Best Buy for $54million. That's absurd, but her laptop is worth more than the hardware.
It's the Bits
A woman sues Best Buy for $54million. That's absurd, but her laptop is worth more than the hardware.
It's the Bits
A woman sues Best Buy for $54million. That's absurd, but her laptop is worth more than the hardware.
Locking Your Disk
How important is disk encryption to you? Do you think about all those replicated or copied databases on laptops? Let us know. This editorial was originally published on Feb 28, 2008. It is being re-run as Steve is on holiday.
Monitoring and Recording DDL changes on SQL 2005 (NARC)
Auditing activities on your database servers becomes more important all the time. But ensuring that schema changes do not occur without your knowledge may be more important for a stable system. James Greaves brings us a great technique using DDL triggers for doing this.
Practical Methods: Naming Conventions
Everyone should establish some sort of naming convention for their SQL Server platform. It helps to ensure that developers and DBAs can easily find objects and communicate with one another. New author Michael Lato brings us the start of a series on organizing your SQL Server code with an article on naming conventions.
Using Parameters with Stored Procedures
It seems that SQL Server developers avoid stored procedures whenever possible, especially if they are new to the product. Kathi Kellenberger brings us a basic article that you can give to developers that explains the basics of how you use parameters with ADO.NET, especially output parameters.
Check List for Performance Optimisation in SQL Server Analysis Service 2005
This article is a step-by-step checklist to help ensure that you are obtaining the maximum performance possible from SQL Server Analysis Services.
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