- Follow Vinay Thakur on WordPress.com
Blog Hits
- 115,078 hits
Categories
- Add/remove (9)
- AI (4)
- Automation (1)
- Azure (4)
- Backup and Restore (15)
- Basic (14)
- BI (3)
- BIGDATA (6)
- Books (6)
- Bug (7)
- Cloud (7)
- Computers and Internet (29)
- Containerization (2)
- Database System (3)
- DB Design (3)
- DeadLock (3)
- Denali (36)
- DevOps (1)
- Disaster Recovery (18)
- DMV (6)
- Docker Swarm (2)
- Error Log (8)
- Experts (9)
- FileStream (1)
- Free Stuff (7)
- Future DBA (17)
- General (32)
- High Avaliability (23)
- History (3)
- Imp dates (3)
- Index (5)
- Installation (14)
- Internal (13)
- Isolation Level (2)
- Kubernetes/Docker/Container (8)
- Limitation (9)
- Linux (1)
- Lock/Blocking (7)
- Log Shipping (1)
- Memory (6)
- Migration (3)
- MongoDB (6)
- MySQL (26)
- News (4)
- NoSQL (10)
- Open Source (2)
- oracle (1)
- Others (104)
- Performance Tuning (26)
- Personal (5)
- Powershell (33)
- Python (2)
- RDBMS (8)
- Replication (20)
- Security (1)
- Software (4)
- sql 2016 (10)
- Sql server 2014 (2)
- SQL Server 2017 (9)
- SQL Server 2019 (6)
- SQLonLinux (8)
- SSRS (1)
- TempDB (5)
- Tool (14)
- Training (2)
- Transaction Log (13)
- Troubleshooting (50)
- vNext (4)
- Webcast (9)
- What I learned today (77)
- Whats New (47)
- Whitepapers (9)
Archives
- April 2020 (3)
- January 2020 (2)
- December 2019 (1)
- November 2019 (9)
- October 2019 (4)
- September 2019 (1)
- August 2019 (1)
- March 2019 (2)
- February 2019 (2)
- January 2019 (5)
- December 2018 (6)
- October 2018 (2)
- September 2018 (7)
- July 2018 (3)
- May 2018 (25)
- February 2018 (1)
- January 2018 (2)
- August 2017 (2)
- May 2017 (2)
- April 2017 (1)
- March 2017 (2)
- February 2017 (1)
- October 2016 (2)
- September 2016 (9)
- May 2016 (1)
- April 2016 (1)
- January 2016 (2)
- December 2015 (1)
- July 2015 (1)
- May 2015 (1)
- December 2014 (1)
- February 2014 (2)
- October 2013 (3)
- June 2013 (1)
- May 2013 (1)
- January 2013 (1)
- October 2012 (1)
- September 2012 (3)
- August 2012 (1)
- July 2012 (2)
- June 2012 (1)
- May 2012 (31)
- April 2012 (3)
- March 2012 (3)
- February 2012 (3)
- January 2012 (2)
- December 2011 (4)
- November 2011 (33)
- October 2011 (1)
- September 2011 (1)
- August 2011 (4)
- July 2011 (1)
- June 2011 (5)
- May 2011 (2)
- April 2011 (31)
- March 2011 (3)
- January 2011 (1)
- November 2010 (3)
- October 2010 (1)
- September 2010 (1)
- August 2010 (3)
- June 2010 (2)
- May 2010 (4)
- April 2010 (4)
- January 2010 (10)
- December 2009 (3)
- November 2009 (2)
- October 2009 (11)
- September 2009 (7)
- August 2009 (5)
- July 2009 (8)
- June 2009 (4)
- May 2009 (6)
- March 2009 (1)
- September 2008 (1)
- August 2008 (1)
- July 2008 (7)
Category Archives: Experts
MSDB Size growing
msdb is growing due to queue. their is a great blog to help to reduce this How to reduce MSDB size from 42Gb to 200Mb query to get object size: USE msdb GO SELECT TOP(10) o.[object_id] , obj = SCHEMA_NAME(o.[schema_id]) … Continue reading
Posted in Experts, Others, Performance Tuning, Troubleshooting
Tagged Troubleshooting
Leave a comment
Day 1: MySQL History
Swedish Company: MySQL AB by – Michael Widenius (Monty), David Axmark and Allan Larsson Name Combination: Michael’s Daughter name –“My” and SQL Initially – PHP DB Extension to open source – not suitable for DBMS – Developed in(C & C++) … Continue reading
Posted in Experts, Future DBA, History, Imp dates, MySQL, Others, RDBMS, What I learned today, Whitepapers
Tagged MySQL
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
Suspect Database
Suspect database generally caused by internal IO issue, and the best way to resolve it to ask hardware person to check and correct the issue. And sql server dba has to monitor it. Check the database consistence using DBCC CHECKDB … Continue reading
Posted in Backup and Restore, Disaster Recovery, Experts, Troubleshooting
Tagged Disaster Recovery, Errors, Troubleshooting
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 General, Performance Tuning, Tool
Leave a comment
Things to consider…
Hi…. I found some interesting COOL and Caution stuff on sql server, Will try to keep this updated…. Cool Stuff: 1.SSMS: now you can take output copy into excel with heading. SSMS Tips and Tricks http://blogs.msdn.com/billramo/archive/2009/05/15/dat315-session-review-for-ssms-tips-tricks-session.aspx 2.SSMS: Code Collapse and … Continue reading
Experts Links – Very IMP
Sql server Experts: Aaron Alton The HOBT Aaron Bertrand Aaron Bertrand Aaron Lowe SELECT Thoughts FROM dbo.Brain Adam Machanic data manipulation for fun and profit Adam Rink My SQL Server Blog Adrian Downes Establish. Execute. Evolve. Alan Koo Microsoft Business … Continue reading
Posted in Experts
Leave a comment
Ken Henderson Passed away…
Ken Henderson Passed away.. Hey today while surfing shocked i found this news that my feverate author…Guru. of sql server is passed away on jan 27 2008. http://blogs.msdn.com/sqlrem/archive/2008/01/28/ken-henderson-we-will-always-remember-you.aspx
Posted in Experts
Leave a comment
my Favorite Part 1
Hi Friends, Today I would like to share my favorites on Sql server… My Favorite Links A list of the bugs that are fixed in SQL Server 2000 Service Pack 4 After restore Database, transactional replication can’t … Continue reading
Posted in Computers and Internet, Experts, General, Webcast, Whitepapers
Tagged General, Resource, Tool
2 Comments