How to store UTF-8 data in SQL Server
Category: IT, MS SQL Server, PHP Tags: DBA, Development, IT, Optimization, SSMS, Transact-SQL Comments: 2Very frequently we need to use the data type UTF-8 to store a data in different languages. As described in the MSDN page the UTF-8 data type is stored in the ‘Samples’ folder in SQL Server (Server\100\Samples\Engine\Programmability\CLR\UTF8String). You just need to activate it.
MaraK
Category: C#, IT, MS SQL Server Tags: Development, IT Comments: 3I’m starting a project for management of a small store, using C# and SQL Server Express.
Félicitations
Fender Bass and Amplifier
Category: Music, Personal Tags: Fender, Music, Personal Comments: 2Last Friday I drank two beers with a bunch of smiled people and one of them asked me if I have bought my bass. I answered no. He said that live is so simple and if I die tomorrow, I’ll regret for every day I have not played. He’s right. Yesterday and today I visited two music stored to find my bass. Now I have to wait for the price and order my Fender Precision American Deluxe bass and the amplifier (Fender Rumble 350 Combo). What else? A cable, a strap and a bag.
Félicitations
Equal Action to Identical Databases
Category: IT, Transact-SQL Tags: DBA, Development, SSMS, Transact-SQL Comments: 0If I administer 345 identical databases I can do equal action to all of them (or some of them) easy by selecting the names of the databases, generate dynamic code, execute it and select the result and the errors (is any).
‘My favorite drummers’ list
Category: Music, Personal Tags: Drums, Music Comments: 0To play drums (or whatever else) is not only to hit the sticks, pull the strings or push the buttons fast and technically. A joke says that a father took his son to an old piano teacher to have his opinion. The kid played very fast and technically well. He even used his nose to push a button in an “impossible to play situation”. The final words of the teacher were:
Boy, you play very well. Soon you’ll start to create a real music!
In this line of thought, I present you a short list (will be updated) of my favorite drummers. Drummers, who are not only drummers, but also magicians.
SELECT * or SELECT [Column Name] in IF statement in MS SQL Server
Category: IT, MS SQL Server, Transact-SQL Tags: Development, Optimization, Transact-SQL Comments: 1When we decide how to manipulate the data, we use IF statement verification. For example if we export information about merchant sales, we have two common groups of merchants – these we scan (with serial numbers) and these we don’t scan. For both of them we use two BEGIN… END blocks. To verify the type we use IF statement which searches for a row in ‘RegisteredScans’ table.
Select server logins and their roles in SQL Server
Category: IT, MS SQL Server Tags: DBA, SSMS, Transact-SQL Comments: 0To view all the server logins and their roles I use the system view sys.syslogins and CASE to convert 1 to “Yes” and 0 to “No”.
Hey, I’m not only retro!
Category: Music, Personal Tags: Bass, Drums, Music, Personal Comments: 0I made a quick tour in my blog and I noticed that the music i share is little… old :-D
I like every music of every age that makes me stop thinking of something else, but the music.
Thank to Last.FM I can check when I have listened Liquid Tension Experiment last. It is interesting to me, because two days ago I noticed that I have their albums in my MP3 player…
This morning my attention was attracted by a little lesson for drummers and bass players :-)
Félicitations
