Tag Archives: General

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

Happy Diwali

Happy Diwali to everyone, on this especial day, I would like to announce another good news that I will be writing a series of blogs (blog a day ) for November month. Hope I could able to complete it as … Continue reading

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

Denali

The new version of Sql server “11” code name “Denali” has released and CPT3 is ready to download here: http://msdn.microsoft.com/en-us/sqlserver/denali_resource_center.aspx The more infomration on this by experts : http://www.brentozar.com/archive/2010/11/sql-server-code-name-denali-release-date-today/ http://sqlblog.com/blogs/aaron_bertrand/archive/tags/denali/default.aspx http://sqlinthewild.co.za/index.php/2010/11/09/first-impressions/ http://sqlcat.com/whitepapers/archive/2010/11/09/new-spatial-features-in-sql-server-code-named-denali-community-technology-preview-1.aspx http://www.ssistalk.com/2010/11/09/sql-server-future-code-name-denali-ctp1-now-available/ http://download.microsoft.com/download/8/C/1/8C1CE06B-DE2F-40D1-9C5C-3EE521C25CE9/Columnstore%20Indexes%20for%20Fast%20DW%20QP%20SQL%20Server%2011.pdf Will write a blog about Whats … Continue reading

Posted in Computers and Internet, General, What I learned today | Tagged , , | Leave a comment

Miscellaneous Info

Some undocumented and important stuff   DMV: dbcc showcontig – index_physical_stats will scan complete index pages even if you use where clause Backup : uses 960k speed can reduce to 64k. Virtual File Space … for 32 bit system. Default big … Continue reading

Posted in DMV, Experts, General, Others, Tool | Tagged , , | Leave a comment