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 - Beginning of SQL Server Security

SQL SERVER – Beginning of SQL Server Security

August 2, 2012
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Security

The beginning of SQL Server security: how authentication, logins, users and permissions work together to keep your data safe from misuse.

Read More
Three small wooden boxes connected by short lengths of plain cord on a warm tabletop.

What Distributed SQL Means and What It Costs

August 1, 2012
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Understand distributed SQL through data placement, compute and storage roles, write coordination, and the latency and operating costs behind scale.

Read More
A conveyor belt of identical parcels beside a single hand trolley carrying one parcel

What Is a Cursor in SQL Server, and When to Avoid One

July 31, 2012
Pinal Dave
SQL Performance
Best Practices, SQL Performance, SQL Scripts, SQL Server

A cursor in SQL Server took 260 milliseconds where one SELECT took 4. Why the gap exists, how to turn a loop back into a set, and the three cases where a cursor really is the right answer.

Read More
SQL SERVER - Difference Between ORIGINAL_LOGIN() and SUSER_SNAME()

SQL SERVER – Difference Between ORIGINAL_LOGIN() and SUSER_SNAME()

July 28, 2012
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts

What is the difference between ORIGINAL_LOGIN() and SUSER_SNAME()? A quick script with context switching shows when the two return different logins.

Read More
SQL SERVER - Answer - How to Convert Hex to Decimal or INT

SQL SERVER – Answer – How to Convert Hex to Decimal or INT

July 26, 2012
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts

Readers sent great answers on how to convert Hex to Decimal or INT in SQL Server. Here are their solutions, with due credit, using 0x00000100 as the example.

Read More
A tripod and a desk lamp set up facing an empty chair in a tidy home office.

SQL SERVER – How do I Record Video and Webcast – Milestone – 2200th Blog Post – SQL in Sixty Seconds #022 – Video

July 25, 2012
Pinal Dave
SQL Video
Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio

My 2200th blog post and the 22nd SQL in Sixty Seconds episode: a short video on how I record video and webcast content, plus thanks to the people who help.

Read More
SQL SERVER - Find Column Used in Stored Procedure - Search Stored Procedure for Column Name - Part 2

SQL SERVER – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name – Part 2

July 19, 2012
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Stored Procedure

Readers improved my script to find column used in stored procedure. Imran Mohammed shares newer scripts to search stored procedure for column name.

Read More
Previous 1 … 201 202 203 204 205 206 207 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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