This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
SQL Server Management Studio window.

SQL SERVER – Validation Rules: Code or Database? – Notes from the Field #054

November 13, 2014
Pinal Dave
SQL Tips and Tricks
BIML, Notes from the Field, SQL Server Security

Should validation rules live in the .NET app layer or in the database? G. Andrew Duthie looks at this common argument between developers and DBAs.

Read More
A man laughing.

SQL SERVER – Using Bitwise And (&) Instead of a Junction Table – Notes from the Field #053

November 5, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Server Security

Stuart Ainsworth shows a cool trick: using Bitwise And (&) instead of a junction table to get more performance with fewer code changes.

Read More
A bowl of identical red keys by a front door, a guest's hand taking one

Linked Server Logins: Stop Mapping Everyone to sa

November 3, 2014
Pinal Dave
SQL Tips and Tricks
Linked Server, SQL Login, SQL Server, SQL Server Security

Audit linked server logins for blanket remote sysadmin mappings, test with a low-privilege identity, and replace broad access safely.

Read More
Sql server table valued constructors.

SQL SERVER – Beginning Table Valued Constructors – Notes from the Field #052

October 30, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Server Security

Kathi Kellenberger explains Table Valued Constructors, a relatively unknown topic, in the 52nd episode of my Notes from the Field series.

Read More
Upside-down glazed bowl showing its original clay foot ring

Audit Triggers That Record the Real User Behind EXECUTE AS

October 28, 2014
Pinal Dave
SQL Tips and Tricks
SQL Audit, SQL Server Security, SQL Trigger

Your audit table says dbo for every change, and nobody can tell who really did it. Here is how to capture the person behind EXECUTE AS.

Read More
A temporary wooden footbridge crosses a river from an old cottage to a newly built house.

Extended Security Updates Explained

October 12, 2014
Pinal Dave
SQL Tips and Tricks
SQL Licensing, SQL Migration, SQL Patch, SQL Server, SQL Server Security

Extended Security Updates give eligible older SQL Server releases limited critical security coverage while you complete a migration.

Read More
SQL SERVER - Tuning Queries is Sometimes Waste of Time - Notes from the Field #049

SQL SERVER – ​Tuning Queries is Sometimes Waste of Time – Notes from the Field #049

October 9, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Server Security

Brian Moran explains why tuning queries is sometimes a waste of time when you are trying to fix performance and scalability problems in SQL Server.

Read More
Previous 1 … 26 27 28 29 30 31 32 … 57 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com