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 - Fix : Error : Login failed for user 'UserName'. The user is not associated with a trusted SQL Server connection

SQL SERVER – Fix : Error : Login failed for user ‘UserName’. The user is not associated with a trusted SQL Server connection

November 2, 2008
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Security

Login failed, not associated with a trusted SQL Server connection? I hit it between SQL Server 2008 and 2005 and fixed it with a matching Windows user.

Read More
Execution plan table shows up.

SQL SERVER – Stored Procedure WITH ENCRYPTION and Execution Plan

November 1, 2008
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server Security

Here is what I found about WITH ENCRYPTION and execution plan: an encrypted SP hides its actual execution plan too. Two sample SPs show it.

Read More
SQL SERVER - Transaction and Local Variables - Swap Variables - Update All At Once Concept

SQL SERVER – Transaction and Local Variables – Swap Variables – Update All At Once Concept

October 20, 2008
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Security, SQL Transactions

Two ideas with examples: transactions have no effect on local variables, and an UPDATE applies all its changes at once, which lets you Swap Variables in one go.

Read More
Gouache painting of a person sorting punctuation into a separate tray beside a database cabinet

SQL Injection: The Joke, the Failure and the Parameter Fix

October 12, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Dynamic SQL, SQL Humor, SQL Server Security

SQL Injection makes a good joke and a terrible incident. The tests here show a concatenated query returning every row for one hostile name, the same text passed as a parameter returning none, a table name caught by QUOTENAME, and a read-only user blocked from dropping a table.

Read More
A hand lifts the corner of a doormat to show bare stone and the faint outline where a spare key used to lie.

Renaming or Disabling the sa Login

October 6, 2008
Pinal Dave
SQL Tips and Tricks
DBA, SQL Login, SQL Password, SQL Server Security

Renaming or disabling the sa login requires a dependency inventory, tested alternate admin access, and monitoring after the change.

Read More
A figure closes red storm shutters on seaside cottage windows facing an approaching storm.

Responding to a SQL Server Security Bulletin

September 30, 2008
Pinal Dave
SQL Tips and Tricks
Cumulative Update, DBA, SQL Patch, SQL Server, SQL Server Security

A SQL Server Security Bulletin should trigger exposure checks, ordered patching, verified recovery, and a clear management update.

Read More
SQL SERVER - Guidelines and Coding Standards Complete List Download

SQL SERVER – Guidelines and Coding Standards Complete List Download

September 25, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Data Warehousing, Database, DBA, SQL Coding Standards, SQL Constraint and Keys, SQL Cursor, SQL Data Storage, SQL Download, SQL Function, SQL Index, SQL Joins, SQL Scripts, SQL Server Security, SQL Stored Procedure, SQL Trigger, SQL Utility

My coding standards complete list for SQL Server, cut to what people follow: naming, formatting, and the rules that prevent real bugs.

Read More
Previous 1 … 43 44 45 46 47 48 49 … 57 Next
  • Books
  • Testimonials
  • Privacy Policy

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