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
Two matching slate blue birdhouses on a fence post, one with a higher entry hole and no perch.

Comparing Two Database Schemas With T-SQL

January 22, 2014
Pinal Dave
SQL Tips and Tricks
Schema, SQL Scripts, SQL Server, SQL System Table

Comparing two database schemas with catalog queries exposes missing objects, changed columns, and index differences before deployment.

Read More
Two blank wooden tags attached to the same small wooden box with plain cotton string.

Renaming Something Without Breaking Everything

January 8, 2014
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Plan a rename database object change with dependency checks, updated callers, permission tests, and a temporary compatibility name when suitable.

Read More
SQL SERVER - MySQL - LIMIT and OFFSET - Skip and Return Only Next Few Rows - Paging Solution

SQL SERVER – MySQL – LIMIT and OFFSET – Skip and Return Only Next Few Rows – Paging Solution

December 30, 2013
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Scripts, SQL Server

Paging in MySQL and SQL Server: use LIMIT and OFFSET to skip some rows and return only the next few, with examples for both databases.

Read More
SQL SERVER - MySQL - PostgreSQL - How to Concat Strings?

SQL SERVER – MySQL – PostgreSQL – How to Concat Strings?

December 29, 2013
Pinal Dave
SQL Tips and Tricks
MySQL, PostgreSQL, SQL Function, SQL Scripts, SQL Server

How to concat strings the same way in SQL Server, MySQL and PostgreSQL? I switched from the plus operator to the CONCAT function, and here is why.

Read More
Gouache painting of a person reviewing a database access checklist with a magnifying glass

Permissions I Have in SQL Server: Check Database, Server and Object Access

December 22, 2013
Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Scripts, SQL Server, SQL Server Security

The permissions I have in SQL Server depend on my database and security context. These read-only queries, tested with a loginless user, a role and a column DENY, separate database, server and object checks and show which grant supplied each permission.

Read More
A compact plain toolbox with a few neatly arranged hand tools on a warm wooden workbench.

Free Tools Worth Having on a SQL Server

December 18, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Choose free SQL Server tools by the problem they solve, from SSMS and sqlcmd to Extended Events, and understand the limits before relying on them.

Read More
MySQL - How to Create Stored Procedure

MySQL – How to Create Stored Procedure

December 13, 2013
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Scripts

Confused by semicolons when you create stored procedure code in MySQL? Change the DELIMITER first, then reset it. Here is a simple example.

Read More
Previous 1 … 178 179 180 181 182 183 184 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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