|
|
-
|
|
As per Microsoft Books Online and SQL Server Security best practice white paper, it is recommended to periodically review privileges granted to public role, and revoke any unnecessary privileges assigned to this role. This is because public role is a speci...
|
|
-
|
|
Normal
0
false
false
false
EN-US
X-NONE
X-NONE
...
|
|
-
|
|
Normal
0
false
false
false
EN-US
X-NONE
X-NONE
...
|
|
-
|
|
sys.dm_exec_query_stats DMV (Dynamic Management View), described in BOL as follows : http://msdn.microsoft.com/en-us/library/ms189741.aspx
Returns aggregate performance statistics for cached query plans. The view contains one row per query statement within...
|
|
-
|
|
To continue our learning towards YouTube API with .NET this article will provide details how we can search for YouTube video list programmatically. In the last post we learn about pulling list of video uploaded by a specific user. To demonstrate the examp...
|
|
-
|
|
As part of our SQL Server infrastructure consolidation project, it was decided to consolidate multiple companies SQL Server 2005 / SQL Server 2008 Reporting Services instances to a new dedicated SQL Server 2012 Report Services instance. These existing SQL ...
|
|
-
|
|
50
Remarks
1. All Possible status of sessions :
· Background
· Running
· Runnable
· Sleeping
· Suspended
2. Percentage of work completed can be viewed for the following commands:
· ALTER INDEX REORGANIZE
· ...
|
|
-
|
|
This post is in continuation to the YouTube API with .NET series of articles. In the last post we learn about pulling region or country specific video feed. In this post we will learn to read single video metadata from YouTube. Each of the video on YouTub...
|
|
-
|
|
This post is next in series of our learning YouTube API with .NET. In the last post we learn about pulling single video metadata using .NET and YouTubeService. In this post we will learn to pull list of videos uploaded by a specific user on YouTube. For d...
|
|
-
|
|
A short and sweet post for a gorgeous morning -
Have you seen a file with extension .wrk in the log shipping copy folder ?
What is this all about, Curious? Then here is the answer -
When the transaction log backup files are copied from the primary server ...
|
|