Marko Parkkola from Finland shares a best practice for enumerations in relational database design: the right way to store them and one clearly wrong way.
SQL Injection: How It Works and How to Stop It
Prevent SQL injection by separating values from command text, parameterizing dynamic SQL, and validating object names before using QUOTENAME.
Modeling Data Before Writing Tables
Modeling data before tables clarifies entities, relationships, keys, and grain so schema changes do not discover the rules too late.
SQL SERVER – INSERT TOP (N) INTO Table – Using Top with INSERT
INSERT TOP (N) INTO a table is not the same as INSERT with SELECT TOP (N). My example from a client training shows how the two methods differ.
The First Hour on a Server Nobody Can Explain
Investigate a slow SQL Server in a fixed order, checking connectivity, blocking, waits, plans, and storage before changing the environment.
SQL SERVER – Get Server Version and Additional Info
Most people check the SQL Server version with @@VERSION. I also like xp_msver, which shows extra details about the server where SQL Server is installed.
SQLAuthority News – 1200th Post – An Important Milestone
My 1200th post, on the last day of 2009, looks back at a wonderful year and lists my top 7 community and personal events in the order they happened.