As February starts, just thought of dropping a note to let you know where you can find me in the upcoming months. Do scroll down all the way to read the change in offering in SQL Server Performance Tuning Workshop.
What is Trusted Constraint in SQL Server? – Interview Question of the Week #210
Question:Â What is Trusted Constraint in SQL Server?
Win Apple Watch Series 4 and Solve SQL Server Performance Problems
Ask any DBA what would they love to monitor in their SQL Server and I promise you that you will get quite many different answers to this question. Though every DBA would love to see their server always up upon asked what exactly they would like to watch you will see different answers to the popular question. I have previously blogged about it over here:Â Solve 3 Biggest SQL Server Performance Challenges with Spotlight. Today, you can download Spotlight and Win Apple Watch Series 4.
How to Move Log File or MDF File in SQL Server? – Interview Question of the Week #208
Question: How to Move Log File or MDF File in SQL Server?
When to Use sort_in_tempdb for Rebuilding Indexes? – Interview Question of the Week #207
Question:Â When to Use sort_in_tempdb for Rebuilding Indexes?
SQL Authority News – Free Performance Tuning Videos
SQL Server Performance Tuning and Optimization is how I earn my bread at home. Lots of people often ask if I will be happy to teach them my SQL Server Performance tuning tricks and my answer is very simple – of course. I am always willing to help people learn about SQL Server Performance Tuning if they are willing to learn about the subject. I have created some Free Performance Tuning Videos.
SQL SERVER – Performing IF…THEN In T-SQL With IIF Expression
Today, we are going to see one of the most underutilized features of SQL Server IIF. In SQL Server we can performance IF…THEN logic in T-SQL with IIF Expression but I hardly see it being used at most of the organization.