-
SQL Server Black Box Analysis
“SQL Server Black Box Analysis” script give you a MRI report of SQL Server. Haha ha… Script… create table #ServerStats (create_time datetime,component_type sysname,component_name sysname, state int,state_desc sysname, data xml) insert into #ServerStats execute sp_server_diagnostics — Overview — Note: this events…
//
-
SQL Server Extended Events
DROP EVENT SESSION (Transact-SQL) Drops an event session. SQL> DROP EVENT SESSION [Collect_Deadlocks_New] ON SERVER View all the event session that exists in SQL Server SQL> select * from sys.server_event_sessions Create a Dead Lock Ex.…
//
-
TDE in SQL Server
Transparent Database Encryption (TDE) – It was developed with SQL Server 2008, and it is also available in Oracle database management systems. It is an encryption method…
//
-
Delete vs Truncate
Its a common interview question which people like to ask to know your understanding on RDMS concepts. I too few times encountered the question in…
//
-
SQL Server 2016 SP2 CU12 Upgrade Issue.
Few days back my patching team was doing security upgrade on one of customer production server. After their patching SQL Server has not came up. That…
//
-
Full Database Backup Restore
Working as DBA or developer, restoring a database is the request which we get regularly. Restoring a database is easy task if our back file…
//
-
Differential Database Backup Restore
If we want to restore database with differential backup then first we need to restore associated fill backup with NORECOVERY option.Below is example… ——————————————————————– RESTORE DATABASE AdventureWorks FROM DISK = ‘C:\AdventureWorks.BAK’ WITH NORECOVERY ——————————————————————–…
//
-
Managing Database Transaction Log File
Hey guys, In this blog I am going to explain you about “How to manage Database Transaction Log File” This is the very common task…
//
-
High VLF Count in Database Log File
High VLF count can create a performance problem in huge OLTP SQL Server system. Every 10 GB of T-Log file, VLF count should not more…
//
-
Pages in Database
Boot Page Every DB has only one boot page. Boot page stores DB configuration information. It can find in page # 9 of the first…
//