Sep 2025 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 – Dude, Where is the SQL Agent Job History? – Notes from the Field #017

February 27, 2014
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore
[Note from Pinal]: Everybody knows what is SQL Agent Jobs. We know that they run at regular interval and does the task assigned. However, there are way many more things we should know about SQL Jobs but do not know it or never learnt to care about it. One of…
Read More

SQL SERVER – Find Anything in Object Explorer in SSMS

February 26, 2014
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Server Management Studio
This blog post is a follow up post of an excellent write up by my friend Vinod Kumar. I suggest you read his blog post here SSMS Tips–Object Explorer Details. After reading his blog post, I called him up and had an interesting conversation with him. Here is our conversation:…
Read More

SQL SERVER – Contest Post – Notes from the Field – Learning Performance Tuning and Database Health

February 24, 2014
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Notes from the Field
One of the most appreciated and loved the series on SQLAuthority.com is Notes from the Field. I often received how did I come up with the idea behind it. Here is the story for the same. Inceptions of Notes from the Field There are two aspects of any technology 1)…
Read More

SQLAuthority News – Two Whitepapers from AzureCAT Team on SQL Database

February 23, 2014
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Recently I was reading about SQL Database on Azure. There are lots of confusion around SQL Database around SQL Azure and I have been looking for a good authentic documentation which I can refer as well as I can use that in my day job. After a quick research I…
Read More

SQLAuthority News – 4 Whitepapers on Windows Azure

February 22, 2014
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL White Papers
Windows Azure is getting quite a lot of traction in the industry and I often get questions about if there is authentic learning on this subject. Microsoft has published following 4 white paper which covers many interesting topics related to SQL Server and Windows Azure. Application Patterns and Development Strategies…
Read More

SQL SERVER – Statistical Analysis in SQL Server – A Quick Introduction

February 21, 2014
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts
SQL Server has very few statistical functions. Oracle has lots of them. XLeratorDB closes the gap. If you want to try out the example of this blog post, I suggest you download the 15-day free trial of XLeratorDB NOW. Most SQL Server users would never think of T-SQL as a…
Read More

SQL SERVER – Finding the Last Backup for All Databases – Notes from the Field #016

February 20, 2014
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore
[Notes from Pinal]: During my presentation, I always ask developer a simple question – When did you take your last database backup? I get two different kinds of answers – 1) few replies with No Idea and 2) few replies with some date time. When I further ask if they…
Read More
Previous 1 … 75 76 77 78 79 80 81 … 393 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version