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 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 - What are my Trace Flags Enabled on SQL Server?

SQL SERVER – What are my Trace Flags Enabled on SQL Server?

November 2, 2014
Pinal Dave
SQL Tips and Tricks
SQL Server, TraceFlags

A DBA friend wanted to see the trace flags enabled on his production servers. Here is how to find them easily, and a word of caution about using them.

Read More
SQL SERVER - Why my Database is in Restoring Mode After Taking Backup?

SQL SERVER – Why my Database is in Restoring Mode After Taking Backup?

November 1, 2014
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts

Pepper, a SharePoint consultant, asked why her database is in restoring mode after taking a backup. Here is the story and the answer.

Read More
Gouache painting of a row of eight apple trees growing from sapling to tall tree with one red apple on the last

Database Maintenance Checklist: Daily, Weekly and Monthly

November 1, 2014
Pinal Dave
SQL Tips and Tricks
Best Practices, DBA, Maintenance Plan, SQL Backup and Restore

A database maintenance checklist keeps the dull checks from slipping. This post lists what to check daily, weekly and monthly in SQL Server, with one small read-only query for backups, errors, free space, CHECKDB, statistics, growth, logins and patch level.

Read More
SQL SERVER - Answer to Puzzle - ISNUMERIC and Unexpected Results

SQL SERVER – Answer to Puzzle – ISNUMERIC and Unexpected Results

October 31, 2014
Pinal Dave
SQL Tips and Tricks

The answer to my ISNUMERIC and Unexpected Results puzzle: I passed a TAB character and it returned 1. Here is what readers and MSDN say about it.

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
Gouache painting: a row of identical grey pebbles on a pale windowsill, one of them clear glass that catches the light, with a thin vermilion thread tied around it

ISNUMERIC Puzzle: SQL in Sixty Seconds #076

October 29, 2014
Pinal Dave
SQL Video
SQL Datatype, SQL Function, SQL in Sixty Seconds, SQL String

The ISNUMERIC puzzle hides a tab character. Tests on SQL Server 2025 show which strings pass ISNUMERIC but fail TRY_CONVERT, how an empty string and a lone minus sign convert to 0, and how to find control characters in imported data with a short query.

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
Three fountain pens on cream paper with a test ink stroke under each, a hand trying a fourth pen.

Choosing a Database IDE

October 27, 2014
Pinal Dave
SQL Tips and Tricks
Developer, Recommend Tools, SQL Server, SQL Server Management Studio

Choosing a database IDE means testing SQL editing, plans, schema work, security, and team workflow across SSMS, VS Code, and other tools.

Read More
Gouache painting: a wooden seesaw balanced on a log at the edge of a meadow, one end resting low and the other raised, with a small vermilion flag on the raised end

SQL SERVER – How to Flip Value of Bit Field in SQL Server? – Part 2

October 26, 2014
Pinal Dave
SQL Tips and Tricks
SQL Operator, SQL Scripts, SQL Server

Five expressions flip a bit value in SQL Server without a CASE statement. This post runs Vinod Kumar’s four methods and the readers’ answers on SQL Server 2025, shows what each one returns for 0, 1 and NULL, and explains how to flip value of bit field data stored in an integer column.

Read More
Previous 1 … 284 285 286 287 288 289 290 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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