MSSQL

  In this article, we will first talk about how to configure the file group structure when the database is first created or comes from …

  I have already mentioned how to create a linked server that will connect to Oracle in the article named “How To Create a Linked …

  When you create a linked server to connect to Oracle, you need to put an oracle user into the linked server. Before reading this …

  With the help of the following query, you can access the answers to the questions listed below. You can filter the query as you …

  Parameter Sniffing is the result of using the query plan in the cache. When a stored procedure is compiled the last time a query …

  You can keep the database-level code that you need to use every time in the application through “stored procedures” in the database. You can …

  In this article I will explain you to list active queries in postgresql. First you must connect to postgresql. You may want to read …

  Account Lockout Policy is a security mechanism used by SQL Server. For example, consider someone who is trying to log in with a user …

I find OLA HALLENGREN’s maintenance script very successful and practical. In this article I will tell you where to download and install the script that …

  You can configure SQL Server with sp_configure at instance level. In this article I want to explain most important configurations in sp_configure. First we …