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 small glass jars with uneven amounts of beans beside a short row of scattered beans.

Generating Test Data That Behaves Like the Real Thing

March 9, 2016
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Make test data generation reflect skew, row width, missing values, and key relationships so your SQL Server experiments expose realistic plan risks.

Read More
An open wooden mechanism exposes several differently positioned adjustment levers

Interview Question of the Week #061 – How to Retrieve SQL Server Configuration?

March 6, 2016
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server, SQL Server Configuration

A common interview question: how do you retrieve SQL Server configuration? Right-click and Properties is not enough. Here is the better answer.

Read More
SQL SERVER - Where is Rows Affected in Output?

SQL SERVER – Where is Rows Affected in Output?

March 3, 2016
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server

SSMS showed the rows affected message, but SQLCMD on one instance did not. Here is the configuration option behind it and where you can change it.

Read More
SQL SERVER - Unable to start SQL Server Agent - Failed to Initialize SQL Agent log

SQL SERVER – Unable to start SQL Server Agent – Failed to Initialize SQL Agent log

February 29, 2016
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server

My friend changed SQL Agent parameters and then the service would not start: failed to initialize SQL Agent log. Here is where to look and how we fixed it.

Read More
A separate dish collects marble colors present in the first bowl but absent from the second

Interview Question of the Week #060 – What is the Difference Between EXCEPT Keyword and NOT IN?

February 28, 2016
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server

Even 11 years after SQL Server 2005, few people I interview know the EXCEPT keyword. Here is how EXCEPT differs from NOT IN, with simple examples.

Read More
SQL SERVER - 2016 - Check Value as JSON With ISJSON()

SQL SERVER – 2016 – Check Value as JSON With ISJSON()

February 26, 2016
Pinal Dave
SQL Tips and Tricks
JSON, SQL Scripts, SQL Server, SQL Server 2016

Before you store JSON sent from the front end, make sure it is valid. Here is how the ISJSON() function in SQL Server 2016 checks a value as JSON.

Read More
A row of music stands at the same height and angle, a hand straightening the one out of line

A T-SQL Formatting Style Guide for Teams

February 24, 2016
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Coding Standards, SQL Scripts, SQL Server

Adopt a short T-SQL formatting style with clear columns, joins, aliases, semicolons and comments, and keep review focused on query behavior.

Read More
Previous 1 … 153 154 155 156 157 158 159 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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