Today I am going to discuss the new SQL in Sixty Seconds Videos which I have released. Let us learn about them together. Do not forget to subscribe.
SQL SERVER – FIX Error 18456, Severity: 14, State: 5. Login failed for user
Some errors are historic and have the most common root cause. Sometimes we really don’t know why they happen and I have seen clients go nuts to identify the real reason for the problem. In a recent email interaction with one customer – who was migrating from Oracle to SQL Server. He kept telling me that they were getting login errors from their Java application. And even when they used the SQL Server Management Studio it was erroring out with Error 18456 code. They sent me a snapshot like this for login failed:
SQL SERVER – Database Backup and Restore Job Management
ApexSQL Backup is a tool for Microsoft SQL Server, intended for database backup and restore job management. The application supports all native SQL Server backups (full, differential and transaction log backups), and allows users to easily create, save and manage all backup related jobs. ApexSQL Backup can be used to run, schedule and monitor all backup operations across the domain from a single location.
Consultant’s Life – 30 Minutes Pre Call With Customer for SQL Server Performance Tuning
I am working as an independent SQL Server Performance Tuning Consultant and I love my job. Let us learn about Pre Call with a customer.
SQL SERVER – Understanding How to Play With Row Constructor
Every version of SQL Server brings in something new that challenges our understanding of how the software product works. For me, working with SQL Server is quite refreshing and fulfilling because every single day there is something about the product that I discover and learn. There are tons of professionals who are working on this product and they push the limits of use and bring interesting use cases which I get to learn. Let us learn about Row Constructor.
How to Find Recent Executed Queries in SQL Server? – Interview Question of the Week #087
Interviews are fun. Most of the time the interviewer has all the interesting questions, but I often come across a few individuals who stomps the interviewer. I was recently called by one of the organizations where I regularly help with their hiring process. They were stumped by interviewing candidates with one of the questions related to recent executed queries. Let us see the question and its answer.
SQL SERVER – SSMS Enhancement – Databases Node Filter Capability
I have been playing around with SQL Server 2016 for a while now and it is interesting how some of the things have changed drastically with this release. One of the key things I felt was the ability to have a different cycle for SQL Server Management Studio (a.k.a SSMS) enhancements. Since this is a client tool, I see that Microsoft has gone ahead with updating the tool almost every month now. Let us learn about SSMS Enhancement.
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.