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
SQL SERVER - Using Package Configurations in SSIS 2012 and Beyond - Notes from the Field #079

SQL SERVER – Using Package Configurations in SSIS 2012 and Beyond – Notes from the Field #079

May 7, 2015
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Server, SSIS

Moving to SSIS 2012 or 2014 and worried about losing the Package Configurations you built? Good news: the classic option is still there. Here is how to use it.

Read More
Add Counters tool.

SQL Server – Knowing the Use of Deprecated or Discontinued Features

May 6, 2015
Pinal Dave
SQL Tips and Tricks
SQL Deprecated Feature

After an upgrade, a DBA’s management asked if any deprecated or discontinued features were still in use. Here is how to find that out on a live server.

Read More
SQL SERVER - Generating Row Number Without Ordering Any Columns

SQL SERVER – Generating Row Number Without Ordering Any Columns

May 5, 2015
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server

ROW_NUMBER needs an ORDER BY clause, but what if you do not want to sort by any column? Here is a simple trick to generate a row number without ordering.

Read More
ALTER DATABASE window.

SQL SERVER – Who ALTER’ed My Database? Catch Them Via DDL Trigger

May 4, 2015
Pinal Dave
SQL Tips and Tricks

A reader’s database kept switching back to compatibility level 80 every day. Here is how a DDL trigger can catch who ALTERed the database and when.

Read More
A comb separates stray burs from a continuous string of blue beads

Interview Question of the Week #018 – Script to Remove Special Characters – Script to Parse Alpha Numerics

May 3, 2015
Pinal Dave
SQL Interview Questions and Answers
SQL Function, SQL Scripts

Remove special characters with a corrected SQL Server loop and a 2025 regex expression, while defining ASCII and collation rules.

Read More
A speaker badge at a tech conference.

Great Indian Developer Summit 2015: Three SQL Sessions and a CPU Check

May 2, 2015
Pinal Dave
SQLAuthority News
GIDS, SQL CPU, SQL Performance

Great Indian Developer Summit 2015 brought me to Bangalore and Hyderabad for three SQL Server sessions. This page keeps the dates, topics and photos. It also adds a CPU check I would start with today, tested on SQL Server 2025, because one session was about CPU performance.

Read More
SQL AZURE - How to Disable and Enable All Constraint for Table and Database

SQL AZURE – How to Disable and Enable All Constraint for Table and Database

May 1, 2015
Pinal Dave
SQL Tips and Tricks
SQL Azure

sp_msforeachtable does not work in Azure SQL Database. Here is how to disable and enable all constraint for table and database in SQL Azure using DMVs.

Read More
SQL Server 2012 Error Dialog.

SQL SERVER – Recovering from Snapshots – Notes from the Field #078

April 30, 2015
Pinal Dave
SQL Tips and Tricks
Notes from the Field, Snapshot, SQL Backup and Restore, SQL Scripts

Data deleted by accident? John Sterrett explains recovering from snapshots, a very useful but less used feature, without panic making things worse.

Read More
SQL SERVER - Finding Tables with Primary or Foreign Keys

SQL SERVER – Finding Tables with Primary or Foreign Keys

April 29, 2015
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts

How do you find which tables have a primary key or foreign key? Here are simple queries for finding tables with primary or foreign keys in a database.

Read More
SQL SERVER - Script: Knowing Data and Log Files Are On the Same Drive

SQL SERVER – Script: Knowing Data and Log Files Are On the Same Drive

April 29, 2015
Pinal Dave
SQL Tips and Tricks
GIDS, SQL Scripts, SQL Server, Transaction Log

At GIDS I talked about keeping data and log files on separate drives. Here is a script that shows which databases have data and Log Files on the same drive.

Read More
Previous 1 … 264 265 266 267 268 269 270 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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