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
Gouache painting: one brass key hanging on a post beside a long row of identical wooden garden gates in a stone wall, every gate ajar, a small vermilion ribbon tied to the key

Add a User Across Databases: A Tested Script With Cleanup

March 9, 2015
Pinal Dave
SQL Tips and Tricks
Dynamic SQL, SQL Login, SQL Scripts, SQL Server Security

To add a user across databases you need one login and, in every chosen database, a user and a role. This post gives a tested script that does it, checks it and removes it again on SQL Server 2025. It also answers the model database question and shows the server-level shortcut.

Read More
One locked garden gate beside another gate with several keys

Interview Question of the Week #010 – What is the Difference Between Primary Key Constraints and Unique Key Constraints?

March 8, 2015
Pinal Dave
SQL Interview Questions and Answers

Compare primary keys and unique key constraints in SQL Server, including NULL rules, foreign keys, and filtered unique indexes.

Read More
Gouache painting: a small wooden pantry shelf with a second overflow shelf beside it, but a single glass jar of preserved lemons sits apart in its own sealed cabinet with a vermilion ribbon

Buffer Pool Extension and In-Memory OLTP: What Each One Caches

March 7, 2015
Pinal Dave
SQL Performance
In-Memory OLTP, SQL DMV, SQL Memory, SQL Server Architecture

Buffer Pool Extension caches clean pages of disk-based tables on an SSD. Memory-optimized tables have no pages, so it cannot hold them. This post proves it on SQL Server 2025 with two tables and read-only checks.

Read More
File permissions window.

SQL SERVER – ReadOnly Databases with ReadOnly File Attribute

March 6, 2015
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore

A reader attached a database that came up ReadOnly and would not switch to ReadWrite. Here is how the ReadOnly file attribute causes it, with repro steps.

Read More
Raw file destination editor.

SQL SERVER – Using Raw Files in SSIS – Notes from the Field #070

March 5, 2015
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SSIS

Tim Mitchell explains how using raw files in SSIS helps when data cannot simply be processed on the fly in a single data flow pipeline.

Read More
SQL SERVER - Database Stuck in “In Recovery” Mode After Restart

SQL SERVER – Database Stuck in “In Recovery” Mode After Restart

March 4, 2015
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore

Is your database stuck In Recovery after a SQL Server restart? I explain the analysis, roll forward and rollback phases and what you can do meanwhile.

Read More
Gouache painting: two armchairs facing each other by a tall window, a small round table between them holding a ring of old keys and a closed padlock; one key tag is vermilion

SQL SERVER – Security Conversations and Notes with a DBA

March 3, 2015
Pinal Dave
SQL Tips and Tricks
SQL Server Security

At a Pluralsight booth, a DBA from the banking world asked me many SQL Server security questions. Here are my notes from those security conversations.

Read More
A selected red cup marks one position within a continuous seasonal storage sequence.

SQL SERVER – Converting YYYYDDD Ordinal Date Codes Safely

March 2, 2015
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL Server

This Julian date example uses an ordinal YYYYDDD code. I distinguish that business encoding from an astronomical Julian day number.

Read More
A music-box mechanism with separate cylinders for repeated passages

Interview Question of the Week #009 – Is GO T-SQL Statement?

March 1, 2015
Pinal Dave
SQL Interview Questions and Answers
SQL Command, SQL Scripts, SQL Server

Explain GO T-SQL confusion with batch boundaries, GO repetition, variable scope, semicolon errors, and a procedure creation example.

Read More
Gouache painting: a long narrow wooden shelf extension built onto a small full pantry cabinet that is too large for the room, one jar with a vermilion lid

Msg 864: Buffer Pool Extension Size Over the Limit

February 28, 2015
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Memory, SQL Server Configuration, SQL Server Services

Msg 864 means a buffer pool extension file is larger than SQL Server allows for the memory in the machine. This post gives the limits, four read-only checks tested on SQL Server 2025, and the steps to start a server that will not boot.

Read More
Previous 1 … 270 271 272 273 274 275 276 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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