Anil Singh | Code-sample.com

“ How to SQL Server Profiler Trace events only a Specific database ”? In this post, I am sharing to the “SQL Server Profiler Trace events only a specific database” step by step with YouTube video link. It is very helpful to me and you also. Actually, I always forget how to configure SQL Server Profiler to trace only a specific database . Stayed Informed – YouTube Video demo link for SQL Server Profiler Trace Steps for SQL Profiler Trace as, 1.       Open SQL Profiler. 2.       Click on the “ New Trace ”. 3.       Connect to your “ Database Server ” for Trace. 4.       The “ Trace Properties ” window and after click “ Events Selection ” tab. 5.       Click on check the checkbox “ Select all columns ” options. 6.       And after scroll event trace window on right side and find the database “ column name ”. 7...

Before create a symmetric key, you first setup your database’s master key and certificate and this master key and certificate help us to protect of your  symmetric  key store using the  ALGORITHM   AES_256. In the below examples, I am using a default master key password is System!123 and the certificate name is Certificate_demo . The following steps as given below, --====================================== --MASTER KEY ENCRYPTION WITH PASSWORD --======================================= CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'System!123' GO --=============================== --OPEN MASTER KEY --============================== OPEN MASTER KEY DECRYPTION BY PASSWORD = 'System!123' GO --============================= --CREATE CERTIFICATE --================================== CREATE CERTIFICATE Certificate_demo WITH SUBJECT = 'Certificate_demo' GO --================================================...

“ MongoDB   is the fastest growing database because it’s provided more security protection mechanisms than others and also more reliable in cloud computing environments. It is secure architecture for your deployment”. It is document oriented database and its store the data in document with   JSON  format. Most Popular 71 Key Questions for MongoDB Interviews. What is MongoDB and Why we use? What's New in MongoDB 3.2? Is MongoDB Support Relationship? Is MongoDB Support Replication? What are journaling in MongoDB? What kind of database is MongoDB? In MongoDB, What is a namespace? In which language MongoDB is written? Do MongoDB databases have tables and schemas? What types of languages use to work with MongoDB? Which are the most powerful features in MongoDB? ...

Hello everyone, I am going to share the process to debug stored procedures . The steps as given bellows. ·    Type to exec uspGetWhereUsedProductID(name of your stored procedure). ·    Put break point in your stored procedure. ·    The green debugger arrow  ready for  execute debug. For more detail about debugging stored procedure links http://blogs.msdn.com/b/billramo/archive/2009/04/11/transact-sql-debugger-for-sql-server-2008-part-1.aspx https://www.mssqltips.com/sqlservertip/2410/sql-server-2012-tsql-debugging-enhancements/ http://sqlmag.com/visual-studio-2010/debugging-stored-procedures-visual-studio-2010