Sql Server: How to use RAISERROR

Posted by Sqltimes
On May 31, 2014
0 Comments

RAISERROR is an interesting and very useful t-sql command. It allows us to send information back to the caller about the status of the current execution. Since RAISERROR supports character substitution similar to printf function is C language, it is very valuable in some situations. Here we see some sample examples. Simple error message 1 […]

Posted by Sqltimes
On May 21, 2014
0 Comments

Quick one today Sometimes, there is a need to DROP more than one columns from a table. The usual approach of DROPping one column at a time still works. Today we’ll explore the option to DROP multiple columns at the same time using a single ALTER TABLE statement. It is intuitive this way… 1 2 […]

Posted by Sqltimes
On May 17, 2014
0 Comments

Since its introduction, in Sql Server 2005, Database Mirroring has been one the popular features. We have database mirroring configured on several production databases. It is easy to configure, maintain and very efficient in transporting transactions from Principal server to the Mirror. With more new improvements in later versions, the transfer of transactional log to Mirror […]

Posted by Sqltimes
On May 14, 2014
0 Comments

Quick one today: Certificates are used everywhere these days. In Sql Server, certificates are used in several features to make communication secure — with proper authentication. Certificates are asymmetric keys, so they have public and private keys. Following are the steps to create and backup certificates and sometimes with its private key. Create a Certificate […]

Posted by Sqltimes
On May 10, 2014
0 Comments

Quick one today When we prepare SQL scripts to run in a production environment, we practice defensive coding mechanism. So, before we DROP an object, we check if it actually exists; Check if a function exists, before DROPping it. Today’s question is how to do that for a user-defined table type? See example below: 1 […]

Posted by Sqltimes
On May 7, 2014
0 Comments

Quick one today Creating database master key is important and prerequisite to creating other certificates in a Sql Server database. Database Master key is at each database level and is stored in both the user database and in master database. Some highlights of this database Master key: It is a symmetric key Used to protect […]

Posted by Sqltimes
On May 3, 2014
0 Comments

Check point Check point writes out, to disk, all data pages that have changed since the last check point. The goal of checkpoint is to reduce the amount of time Sql Server takes to perform rollforward and rollback operations. As part of this, it makes sure all the dirty pages are written to disk, so […]

Sql Server: How to use RAISERROR

Sql Server Drop multiple columns from a table in a single statement

Sql Server : Change database mirroring expired certificate

Sql Server Backup Certificate along with Private Key

Sql Server : How to check if a user define table type exists using query (TSQL)

Sql Server : Create Master Key (database key)

Sql Server Difference between Checkpoint, Lazy Writer and Log Flush