Multilanguage Table, How to insert different language text in table ?

Issue :
Today, I received one request from my old friend.
He wants to insert text in different languages in table. He...

Lions and Tigers and Bears…

Last Thursday I found myself on a journey of sorts.  There weren’t any lions or tigers or bears, but there were plenty of “Oh My”‘s. It all began on...

Lions and Tigers and Bears…

Last Thursday I found myself on a journey of sorts.  There weren’t any lions or tigers or bears, but there...

How to secure SQL Server?

Databases are an important reservoir of sensitive information, and that is why it is important for us as a DBA...

Using SQL Server 2012 FileTables

Reblogged from Basit's SQL Server Tips:

SQL Server 2012 allows you to store file/directories in a special table called FileTable that...

(Mis)Using DBCC Page

In one of my presentations recently I was recommending DBCC CHECKDB on every database every day. I realize that isn’t...

A review of SQL Interoperability / Joes 2 Pros Volume 5 by Rick A Morelan

I recently passed my MCTS 2008 Development (70-433).  Yay me!  That made my 3rd 2008 certification.  This one was probably the...

Why Tune Queries?

It’s just a query against the database. If things are running slow, buy some more memory, a faster CPU or...

Last Weeks Top 10 “Reading” Links #2

Throughout the week, I like to tweet links to the things that I’ve been reading.  Since they all come out...

SQL Server # TSQL to Convert STRING in PROPER format

Problem Statement
SQL Server has got in-built functions to convert the given string into LOWER() or UPPER() format but it does...