Probably, everyone who writes SQL code has used INSERT statement, which alongside SELECT, UPDATE and DELETE, is a part of a basic operations’ set for data manipulation. Let us learn about Query Plan Analysis.
SQL SERVER – Tools for Proactive DBAs – Policy Based Management – Notes from the Field #012
[Note from Pinal]: This is a 12th episode of Notes from the Fields series. When taking a vacation the biggest worry any DBA has it that in their absence what will happen to their database. They are often worried that something will go wrong with their server or some users…
Read MoreSQL SERVER – How to Survive on Free Tools for Month – Database Comparison Done Easily with ApexSQL Diff
ApexSQL Diff is a SQL Server database comparison software with a free Community version and Windows Azure SQL database support. To compare Windows Azure SQL databases in ApexSQL Diff selects “Database” as the data source type and a destination. Select the SQL Server Authentication and type the SQL Azure server name, user and password. Select databases from the list of available databases and click the Compare button.
SQL SERVER – SQLWays – Database and Application Migration Tool
Database and what is more application migration has always been time and money consuming task. In this article I’m going to tell you about one of the ways to make this task easier in all senses. I suppose that you might have already heard about SQLWays database migration tool, developed…
Read MoreSQL SERVER – How to Validate Syntax and Not Execute Statement – An Unexplored Debugging Tip
In one of the recent interview I had asked questions of interviewees – If you are a SQL Server Developer there must be times when you want to validate syntax, but do not want to execute a query. What is the surest way to check that your syntax is valid…
Read MoreSQL SERVER – Identify Oldest Active Transaction with DBCC OPENTRAN
I recently received a question on my Facebook page- “Pinal, How do I know if there is any open transaction in my database? I recently wanted to restart my server, but my manager asked me to first check if there is any open transaction in database before I restart the…
Read MorePersonal Technology – Inserting Image in PDF File with Adobe Acrobat X Pro
Here is the one of the issues, I keep on facing every single time. Just like every DBA and Developers I keep on working with PDF. I use Adobe Acrobat X Pro to edit my PDFs. I am usually able to pretty much all the work related to text just…
Read More
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.