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 gloved hand holds secateurs to one dead branch of a bare apple tree, pruned twigs on the snow below.

A Quarterly Permission Review

June 21, 2008
Pinal Dave
SQL Tips and Tricks
DBA, SQL Audit, SQL Login, SQL Server Security

A quarterly permission review checks server and database roles, new grants, orphaned users, service accounts, and owner signoff.

Read More
SQL Server query for SQL Server2.

SQL SERVER – Find Current Identity of Table

June 20, 2008
Pinal Dave
SQL Tips and Tricks
SQL Index, SQL Scripts, SQL Server DBCC

Many developers use MAX() to find the current identity of a table. I prefer DBCC CHECKIDENT, which reports the current identity value directly.

Read More
Two plain wooden toolboxes of different sizes resting side by side on a neutral workbench.

Comparing Two Databases Without a Scoreboard

June 19, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Learn how to compare databases using representative work, operational skills, recovery requirements, and costs rather than feature-count scoreboards.

Read More
Two blue thread spools and one ochre spool stand on a metal support above folded cream fabric.

Weighted Average: Keep Group Totals and Value Counts

June 18, 2008
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Reports, SQL Scripts, SQL Server

A weighted average preserves each group’s contribution. I compare unequal groups before combining their means. Group totals and populated-value counts reconstruct the underlying average without treating missing readings as zero.

Read More
SQL SERVER - 2008 - SQL Server Start Time

SQL SERVER – 2008 – SQL Server Start Time

June 17, 2008
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Scripts

SQL Server 2008 records when it started in sys.dm_os_sys_info. One SELECT of sqlserver_start_time gives you the SQL Server start time. It does not work on 2005.

Read More
SQL SERVER - Introduction to SERVERPROPERTY and example

SQL SERVER – Introduction to SERVERPROPERTY and example

June 16, 2008
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts

SERVERPROPERTY is a handy system function that returns server values like collation, edition and instance name. My script lists every property in one result.

Read More
SQL SERVER - 2008 - Introduction to Policy Management - Enforcing Rules on SQL Server

SQL SERVER – 2008 – Introduction to Policy Management – Enforcing Rules on SQL Server

June 13, 2008
Pinal Dave
SQL Tips and Tricks
Policy Management, SQL Coding Standards, SQL Scripts, SQL Server

Use Policy Management in SQL Server 2008 to enforce rules, not just list them. A short tutorial that blocks any stored procedure created without the usp prefix.

Read More
Previous 1 … 504 505 506 507 508 509 510 … 572 Next
  • Books
  • Testimonials
  • Privacy Policy

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