SQL Server Security Aspects
SQL SERVER – How to Disable and Enable All Constraint for Table and Database
One of the most popular questions I find still coming to via email is how to enable or disable all the constraint for single table or database. Well, in this blog post we will not discuss the reasons why do you need them or what are the advantages or disadvantages…
Read MoreSQL SERVER – How to Learn SQL Server 2014 – Video Tutorial
As December begins the realization is that Year 2014 is about to come to an end. The month of November was a travel month for me. I have travelled to 6 different cities, 2 countries and 3 different conferences presenting and discussing SQL Server. While presenting at this conference I…
Read MoreSQL SERVER – Inside Temp table Object Creation – Part II
After my previous article on “Inside Temp table object creation”, I had a number of people ask me more about this topic. There seems to be a need for understanding these basic fundamentals that we have known for ages in a refreshingly new way. Though there were tons of mails…
Read MoreSQL SERVER – Customization of New Query in SQL Server Management Studio
Recently I was working with one of my friends who handles production server databases as a senior DBA. He told that recently one of the Jr. DBA was fired from his company because he has run a drop table command on a production server. He was scared and from that time onwards, every DBA has been asked to run select @@servername commands before executing any query on any server. Similar to this situation, many times a DBA wants a set of command, which they use very frequently, should be available as soon as SQL Server Management Studio is opened. Let us learn about Customization of New Query in SQL Server Management Studio.
SQL SERVER – Identifying T-SQL Missing Parameter Data Types with SQL Server
I like challenges and when we are faced with a challenge – I just cannot sleep. I am in constant search for solution. More importantly I look forward for the learning experience these bring to me. Recently a senior developer was talking to me and got me thinking. Senior Developer:…
Read MoreSQL SERVER – Proof of Concepts with Windows Azure – Notes from the Field #056
[Note from Pinal]: This is a 56th episode of Notes from the Fields series. If you are DBA and Developer there is always a situation when you want to prove yourself by building a small proof of concepts of your idea. However, most of the time, it is way more…
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.