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 cut rose branch with thorns, pruning shears and a clay pot on a greenhouse workbench.

REGEXP_REPLACE Text Cleanup: Replacing Tags Is Not Parsing HTML

June 3, 2011
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server, SQL String

REGEXP_REPLACE can remove controlled tag-like text, but that is not the same as parsing HTML. Test quoted brackets, surviving script text and word boundaries before deciding whether the replacement fits the input.

Read More
A wooden crate of apples at a market stall beside a small brass hand counter on the counter top.

SQL SERVER – Puzzle – SELECT * vs SELECT COUNT(*)

May 30, 2011
Pinal Dave
SQL Puzzle
SQL Scripts, SQL Server

SELECT * gives an error when run alone, but SELECT COUNT(*) does not. Why? Here is my SELECT * vs SELECT COUNT(*) puzzle from the Bangalore User Group.

Read More
Ceramic vessels, a wooden box, folded cloth, stones and a cord-bound walnut rest on a wooden tray.

OPENJSON Default Schema: Read Its Type Codes

May 29, 2011
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts

OPENJSON default schema exposes key, value and type. Compare all six type codes, retain JSON null, and distinguish scalar text from nested fragments.

Read More
SQL SERVER - Running SSIS Package in Scheduled Job

SQL SERVER – Running SSIS Package in Scheduled Job

May 23, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Utility

How to run an SSIS package on a schedule with a SQL Server Agent job, step by step, after my earlier post on running it from the command line.

Read More
SQL SERVER - Running SSIS Package From Command Line

SQL SERVER – Running SSIS Package From Command Line

May 21, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts

How do you run an SSIS package from command line? Use dtexec.exe with the /F option to run the package file and see its start time, end time and progress.

Read More
Blue and terracotta ceramic beads beside an open wooden case containing a green bead.

geometry STAsText: Z and M Values Need a Different Export

May 20, 2011
Pinal Dave
SQL Tips and Tricks
Spatial Database, SQL Function, SQL Scripts, SQL Server

geometry STAsText returns spatial text without the Z and M values carried by an instance. I compare it with ToString using two points. Identical XY text can hide a difference in the original payload.

Read More
A fitted brass key engages the archive door lock while another key remains unused.

SQL SERVER – Connecting to Server Using Windows Authentication by SQLCMD

May 19, 2011
Pinal Dave
SQL Video
SQL Scripts, SQL Server, SQL Utility, sqlcmd

Windows Authentication by SQLCMD uses the current Windows identity with -E. It does not need a Windows password in the command.

Read More
Previous 1 … 228 229 230 231 232 233 234 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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