Feb 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check

SQL SERVER – Backups are Non-negotiable Lifeline for DBAs

January 21, 2015
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Idera
I have had my share of DBA friends who have told me a number of horror stories from their experiences. Thinking back, these look like moments to laugh away but there are some serious learnings we get from these experiences. I am a personal believer of learning something in everything…
Read More

SQL SERVER – How DBAs Have to be Proactive in Identifying and Fixing Problems Before They Happen

January 20, 2015
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Dell
In real life our dear ones always love to have surprises. If we do things even before they can think, we are in for some fun for rest of the days/weeks. I vividly remember a conversation with my daughter in recent past. I had made a deal to get her…
Read More

SQL SERVER – How to Find Weak Passwords Using T-SQL?

January 19, 2015
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Server Security
Recently one of my blog reader emailed me below question. Hi Pinal, Need your urgent help. In recent past, we have been attacked by the hacker who was able to get in to our SQL Server via sysadmin account and made big damage to our data. To make sure it…
Read More

Interview Question of the Week #003 – How to Write Script for Database Cursor?

January 18, 2015
Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
Just another day I heard a senior DBA discussing advantages and disadvantages of the cursor. Well, personally I am a firm believer of the set based operations. However, there are few places where cursors are the only solutions. It is quite possible that different experts have different opinion about cursor;…
Read More

SQL SERVER – Watching Table Variable Data in TempDB

January 17, 2015
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
MySQL
I cannot get enough of working with TempDB and the learning never stops. Previously, when I wrote about SQL SERVER – Is tempDB behaving like a Normal DB?, SQL SERVER – Inside Temp Table Object Creation and Difference TempTable and Table Variable – TempTable in Memory a Myth many did…
Read More

SQL SERVER – Configuration and Performance of SQL Server is Now Easy to Master

January 16, 2015
Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Confio
This is one of the toughest topics to address, and I am always looking at new tools that can help me learn and understand SQL Server better. In many cases, I fall back to MSDN documentation and official statements from the Microsoft site because a lot of R&D generally has…
Read More

SQL SERVER – The Easy Functions of SQL Server – Notes from the Field #062

January 15, 2015
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Notes from the Field, SQL DateTime
[Note from Pinal]: In this episode of the Notes from the Field series database expert Kathi Kellenberger explains about easy and amazing functions of SQL Server. Kathi is an amazing instructor, she was the SQL author I have read in my early career. The reason, I love SQL Server because her writing has…
Read More
Previous 1 … 376 377 378 379 380 381 382 … 829 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version