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 scythe stone beside aligned blade and handle parts with their fitted joint visible

Statement Terminators: Where T-SQL Requires a Semicolon

December 7, 2011
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server

Most T-SQL statements run fine without a semicolon, but a pasted CTE, THROW or MERGE will not. Here is how to read the error and fix the line above it.

Read More
A small wooden staircase model beside a plain closed toolbox in soft natural window light.

What a Junior DBA Should Learn First

December 6, 2011
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Build junior DBA skills around restores, permissions, blocking, and safe investigation, with a practical learning order and useful SQL checks.

Read More
A quilting hoop holds a quilt with adjoining pale and sage fabric sections

Partitioned Views: Splitting a Table Without Table Partitioning

December 5, 2011
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server

A view over yearly tables only skips the years it does not need while the CHECK constraints are trusted. Here is how to see it, break it and fix it.

Read More
A wooden drawbridge being lowered across a moat toward an open stone gateway

Connecting to SQL Server From Linux

December 4, 2011
Pinal Dave
SQL Tips and Tricks
Linux, SQL Connection, SQL Server, SQL Server Encryption, sqlcmd

Connecting to SQL Server from Linux requires the right Microsoft ODBC packages, a Kerberos plan, and certificate trust that matches the server name.

Read More
A wooden storage box holding several small plain envelopes beside one larger closed envelope.

SSIS Project and Package Deployment Explained

December 3, 2011
Pinal Dave
SQL Tips and Tricks
Best Practices, Data Warehousing, Database, ETL

Understand SSIS deployment models, catalog environments, parameter bindings, and the checks that keep package execution predictable after deployment.

Read More
SQL SERVER - Effect of SET NOCOUNT on @@ROWCOUNT

SQL SERVER – Effect of SET NOCOUNT on @@ROWCOUNT

December 2, 2011
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server

Does SET NOCOUNT change @@ROWCOUNT? I ran a quick demo in a session and ten hands went up before I even hit execute. The script and what it shows.

Read More
A wooden glove former beside two differently colored gloves with matching outlines

Storing Email Addresses: Length, Case and Unique Keys

December 1, 2011
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server

Two accounts for one customer usually means nobody wrote down the case rule. Build the table, break each rule, and see what the database can promise.

Read More
SQL SERVER - Fix: Error: File Cannot be Loaded Because the Execution of Scripts is Disabled on This System

SQL SERVER – Fix: Error: File Cannot be Loaded Because the Execution of Scripts is Disabled on This System

November 30, 2011
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Error Messages, SQL Scripts, SQL Server

After a fresh install, PowerShell stopped me with an error: execution of scripts is disabled on this system. The fix takes two lines with Set-ExecutionPolicy.

Read More
One small wooden bead resting behind a neatly arranged group of matching beads on a table.

Handling the Row That Arrives Late

November 29, 2011
Pinal Dave
SQL Tips and Tricks
Best Practices, Data Warehousing, Database, ETL

Handle late arriving data with explicit event dates, inferred dimension members, replay windows, and a clear policy for correcting published history.

Read More
A bobbin winder beside threaded and empty bobbins with a separate source spool

Listing Server Logins Not Mapped to Any Database User

November 28, 2011
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server

A login with no database user is not automatically unused. Build the report, compare by SID, and check server roles before you touch anything.

Read More
Previous 1 … 394 395 396 397 398 399 400 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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