- 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)
Monthly Archives: November 2019
Cursor Dynamic SQL
Today was working on SQL Server cursor standard cursor deification would be like this: sqlcursor from (Azure Data Studio) ———————————————————————————————————————– — Declare a cursor for a Table or a View ‘TableOrViewName’ in schema ‘dbo’ DECLARE @ColumnName1 NVARCHAR(50), @ColumnName2 NVARCHAR(50) DECLARE db_cursor CURSOR FOR SELECT name FROM dbo.TableOrViewName OPEN db_cursor FETCH NEXT FROM db_cursor INTO @ColumnName1, @ColumnName2 WHILE @@FETCH_STATUS = 0 BEGIN — add instructions to be executed for every rows SELECT @db_nm FETCH NEXT FROM db_cursor INTO Sys.Databases END CLOSE db_cursor DEALLOCATE db_cursor GO … Continue reading
Transaction log Information gathering
Here are the different ways to know the tlog file related information sys.dm_db_log_stats – Provide summary of tlog information SELECT * FROM sys.dm_db_log_stats(db_id()) sys.dm_db_log_info -DMV function for VLF information same as dbcc loginfo which is non documented by Microsoft. SELECT … Continue reading
Azure Data Studeo- Nov 2019 Release
SQL Server Management studio is now can be installed separately not part of SQL Server package. with this enhancement SSMS has several features and version is getting updated and new versions getting release which we can install separately. in addition … Continue reading
Posted in Azure, Future DBA, Others, SQL Server 2017, Tool
Tagged Azure, Future DBA, SQL Server 2017, Tool
Leave a comment
AG without WSFC SQL 2017 and more…
Starting Sql Server 2017 Microsoft can allow you to enable the configuration manager for “Always ON” feature for standalone system without WSFC and linux without Pacemaker . it has a limitation as : It cannot have listener configuration This would … Continue reading
MAXDOP and Tempdb – SQL 2016
Starting SQL Server 2016 Max Degree of Parallellism (Max DOP) Macrosoft has made hanges on this and now we can set it at database level. This helps for replication and AlwaysOn for better performance. ALTER DATABASE SCOPED CONFIGURATION SET MAXDOP … Continue reading
Posted in Others, Performance Tuning, sql 2016, What I learned today, Whats New
Tagged Performance Tuning, sql server 2016, Whats New
Leave a comment
SQL Server 2019 GA
Yes, Finally SQL Server 2019 is Generally Available yesterday Nov 4th 2019. It has many great features great videos: https://channel9.msdn.com/Niners/dutchdatadude https://cloudblogs.microsoft.com/sqlserver/2019/11/04/gain-intelligence-over-data-with-sql-server-2019-now-generally-available/ https://cloudblogs.microsoft.com/sqlserver/2019/11/04/sql-server-2019-is-now-generally-available/
Posted in Others, SQL Server 2019, Webcast, What I learned today, Whats New
Tagged General, News, SQL Server 2019, Webcast, Whats New
Leave a comment
Smart Tlog Bkp
another great new feature for SQL Server 2017 is a smart backup with dmv sys.dm_db_log_space_usage this DMV provide log usage information using this we can plan to initiate the tlog backup and ensure to have tlog backup consistency and same … Continue reading
Resumable online index rebuild
continue on whats new SQL Server 2017 their is a great feature call resumable online index, means online index now has an option to PAUSE and RESUME or ABORT RESUMABLE = {ON | OF } MAX_DURATION — can specify the … Continue reading
Posted in Others, Performance Tuning, SQL Server 2017, Whats New
Tagged Performance Tuning, SQL Server 2017, Whats New
Leave a comment
Back to school
Hey, I realize that future we need to know Database system, No SQL and Big Data. with that as things are moving to machine learning and AI system which requires you to have your hands dirty on some programming language, … Continue reading
Posted in AI, Python
Leave a comment