sys.dm_exec_procedure_stats DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-us/library/cc280701.aspx
Returns aggregate performance statistics for cached stored procedures. The view...
2013-04-10
1,907 reads
SELECT create_date as ‘SQL Server Install Date’ FROM sys.server_principals WHERE name=’NT AUTHORITY\SYSTEM’
2013-04-10
697 reads
AlwaysOn – Finally, A usable ‘mirror’! In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not...
2013-04-10
4 reads
AlwaysOn – Finally, A usable ‘mirror’!
In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are...
2013-04-10
862 reads
#Description : List all the files of a local or remote drive, run this PowerShell script using PowerShell-ISE.exe for better execution...
2013-04-10
734 reads
Microsoft no longer supports SQL Server 2000 in any capacity.
http://youtu.be/A5cneCgNA9U
2013-04-10
820 reads
In Reporting Services 2008 r2 and above there is a great tool called the Map tool. It is great for...
2013-04-10
970 reads
Sometimes the answer is to keep going.
Forget words, figuring things out, and circumstances. Just keep moving your feet.
~Chuck
"Nothing in the...
2013-04-09
619 reads
Introduction
Recently, I was asked to develop a SSRS based report for the Event Management module in MS Dynamics CRM 2011....
2013-04-09
1,152 reads
SQL Server Management Studio does not allow you to save changes to a table which require table re-creation such as...
2013-04-09 (first published: 2013-04-01)
3,437 reads
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
WA CS 08218154392 Jl. Jend. Ahmad Yani No.169, Watampone, Kec. Tanete Riattang Bar., Kabupaten...
Comments posted to this topic are about the item Managing Incidents and Fighting Fires
Comments posted to this topic are about the item Backing Up a DMK
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers