Understanding the importance of key length with the SQL Server asymmetric encryption algorithms

K. Brian Kelly is trying to use SQL Server's built-in encryption and sees there are three different options available for an asymmetric key, corresponding to key length. What's the impact of the key length?

Automated Trigger To Require a WHERE Clause

Learn how you can build triggers that prevent an update or delete statement from being run without a WHERE clause in this article.

Would You Choose SQL Server?

This Friday Steve Jones has a poll asking how you feel about SQL Server for your own projects, or even your company's projects. Is it a given you'd use SQL Server?

SSIS 2012 - Using PowerShell to Remotely Execute File System Packages

A Powershell script that allows you to execute SSIS packages using the traditional Package Deployment Model can be very useful. But what do you do when the execution isn't triggered by the same computer where the target package resides? Marcin Policht offers a solution.

Survey: Help Improve SQL Doc

Do you use SQL Doc? We're building the new version, and we'd like your help. Complete the survey for a chance to win a $50 Amazon voucher.

10 Myths about Backups in SQL Server

Let's dispel a few myths about backups in SQL Server.

Introduction to SQL Server Check Constraints

Check Constraints play a very important role in SQL Server as it allows data validation rules to be imposed at the SQL Server instance level itself instead of writing rules for each application.

SQL Saturday #233 Oklahoma City

SQL Saturday comes to Oklahoma City on August 24th for a free day of SQL Server training and networking. This event also features a paid-for pre conference session on Friday with Bill Pearson on Practical Self-Service BI with PowerPivot for Excel.

SQLServerCentral.com Users Survey 2013

We want to make sure we're covering the things that are relevant to you, so we're asking for some feedback on what you use on SSC, where we need to improve, and what you'd like to see.

It should only take a few minutes, and three randomly-selected people will win a $100 Amazon gift card for their efforts.

The Standard Limitation

SQL Server Standard Edition only supports 64GB of RAM and it's our fault. Or is it, and is this a reasonable number? Steve Jones has a few thoughts today.