|
|
-
|
|
Transparent Data Encryption(TDE) is used in SQL Server to protect data by encrypting physical files of the database.In TDE only files (ldf, mdf and bak) will be encrypted, but not the data. In this TDE, database will be encrypted using a Database Encryptio...
|
|
-
|
|
This article is next in series of our learning PEGA. In the first article we learnt what is PEGA and the subsequent articles talked about WorkType and WorkItem concepts in PEGA. We also learnt what are business rules in PEGA? In this post we will examine ...
|
|
-
|
|
SQL Server uses indexes to sort and organize table data. It creates indexes based on ordering values from one or more selected columns. SQL Server automatically creates indexes when you define a primary key or unique constraint. You can use indexes to mana...
|
|
-
|
|
sys.dm_db_file_space_usage DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms174412.aspx
Returns space usage information for each file in the database.
It’s most commonly used DMV to check total used &...
|
|
-
|
|
It has been a little while since I posted something and I’ve been meaning to finish off this blog for a few weeks now, but I have been a little busy with the arrival of my 2nd son (and have been distracted by my new Alienware laptop!)… Anyway I recently bl...
|
|
-
|
|
In my previous article (Different techniques to identify blocking in SQL Server) on MSSQLTips.com, I discussed about locks and blocks, and presented you with an overview on how to troubleshoot and resolve blocks using dynamic management views and Activity ...
|
|
-
|
|
The public role is a special fixed-database role, which exists in every SQL Server database. The public role is different from all other database-level roles because in SQL Server, every database user is automatically assigned to the public database role, ...
|
|
-
|
|
This article is next in series of our learning PEGA. In the last two articles we learn what is PEGA and what are Work Type and Work Items in PEGA. In this post we will learn what are Business Rules in PEGA? In the traditional programming such as Java, .NET...
|
|
-
|
|
Hello Friends,
As discussed in my previous blog the new architecture of Service Application in 2010. Today I am here with the discussion with:
1) How different things holds together in Service Application?
2) What are the different aspects which combined...
|
|
-
|
|
The 7th cumulative update release for SQL Server 2012 RTM is now available. Cumulative Update 7 contains all the hotfixes released since the initial release of SQL Server 2012 RTM.
Those who are facing severe issues with their environment, they can plan ...
|
|