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 man laughing.

SQL SERVER – The DBA goes to MARS – Maintenance, Architecture, Research and Support – Notes from the Field #063

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

Stuart Ainsworth tells a captivating story on why the DBA goes to MARS: Maintenance, Architecture, Research and Support, the proactive side of the job.

Read More
Copper seam held by fixed rivets with a new rivet waiting at the end

Append-Only Ledger Tables for Audit Logs That Cannot Be Edited

January 21, 2015
Pinal Dave
SQL Tips and Tricks
SQL Audit, SQL Data Storage, SQL Server Security

Can someone quietly edit your audit table? With an append-only ledger and a stored digest, the answer becomes no, and you can prove it.

Read More
A red windsock stretched straight in a strong wind as a dark storm builds over sunny hills

SQL Agent Alerts for Severity 17 to 25 and Errors 823, 824, 825

January 20, 2015
Pinal Dave
SQL Tips and Tricks
Database Corruption, Database Mail, DBA, SQL Error Messages, SQL Server Agent

Configure Agent alerts for serious severities and errors 823, 824 and 825, connect an operator to Database Mail, and test response delays.

Read More
SQL query window.

SQL SERVER – How to Find Weak Passwords Using T-SQL?

January 19, 2015
Pinal Dave
SQL Tips and Tricks
SQL Server Security

After a hacker got in through the sysadmin account, a reader asked for help. Here is how to find weak passwords for SQL logins using T-SQL.

Read More
One wagon follows a circular track with a switch, illustrating row-by-row work

Interview Question of the Week #003 – How to Write Script for Database Cursor?

January 18, 2015
Pinal Dave
SQL Interview Questions and Answers

Write a database cursor with LOCAL FAST_FORWARD, understand cleanup and fetch status, and compare the loop with a set-based update.

Read More
DBCC PAGE.

SQL SERVER – Watching Table Variable Data in TempDB

January 17, 2015
Pinal Dave
SQL Tips and Tricks
MySQL

Are table variables only in memory? I watch table variable data in TempDB to answer a reader’s questions on where it is stored and if it is logged.

Read More
A small boat entering a harbor alone while two tugboats, one red, guide a large ship and a third waits idle

Cost Threshold for Parallelism and MAXDOP: Setting Both Together

January 16, 2015
Pinal Dave
SQL Performance
MAXDOP, Parallel, SQL Performance, SQL Server, SQL Server Configuration

Review cost threshold for parallelism with MAXDOP, inspect NUMA layout and settings, then measure plans and waits after changes.

Read More
Customer 1 has a total of 3 orders.

SQL SERVER – The Easy Functions of SQL Server – Notes from the Field #062

January 15, 2015
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL DateTime

Kathi Kellenberger, the SQL author who got me hooked early in my career, explains some easy functions of SQL Server that many experts still do not know.

Read More
Errorlog window in the registry editor.

SQL SERVER – How to Increase Number of Errorlog Files

January 14, 2015
Pinal Dave
SQL Tips and Tricks
SQL Log

An audit needed 30 days of ERRORLOG, but a nightly recycle job kept only a few files. Here is how to increase the number of errorlog files in SQL Server.

Read More
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
Previous 1 … 275 276 277 278 279 280 281 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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