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
A hand passing a small red bowl of sugar between two facing kitchen windows, house keys left on a hook.

OPENROWSET vs Linked Servers: Querying Another Server Safely

January 13, 2015
Pinal Dave
SQL Tips and Tricks
Ad Hoc Query, Linked Server, SQL Server, SQL Server Security

Compare OPENROWSET and linked servers, inspect login mappings, keep filtering remote, and review authentication and encryption before use.

Read More
BimlScript connections.

SQL SERVER – Iterating over Metadata with BimlScript – Notes from the Field #061

January 8, 2015
Pinal Dave
SQL Tips and Tricks
BIML, Notes from the Field, SQL Server Security

Reeves Smith continues his Biml series and shows how iterating over metadata with BimlScript helps automate repetitive SQL Server BI work.

Read More
SQL SERVER - Performance Tuning - Is It Really A Top Skills for a SQL Server Consultant? - Notes from the Field #059

SQL SERVER – Performance Tuning – Is It Really A Top Skills for a SQL Server Consultant? – Notes from the Field #059

December 25, 2014
Pinal Dave
SQL Performance
Notes from the Field, SQL Server Security

The world needs more Performance Tuning consultants, but is tuning really the top skill for a SQL Server consultant? Brian Moran answers from a business view.

Read More
Gouache painting of a shut boat shed door with a padlock and a red key on a hook beside it

Operating System Error 5 on Backup: Fix Access Denied

December 10, 2014
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Error Messages, SQL Server Security, SQL Server Services

Operating system error 5 means Windows refused the SQL Server service account access to a backup folder. This post reproduces the error, shows how to find the account with a query, grants the permission, and explains the look-alike errors for missing paths and mapped drives.

Read More
SQL SERVER - Beginning with SQL Server Security Aspects

SQL SERVER – Beginning with SQL Server Security Aspects

December 3, 2014
Pinal Dave
SQL Tips and Tricks
Devart, SQL Server Security

A high-level overview of SQL Server security aspects and best practices, starting with the often overlooked physical security of the server itself.

Read More
Gouache painting of a row of closed wooden shutters on a plaster wall, with one small shutter opened a hand-width and a vermilion flowerpot on its sill

Msg 230: A Column Level GRANT Overrides a Table DENY

November 21, 2014
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server Security

A column level GRANT overrides a DENY on the whole table in SQL Server. A friend challenged my earlier claim that DENY always wins, so I built a repro. The granted column works, and every other column raises Msg 230.

Read More
SQL SERVER - Common Sense Data Security - Notes from the Field #055

SQL SERVER – Common Sense Data Security – Notes from the Field #055

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

Kevin Hazzard explains common sense data security for sensitive user information, with humor and real world examples you will recognize.

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

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