knowledgebaseworld.blogspot.com
Imran's Knowledge Base World: June 2012
http://knowledgebaseworld.blogspot.com/2012_06_01_archive.html
Imran's Knowledge Base World. Information Sharing, Technical Articles. You can find solutions, best precticies for ASP.net application. More knowledge sharing on C#, AJAX, SQL, .Net Framework, OOPs Concepts, SQL Server 2005, SQL Server 2000, Programming. Jun 27, 2012. Deleting Parent and its child record without setting ON CASCADE DELETE. I found solution on Stack Overflow. And base main article from sqlteam. Expects the name of a table, and a conditional for selecting rows. Delete everything beneath them.
knowledgebaseworld.blogspot.com
Imran's Knowledge Base World: December 2012
http://knowledgebaseworld.blogspot.com/2012_12_01_archive.html
Imran's Knowledge Base World. Information Sharing, Technical Articles. You can find solutions, best precticies for ASP.net application. More knowledge sharing on C#, AJAX, SQL, .Net Framework, OOPs Concepts, SQL Server 2005, SQL Server 2000, Programming. Dec 10, 2012. Query to Find First and Last Day of Previous, Current and Next Month - SQL Server. CurrentMonthFirstDay = DATEADD(dd, -( DAY. CurrentDAte) 1, @CurrentDate). CurrentMonthLastDay = DATEADD(d, -1, DATEADD(mm, 1, @CurrentMonthFirstDay). Transfe...
knowledgebaseworld.blogspot.com
Imran's Knowledge Base World: Deleting Parent and its child record without setting ON CASCADE DELETE
http://knowledgebaseworld.blogspot.com/2012/06/deleting-parent-and-its-child-record.html
Imran's Knowledge Base World. Information Sharing, Technical Articles. You can find solutions, best precticies for ASP.net application. More knowledge sharing on C#, AJAX, SQL, .Net Framework, OOPs Concepts, SQL Server 2005, SQL Server 2000, Programming. Jun 27, 2012. Deleting Parent and its child record without setting ON CASCADE DELETE. I found solution on Stack Overflow. And base main article from sqlteam. Expects the name of a table, and a conditional for selecting rows. Delete everything beneath them.
knowledgebaseworld.blogspot.com
Imran's Knowledge Base World: November 2013
http://knowledgebaseworld.blogspot.com/2013_11_01_archive.html
Imran's Knowledge Base World. Information Sharing, Technical Articles. You can find solutions, best precticies for ASP.net application. More knowledge sharing on C#, AJAX, SQL, .Net Framework, OOPs Concepts, SQL Server 2005, SQL Server 2000, Programming. Nov 27, 2013. Exposing property as OperationContract in WCF. I would like to share thing which I just learn today J. Nothing fancy, and here is client to call this service and its output. Attribute ot get or set not on top of member just we do with method.
knowledgebaseworld.blogspot.com
Imran's Knowledge Base World: April 2012
http://knowledgebaseworld.blogspot.com/2012_04_01_archive.html
Imran's Knowledge Base World. Information Sharing, Technical Articles. You can find solutions, best precticies for ASP.net application. More knowledge sharing on C#, AJAX, SQL, .Net Framework, OOPs Concepts, SQL Server 2005, SQL Server 2000, Programming. Apr 4, 2012. Changing Physical Path of multiple Applications in IIS 7. We can use backup feature for IIS 7 which helps to take backup as well as change directories of multiple applications at same time. First we are going to do backup IIS7. Once you are ...
sqlxpertise.com
General | SQLXpertise
https://sqlxpertise.com/category/general
Posts about SQL Server and SQL Azure. Welcome to my blog! Archive for the ‘General’ Category. Microsoft Community Contributor Award for 2011. July 28, 2011. I am happy to share everyone that I have been awarded Microsoft Community Contributor Award for 2011. I am so proud that Microsoft has recognized my contribution to the community and I am really proud to be a member of SQL Server and SQL Azure community. Thanks to everyone for your continued support on this! June 21, 2011. Link to download the slides.
sqlxpertise.com
SQLXpertise | Posts about SQL Server and SQL Azure | Page 2
https://sqlxpertise.com/page/2
Posts about SQL Server and SQL Azure. Welcome to my blog! Encryption in SQL Server 2012–Creating Service Master Key and Database Master Key. March 23, 2013. All Version of SQL Server 2012 including the Express Edition supports Encryption. The first steps to start Encrypting data in SQL Server 2012 are as follows. 1 Backup Service Master Key and keep it in a secure location. N 'C: Workspace MYServiceMasterKey.Key'. PASSWORD = N 'p@ssw0rd'. 3 Backup the Database Master Key to a secure location. The downlo...
sqlxpertise.com
SQL Server 2012 | SQLXpertise
https://sqlxpertise.com/category/sql-server-2012
Posts about SQL Server and SQL Azure. Welcome to my blog! Archive for the ‘SQL Server 2012’ Category. Encryption in SQL Server 2012–How to encrypt data using Asymmetric Key functions. April 5, 2013. In the previous episodes, we saw How to create Asymmetric key. And How to use Asymmetric key to encrypt a Symmetric key. In this Episode of Encryption in SQL Server 2012, We will see How to encrypt data using Asymmetric Key functions. To encrypt data using Asymmetric Key, we need to use EncryptByAsymKey.
sqlxpertise.com
Encryption in SQL Server 2012–Creating Asymmetric Keys using Password and Strong Name Key file | SQLXpertise
https://sqlxpertise.com/2013/04/02/encryption-in-sql-server-2012creating-asymmetric-keys-using-password-and-strong-name-key-file
Posts about SQL Server and SQL Azure. Welcome to my blog! Encryption in SQL Server 2012–Creating Asymmetric Keys using Password and Strong Name Key file. Encryption in SQL Server 2012–Creating Asymmetric Keys using Password and Strong Name Key file. April 2, 2013. In this episode of Encryption in SQL Server 2012, We will see how to create Asymmetric Keys in databases using Password and Strong Name Key file. We can create Asymmetric Keys using the following options. 1 Creating using Password. In the next ...
sqlxpertise.com
Encryption in SQL Server 2012–How to use EncryptByCert and DecryptByCert functions | SQLXpertise
https://sqlxpertise.com/2013/03/31/encryption-in-sql-server-2012how-to-use-encryptbycert-and-decryptbycert-functions
Posts about SQL Server and SQL Azure. Welcome to my blog! Encryption in SQL Server 2012–How to use EncryptByCert and DecryptByCert functions. Encryption in SQL Server 2012–How to use EncryptByCert and DecryptByCert functions. March 31, 2013. In the previous article. We saw how to create X 509 Certificate and register it in SQL Server,. Now we will see how we can use the registered certificates. Please refer to the below sample on how we can use these functions. Encryptedtext varbinary(300); DECLARE.
SOCIAL ENGAGEMENT