Earlier this year, I was fortunate to take part in the first edition of the Group By Conference organized by Brent Ozar. I was extremely fortunate that I was able to present an hour long presentation on the subject 3 Common Mistakes to Kill SQL Server Performance.
SQL SERVER – Speed Up Performance Without Code Change
In this blog post we are going to leave about how to Speed Up Performance Without Code Change or Configuration Change in SQL Server.
Restore or Attach Database Without Log File – SQL in Sixty Seconds #082
One of the most common question I get on blog is – how do I attach database without log file. I have previously blogged about it over here. I request you to read this blog post if you want a solution where you can learn how to attach database to SQL Server with the help of T-SQL.
PostgreSQL – Learn Online in a Single Day – PostgreSQL Learning Path
PostgreSQL is considered to be one of the most advanced open source database.In this blog post we will discuss about the PostgreSQL Learning Path.
Install SQL Server 2016 Sample Database WideWorldImporters – SQL in Sixty Seconds #081
I have been a very loyal user to sample database AdventureWorks for a while, I really liked the overall database. However, as we know SQL Server releases, new features every year and along with the new features there is always need for a new Sample Database which contains all the necessary data and schema to demonstrate new features of the SQL Server. The SQL Server team has recently released a new sample database WideWorldImporters which can be used to demonstrate new features of the SQL Server.
Install SQL Server Management Studio 2016 – SQL in Sixty Seconds #080
Earlier this week, I have published a blog post where I explained how to install SQL Server 2016. One of the most asked questions was Where is SQL Server Management Studio 2016? I totally understand why this particular question is being asked often. I have decided to create a video explaining the how to install SSMS 2016.
SQL SERVER 2016 – Learn Installation of SQL Server 2016 in 2 Minutes Video
Every time when new SQL Server version arrives, lots of people want to install it. Let us learn installation of SQL Server 2016 today.