You need to know SQL Server basics to keep database performance at the highest level. This knowledge will also help you to be prepared to any potential problems. When working with files, you may discover that there is not enough free space to store the required data in the file. By default, in such situations, SQL Server locks the file and extends it (it’s called – autogrow). Let us learn about SQL Server Index Fragmentation.
Interview Question of the Week #049 – Taking Database Offline
Here is the conversation which I observed the other day. Question: How do we take database off-line? Answer: Well, we can run following script to take the database offline. ALTER DATABASE [mydb] SET OFFLINE WITH ROLLBACK IMMEDIATE Question: Let us assume that your boss suggest that you should wait 30…
Read MoreSQL SERVER – Discussion on understanding NUMA
At the SQLPass conference I have had the opportunity to meet a number of you and you folks have inspired me to learn and share after every trip to this conference. This year, I was fortunate to do a number of sessions this year too. Just the preparation for these…
Read MoreSQL SERVER – Connecting to Azure SQL DB
Learning new methods of working with SQL Server can always be challenging. I found the new learning coming my way while connecting to Azure SQL DB. I was confronted with an error and I was not sure where to start. So this blog is like a travel log of my…
Read MoreSQL SERVER – Getting Started with Project Versions in the SSIS Catalog – Notes from the Field #106
[Notes from Pinal]: We are human and we make mistakes. However, sometimes mistakes are so big that we can’t reverse it. Version control is our rescue when we make mistakes. In my life I have been fortunate few times when I deleted something important and version controlled saved me. Similarly, for SSIS Catalog version control is very important as well.
SQL SERVER – InMemory Tables on SQL Azure DB
There have been tons of enhancements in the InMemory space with SQL Server 2016. I am due to write about them in this blog. Having said that, one of my DBA friend asked me based on the Pluralsight course on SQL Server 2014 Administration – Does SQL Azure support InMemory…
Read MoreSQL SERVER – Free Database Search and Dependency Analysis
This article covers the main features of ApexSQL Search, a free SQL Server Management Studio and Visual Studio add-in for SQL Server database object and text searching and for dependency analysis. Let us learn about Free Database Search and Dependency Analysis.
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.