In this blog post, we will be discussing a very interesting scenario of Trigger on Database to Prevent Table Creation. Let us learn today.
Quest Database Training Days are Back
I am very fortunate that I got another opportunity to present for Quest Database Training Days. Yes, it is true that Quest Database Training Days are Back.
The Challenges of Monitoring in the Cloud
Once I got into it, it was the recognition that Platform as a Service offerings change things. Let us learn about The Challenges of Monitoring in the Cloud.
SQL SERVER – List Tables with Size and Row Counts – Part 2
Earlier I had written a blog post SQL SERVER – List Tables with Size and Row Counts. Jason Horner, an SQL Server Expert, improved my query.
MAX Columns Ever Existed in Table – SQL in Sixty Seconds #182
Earlier I wrote about SQL SERVER – MAX Columns ID Used in Table and lots of people asked me to create a video on this topic. Let us see the video.
SQL SERVER – Available Free Space in Data and Log File
Lots of good feedback, I have received on my recent to the point blog posts. Today we will see a script for Available Free Space in Data and Log File.
SQL SERVER – Rename View
There are two different ways one can rename view in SQL Server. Let us see in today’s blog post how to rename view. 1) SSMS 2) T-SQL
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.