Tag Archives: General

HA between Windows and Linux

If you ask before couple of years about Microsoft and Linux can be compatible was a dream. now Microsoft has made SQL Server to work on Linux we have accepted that. It has some Middle OS to interact with Linux … Continue reading

Posted in Azure, High Avaliability, Others, SQLonLinux, What I learned today, Whats New | Tagged , , , , | Leave a comment

Count_Big() function

Learned new function for count while going through the channel 9 video for salva. where for a very big table count it gave an error :   Count_Big() – BOL: Returns the number of items in a group. COUNT_BIG works … Continue reading

Posted in BIGDATA, General, Others, What I learned today | Tagged , | Leave a comment

Happy New Year… Late:)

Yeah I know its new year and i am back from quite some time. during these days i was learning things but could not able to make time to blog about it. This year would like to write more on … Continue reading

Posted in Future DBA, General, Others | Tagged , | Leave a comment

Azure support MySQL & PostgreSQL

After SQL Server support on Linux Microsoft is not have another great enhancement where now Azure supports MySQL and PostgreSQL database technologies. this shows that no Microsoft is going to lead the industry by making themselves ready for tomorrow where … Continue reading

Posted in Azure, BI, Cloud, SQL Server 2017, vNext | Tagged , | Leave a comment

24 Hours of SQLPASS

Like every years before PASS summit, this years also SQLpass has 24 hrs sessions… it has great sessions every time, and this time as well. During this 24 hrs SQLPASS invites 24 expertise to present a audio session for an … Continue reading

Posted in Free Stuff, Others, Training, What I learned today | Tagged | Leave a comment

Good Bye 2012 and welcome 2013

Hey Everyone….. from quite some time I have not written Blogs due to some personal and transiting from my old company … yeah If you read my last year good bye Blog I have indicated about my interest for changing the company took … Continue reading

Posted in Computers and Internet, General, Personal | Tagged | Leave a comment

More IMPORTANT miscellaneous info

This is a first blog for this month, yes I was busy with Powershell quiz and some other personal stuff. Okay, continue with Miscellaneous Info here is some more important stuff/ information about sql server. >>Ghost cleanup task runs every 5minuts … Continue reading

Posted in Basic, Experts, Limitation, Others | Tagged , | Leave a comment

Last updated datetime of Sql Server files

*This is related to physical file size of a MDF or LDF file not internal allocation. One of our user asked that the ldf file is not changing, on checking the last modified date time, user was asking this. Its … Continue reading

Posted in General, Internal, Transaction Log, What I learned today | Tagged , | Leave a comment

Good Bye 2011

Good Bye 2011 Hey there, this year is going to an end and just want to recall what all happened this year in my life both personally (cannot disclose much J) and professionally. The good news about this year is … Continue reading

Posted in Basic, General, Others, Personal | Tagged | Leave a comment

Model Database size has increased.

  Model database has has increased during sql server development processes here is the size of model database SQL Server version Physical file size (bytes) sp_spaceused information model.mdf modellog.ldf reserved data index_size unused 2000 655,360 524,288 528 KB 144 KB … Continue reading

Posted in Computers and Internet, Others | Tagged , | Leave a comment