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 of three small podiums in a courtyard beside a round table with a red cloth and four chairs

How to Give a Technical Demo That Doesn’t Break

April 10, 2010
Pinal Dave
Personal
Career Advice, SQL Training, TechEd

A Technical Demo fails for a few predictable reasons, and most of them can be fixed before you start. This guide covers rehearsing on the exact machine, numbered scripts with a reset file, readable screens, an early room check, a recorded backup and what to say when something breaks live.

Read More
SQLAuthority News - Meeting with Allen Bailochan Tuladhar - An Unlimited Experience

SQLAuthority News – Meeting with Allen Bailochan Tuladhar – An Unlimited Experience

April 9, 2010
Pinal Dave
SQLAuthority News
MVP, SQL User Group, SQLAuthority Author Visit

My 9-day trip to Nepal with Allen Bailochan Tuladhar, who keeps Nepal’s tech community moving. Every day was a new lesson, truly an unlimited experience.

Read More
SQLAuthority News - Author Visit Review - TechMela Nepal - March 29-30, 2010

SQLAuthority News – Author Visit Review – TechMela Nepal – March 29-30, 2010

April 8, 2010
Pinal Dave
SQLAuthority News
MVP, SQLAuthority Author Visit

My review of TechMela Nepal in Kathmandu, March 29 to 30, 2010: around 500 students, hundreds of tech professionals and nine great days with Allen Tuladhar.

Read More
SQLAuthority News - Milestone of 1300th Post and A Few Updates

SQLAuthority News – Milestone of 1300th Post and A Few Updates

April 7, 2010
Pinal Dave
SQLAuthority News

My 1300th post looks back at how SQLAuthority began as a list of personal bookmarks and scripts, and shares a few updates about the blog.

Read More
A single occupied phone box with one person's coat visible and a queue rail outside it

What Is Locking and Blocking in SQL Server?

April 6, 2010
Pinal Dave
SQL Performance
Best Practices, Database, SQL Performance, SQL Server

Locking and blocking are not the same thing, and the difference is the whole subject. I blocked a session on purpose and read it from the DMVs. Why short blocking is healthy, and why NOLOCK fixes nothing.

Read More
Size of disk.

SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot

April 5, 2010
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Data Storage

A Snapshot database is a read-only, static view of a source database. I explain how it works and how to restore a database from a snapshot.

Read More
SQL SERVER - Enable Identity Insert - Import Expert Wizard

SQL SERVER – Enable Identity Insert – Import Expert Wizard

April 4, 2010
Pinal Dave
SQL Tips and Tricks
SQL Identity, SQL Server, SQL Utility

An SSIS package failed with an identity error because both tables had identity columns. Checking Enable identity insert in the Import Expert Wizard fixed it.

Read More
SQL SERVER - Difference Between GRANT and WITH GRANT

SQL SERVER – Difference Between GRANT and WITH GRANT OPTION

April 3, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server Security

What is the difference between GRANT and WITH GRANT? Only WITH GRANT OPTION lets a user pass the same permission on to other users.

Read More
Gouache painting: on a joiner's bench, a stout beam end has one dovetail-shaped socket

ISJSON Type Constraints: Validate the Top-Level Value

April 2, 2010
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts

ISJSON type constraints distinguish JSON shapes. Compare VALUE and SCALAR, Boolean literals, JSON null and SQL NULL on SQL Server 2022.

Read More
A leather wallet floating away down a stream, coins slipping out, while a zipped red purse sits dry on the bank.

float vs decimal: Why Money Should Never Be float

April 1, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Datatype, SQL Server

Compare float vs decimal for currency, inspect approximate arithmetic, and use explicit decimal precision and rounding rules.

Read More
Previous 1 … 460 461 462 463 464 465 466 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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