Review Your Code
Steve Jones notes that SQL Injection is still a problem, and while it might be for some time to come, we should not be adding to the issues. Learn how to write secure code.
The Basics of Good Negotiations Webinar
This PASS VC Webinar will take place August 14, 1PM EDT. Creatively resolving differences and negotiating mutually beneficial agreements is crucial in all walks of life. It’s especially important and challenging in the IT industry where soft skills are not necessarily prevalent. ??In this session, we’ll introduce the basic concepts and precepts that will aid you in negotiating better agreements with your neighbors, peers and co-workers, and even your boss.
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.
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.
Blogs
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Who’s the Winningest Coach (with AI Help)
By Steve Jones
I was listening to the radio the other day and the hosts were discussing...
Learning from Mistakes: T-SQL Tuesday #194
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
Forums
What is Page Density
Comments posted to this topic are about the item What is Page Density
T-SQL in SQL Server 2025: Fuzzy String Search II
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Azure-SSIS, Self-Hosted Integration Runtime, & Data Gateway?
Looking to confirm my understanding of these three products and how they can be...
Question of the Day
What is Page Density
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers