18 Nov
by dbtut
With the help of the following script, you can find the date of the last backup of each database on that instance. ‘L’ indicates Log Backup. If you type ‘D’ in this section, you can see the last full backup date, if you type ‘G’, you can see the latest differential backup date. If […]
17 Nov
by dbtut
Policy-Based Management is a feature that introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to determine our standards and to perform our controls automatically. For example, we can create a policy for control purposes so that the names of our stored procedures do not start […]
16 Nov
by dbtut
First of all, don’t forget to take backup for the security of your data. You can change the database’s collation with the following code. [crayon-5bf19179bb2ae718654368/] However, the database collation change does not apply to existing tables and columns. If you want to make the same change for existing tables and all columns, you […]
15 Nov
by dbtut
Sometimes the name of the server changes and the SQL Server instance name must change accordingly. For example, suppose your server name is a test and you have an instance named testinstance on your test server. You can normally connect to Instance as “test\testinstance”. Suppose that the name of the test server is changed […]
14 Nov
by dbtut
Policy-Based Management is a feature that introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to determine our standards and to perform our controls automatically. For example, we can create a policy for control purposes so that the names of our stored procedures do not start […]
13 Nov
by dbtut
You can read the article “How To Create SQL Server Audit” to get more information about Audit and create an audit. You can read an audit via SSMS with the help of the following script. [crayon-5bf19179bb978809000442/] We read our audit “AuditFileName.sqlaudit” under “C:\Audit” path in our script. You must write the path of […]
12 Nov
by dbtut
We need to create an Audit to record transactions made by people and dbas in SQL Server. In this article, we will examine the process of creating an audit. We can define two types of audit. Database Level Audit: First, right-click Audits in the Security section of SSMS and click on the new […]
11 Nov
by dbtut
I wanted to write this article to make it easier for you to choose between SQL Server’s technologies used for HA (High Availability) and DR (Disaster Recovery). Briefly, we will compare the technologies listed below. Always On Failover Cluster Database Mirroring Always ON Availability Group Replication Log Shipping Always On Failover Cluster: You […]
10 Nov
by dbtut
You can use the following script to collect the enviroment information that are set on the user you are connecting to the database. This allows you to access all values assigned to the user. [crayon-5bf19179bbb59959735293/]
10 Nov
by dbtut
Database Snapshot is the creation of an unchangeable image of the database, you can think of it as taking current photo of database. If I explain it through an example it will be clearer. For example, we take the snapshot of the AdventureWorks2014 database. We are reading through this snapshot. No changes have […]
