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 a tidy archive room with rows of plain wooden drawers, a brass key ring hanging on a hook and a magnifying glass resting on an open ledger with blank pages, one drawer handle painted vermilion.

Data Governance: Catalog, Lineage and Data Quality

January 14, 2014
Pinal Dave
SQL Tips and Tricks
Data Observability, Database, Duplicate Records, SQL NULL, SQL Server Security

Data Governance is how you know what data you have, where it came from, who can see it and whether it is right. This post covers the catalog, lineage, access and data quality, with T-SQL checks you can run.

Read More
A cake lifter removes one cake layer while neighboring layers remain untouched

TRUNCATE Permission: Letting a User Empty One Table

January 13, 2014
Pinal Dave
SQL Tips and Tricks
SQL Server Security, SQL Stored Procedure, SQL Table Operation

Your loader needs to empty a staging table, not redesign it. Here is a small procedure that gives it exactly that.

Read More
MySQL - Change the Limit of Row Retrieved in MySQL Workbench

MySQL – Change the Limit of Row Retrieved in MySQL Workbench

January 12, 2014
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Server

Why does a query return every row in your app but only 1000 in MySQL Workbench? It limits rows by default, and here is how to change that limit.

Read More
ALTER TABLE statement adding the UX_Constraint unique constraint on Col1, with a Table1 holding Apple and Orange and a third row, Apple, rejected as a duplicate (sample rows)

Unique Constraint on Existing Table: How to Add One With ALTER TABLE

January 11, 2014
Pinal Dave
SQL Tips and Tricks
Duplicate Records, SQL Constraint and Keys, SQL Index, SQL Table Operation

A unique constraint on existing table data takes one ALTER TABLE statement. Here is the script, the duplicate check to run first, and what to know about NULLs, indexes and names.

Read More
Two lobster pots on a harbor quay, one crammed with seaweed and shells, the other holding one lobster.

Query Store Capture Modes: ALL, AUTO and CUSTOM

January 10, 2014
Pinal Dave
SQL Performance
Query Store, SQL Performance, SQL Server, SQL Server Configuration

Choose a Query Store capture mode for your workload, inspect ALL, AUTO, CUSTOM and NONE, and tune thresholds without losing useful history.

Read More
Auditing SQL Login (GUI)

SQL SERVER – Auditors, Passwords and Exceptions – Notes from the Field #010

January 9, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore, SQL Server Security

Weak passwords are like a key under the door mat. Brian Kelley explains what auditors look for around passwords and exceptions in database security.

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
Window displaying MySQL56 properties.

MySQL – Locate the Configuration File – my.ini or my.cnf on Windows Platform

January 7, 2014
Pinal Dave
SQL Tips and Tricks
MySQL

New MySQL users often ask where to find my.ini or my.cnf on Windows. I show a quick way to see which file is powering your MySQL Server configuration.

Read More
PowerShell 'Shutdown' button.

SQL SERVER – Start Services or Stop Services with PowerShell – Answer to Question

January 6, 2014
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Server Services

You can check out the original post here: SQL SERVER – Start Services or Stop Services with PowerShell – Question to Readers?.

Read More
SQL SERVER - Start Services or Stop Services with PowerShell - Question to Readers?

SQL SERVER – Start Services or Stop Services with PowerShell – Question to Readers?

January 5, 2014
Pinal Dave
SQL Puzzle
PowerShell, SQL Server

A reader asks why you need the -Force flag to stop services with PowerShell but not to start them. I do not know the answer, so I am asking you.

Read More
Previous 1 … 315 316 317 318 319 320 321 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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