jump to navigation

Blog title doesn’t match with the content March 24, 2015

Posted by msrviking in General, Uncategorized.
Tags: , ,
add a comment

No surprises here.

Although my blog title says My Love with SQL Server I still might have to write posts on different database technologies I am learning and getting passionate above. If I am not on top of SQL Server directly, I would be working upon something related to data for sure. And whenever that happens I am supposedly to blog on how that one thing can be done in SQL Server too.

So, happy reading.

SQL Express Edition in Production? Yes you could, but No you shouldn’t.. May 10, 2013

Posted by msrviking in Uncategorized.
Tags: , , , , ,
add a comment

A very important realization when one of my team mates came up to me and asked this question – Can we deploy SQL Server Express Edition in Production?

At first I said, “No”, and I was very confident of it. But because of some misled information I had in my mind I was wrong. So I had to understand who else does this and how..but strongly I don’t recommend SQL EE in Production and you would do it only if you are not too serious about the data you deal in production /business.

Here are few links which talk on this topic, and you may also feel confident of taking decision like this based on your requirements.

http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/46ad8aa8-2097-49df-984c-58634e1ecfa2

http://social.msdn.microsoft.com/forums/en-us/sqlexpress/thread/4619FD15-13C3-4914-B1DD-B65D3154BD5B

http://stackoverflow.com/questions/180537/sql-express-for-production

RDBMS – end of it because of NoSQL or Big Data, No! March 29, 2013

Posted by msrviking in Uncategorized.
Tags: , , , , , , ,
1 comment so far

Sometime back I had blogged on a different topic but relevant one as this one, today. Those were the days when DB on cloud was introduced and my team mate had questioned my skills and my existence.

At that time, I remember I was doing more of a role under technology specialist title, and was little of DBA-ing, and the question was asked – Why do a role or title of such what I was working for be useful if DB moves to cloud? I had my own explanation and I have come through it until today. My point was simple – Relational DB systems are here to exist and will exist in future, but with different flavors.

It is reiterated again by someone else and I feel satisfied that I was right then, and right until now. I would suggest to read this post by Brian Proffitt – Relational Databases Aren’t Dead, and they aren’t even sleeping (http://readwrite.com/2013/03/26/relational-databases-far-from-dead). I completely vouch my thoughts that RDBMS will exist in future but will serve different purpose. If I or anyone else doesn’t gallop with time and technology then my position, skills will be in question and doubt of how I would fit in the industry where Big Data and NoSQL is famous, and getting that “fanned” fame too.

So at the end, DBA skills, DB specialist, DB Engineer, DB Architect and Data Architect positions will exist in RDBMS world, but each of these roles will have better and different skills to deal with changing data technology and businesses.

Let me know what you all think.

Cheers and Enjoy!

TempDB shows available free space in negative March 28, 2013

Posted by msrviking in DB Administration, SQL Server 2008, Uncategorized.
Tags: , , , , , ,
add a comment

I was browsing through one of my favorite forums to replenish my knowledge on SQL Server based on others experiences. While I was doing that, I found this interesting question which made me think “how could that be possible?”.

I am not writing this post as a solution but wanted to share the forum post, and discussions that are happening by other experienced DBAs. Well if that is not enough a Gent has mentioned couple of links in the forum, on why this behavior could be there first in place. As expected, this was a bug in SQL Server 2008 SP1 and fixed in SQL Server 2012, but I am not sure if folks are having issues with SQL Server 2008 R2 though.

Here are those links that you might want to refer in case you have issues. One link explains the probable reason of the behavior, and the other one is a connect item.

http://blogs.msdn.com/b/ialonso/archive/2012/10/08/inaccurate-values-for-currently-allocated-space-and-available-free-space-in-the-shrink-file-dialog-for-tempdb-only.aspx
http://connect.microsoft.com/SQLServer/feedback/details/518309/tempdb-log-file-showing-free-available-space-in-negative

I couldn’t and didn’t replicate the issue if at all I had to, because there is documented information on this. BTW, I haven’t seen any response on this question post by the person who had asked. So I am presuming this is the reason and probably could be fixed or is fixed.

Cheers and Thanks.

Check out Save Our Tigers | Join the Roar January 29, 2010

Posted by msrviking in Uncategorized.
add a comment

Title: Save Our Tigers | Join the Roar
Link: http://gotaf.socialtwist.com/redirect?l=-807276413581280649911