Jun 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
  • Hire Me
  • Health Check
All Articles standupmeeting-600x343

Developer – Best Practices for Daily Stand-Up or Daily Scrum – Rules and Regulations

September 20, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices

Scrum is an Agile Software Development framework that helps teams complete projects efficiently while maintaining high quality.

Read More

SQL Contest – Identify the Database Celebrity – Win USD 100 Amazon Gift Card

September 19, 2013
Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks
NuoDB
Regular readers of this blog are familiar with NuoDB and their generous offers for SQLAuthority.com readers. I was just talking to them earlier and together we have come up with a very interesting contest for all of us. This contest has two parts. Part 1 Identify Database Personality and in Part…
Read More

SQL SERVER – Five Puzzles around UNION – Participate in All Five

September 18, 2013
Pinal Dave
SQL Tips and Tricks
Earlier this week, I ran five part series on UNION and it received very good response. Today I learned from Amazon that for a brief period of the time (to be precise for next 96 hours) they have reduced the price for price of Kindle Book of SQL Server Interview…
Read More

SQL SERVER – Detecting Potential Bottlenecks with the help of Profiler

September 17, 2013
Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Probably, everyone who writes SQL code has used INSERT statement, which alongside SELECT, UPDATE and DELETE, is a part of a basic operations’ set for data manipulation. At the first sight syntax of the INSERT statement may seem very trivial , especially when inserting one record –  INSERT INTO ……
Read More

SQL SERVER – Execute Operating System Commands in sqlcmd

September 16, 2013
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
sqlcmd
Here is the email received just the other day – “Hi Pinal, I have been using sqlcmd for a long time and I find it very comfortable. I am going to soon learn Powershell as well. However, here is one typical problem I face it every day and I want to check…
Read More

Personal Technology – Who is Accessing your Google Account?

September 15, 2013
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Google, Personal Technology
Do you know who is accessing your Google Account? Well, I did not know till yesterday. However, when I learn what apps are accessing my Google Accounts and particularly Gmail, I was really really scared. I receive lots of emails and just like all of us, some are private and…
Read More
All Articles memorylane-600x602

SQL SERVER – Memory Lane – Scrum, SQL Reboot and More – #046

September 14, 2013
Pinal Dave
SQL
Memory Lane, SQL Server

Let me know which one of the following is your favorite article from memory lane. My favorite article is about Scrum and SQL Reboot.

Read More
All Articles seth

SQL – Weekend Project – Watching Technically Seth Series – What is your plan for this weekend?

September 13, 2013
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
NuoDB
“What is your plan for this weekend?” I was recently asked by my fellow colleague. I replied: “I have plan learn about Big Data and SQL from Technically Seth.” “Technically Seth!” He replied, “Never heard of him.” “Honestly even he has not heard of you.” I tried to look serious…
Read More

SQL SERVER – Automatically Store Results of Query to File with sqlcmd

September 12, 2013
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
sqlcmd
I receive lots of email everyday and I do answer almost every email I receive. However, I prefer to answer all the technical questions on my facebook page. With the help of social media it is very easy to reach out to multiple people with the same problem. Here is the…
Read More
All Articles puzzunion5-1-600x400

SQL SERVER – Simple Puzzle with UNION – Part 5

September 11, 2013
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Union clause, Union
It seems that my yesterday’s Simple Puzzle with UNION intrigued many readers. Here is my fifth and final part of this Puzzles with UNION. I strongly suggest to read yesterday’s puzzle before continuing today’s puzzle as it is very much based on yesterday’s puzzle. SQL SERVER – Simple Puzzle with UNION…
Read More
Previous 1 … 316 317 318 319 320 321 322 … 582 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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