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 compact strap roll beside the same strap extended across the floor

Storing Hash Values: binary(32) or a 64-Character Hex String

February 12, 2014
Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL Data Storage, SQL Datatype

A hex string is just a printed hash, and it costs twice the space. Here is the round trip, the index sizes and the traps.

Read More
A weathered thatched roof with one small fresh golden patch, a red-handled mallet beside it

Page Restore: Fixing a Few Corrupt Pages Without a Full Restore

February 11, 2014
Pinal Dave
SQL Tips and Tricks
Database Corruption, DBA, SQL Backup and Restore, SQL Server DBCC

Rehearse page restore on a test database, identify damaged page IDs, apply the backup chain, and verify storage and database consistency.

Read More
SQL SERVER - Migration of SQL Server 2012 Database Mirroring to AlwaysOn Availability Group

SQL SERVER – Migration of SQL Server 2012 Database Mirroring to AlwaysOn Availability Group

February 10, 2014
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Server

Migration of SQL Server 2012 database mirroring to AlwaysOn Availability Group can be tricky. Here is the setup and the migration process, step by step.

Read More
A router bearing follows a curved wooden guide while a spare bit lacks a guide

Agent Tokens in Job Steps: Job Name, Step and Start Time

February 9, 2014
Pinal Dave
SQL Tips and Tricks
SQL Monitoring, SQL Server Agent, SQL String

A copied job should log its own name, not the old one. Agent tokens do that, if you escape them the right way.

Read More
SQL Puzzle - A Quick Fun with Bit Wise Operator - Part 2

SQL Puzzle – A Quick Fun with Bit Wise Operator – Part 2

February 8, 2014
Pinal Dave
SQL Tips and Tricks
SQL Scripts

Part 2 of my quick fun with Bit Wise Operator puzzle uses OR. Why does SELECT 1 | 100 return 101? Leave your answer in the comments.

Read More
SQL Puzzle - A Quick Fun with Bit Wise Operator

SQL Puzzle – A Quick Fun with Bit Wise Operator

February 7, 2014
Pinal Dave
SQL Puzzle

A quick Friday SQL puzzle on the Bit Wise Operator: SELECT 10 & 10 returns 10, so why do 10 & 0 and 1 & 100 both return zero?

Read More
SQL SERVER - Learning SSIS - Where Do I Start? - Notes from the Field #014

SQL SERVER – Learning SSIS – Where Do I Start? – Notes from the Field #014

February 6, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore

Where do you start when learning SSIS? I asked SSIS expert Andy Leonard, and he shares how a novice developer can learn it from the beginning.

Read More
Right click tasks.

SQL SERVER – Retrieve All the Data from VARCHAR(MAX) Column

February 5, 2014
Pinal Dave
SQL Tips and Tricks

SSMS will not display all the text in a long VARCHAR(MAX) column. Here is how I retrieve all of it by exporting the data to a text file.

Read More
A fork and chopsticks resting side by side beside a plate of noodles

Backing Up MySQL, Explained for SQL Server DBAs

February 4, 2014
Pinal Dave
SQL Tips and Tricks
DBA, MySQL, SQL Backup and Restore

Backing up MySQL means choosing logical or physical copies and retaining binary logs for point-in-time recovery, then testing restores.

Read More
9 Things You Should be Doing with Your Backups - Backup Tips - SQL Server Backup Tips

9 Things You Should be Doing with Your Backups – Backup Tips – SQL Server Backup Tips

February 3, 2014
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts, SQL Server

Nine SQL Server Backup tips every DBA should follow, starting with the simplest one: never keep backups on the same physical drive as the database files.

Read More
Previous 1 … 312 313 314 315 316 317 318 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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