- 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: April 2011
Download: Powershell a Day -April 2011
Powershell a day – april 2011 blog series, where every day I wrote a blog for complete April month about powershell, you can download the consolidated pdf file which contains all the 30 days blog post. Download : Powershell a … Continue reading
Powershell Day 30
Day 30 Best Practice Having good Security is first best practice for any language no exception with Powershell. Having that we should also we try to follow following best practices. *Best practice is not always best. It may vary depends … Continue reading
Powershell Day 29
Day 29 Advance Security As discussed in earlier blog about “Security” Day 7. Continue on that we will discuss here -what all security features Powershell provides. How to use them. Security is good but securing the things without using is … Continue reading
Powershell Day 28
Day 27 SQL Policy I highly recommand you all to go through the Policy –based management (BCM)’s official site to learn more about PBM http://blogs.msdn.com/b/sqlpbm/ Introduction:- Policy-Based Management (PBM).is introduced from sql server 2008 onwards. Policy means making a … Continue reading
Powershell Day 27
Day 27 Inventory As discussed ealier about wmi, wmi is a good for accessing inventory data from remote system as: To get the Operating related information win32_OperatingSystem :OS info PS C:\> get-wmiobject win32_OperatingSystem –computername “servernm” Or PS C:\> get-wmiobject … Continue reading
Powershell Day 26
Day 26 Generate script Generate script for sql server objects is very simple, there are different ways we can generate the sql server objects includes – database, table, trigger, stored procedure… using SqlPS –MiniShell: We have already discussed about mini … Continue reading
Powershell Day 25
Day 25 RMO I have observed that no body has written anything about RMO. And replications is one of my favoriate topic, so tried to write this blog. Please DO NOT TRY THIS SCRIPT ON PRODUCTION, I AM NOT … Continue reading
Powershell Day 24
Day 24 Performance Monitor Sql Performance: ❑ performance counters sys.dm_os_performance_counters ❑ Top ten queries from sys.dm_exec_query_stats and sys.dm_exec_sql_text ❑ Processor: sys.dm_os_schedulers ❑Memory : sys.dm_os_memory_clerks Performance counters using WMIobject: Formatted Data ❑get-wmiobject Win32_PerfFormattedData_PerfDisk_PhysicalDisk ❑get-wmiobject Win32_PerfFormattedData_PerfOS_Memory ❑get-wmiobject Win32_PerfFormattedData_PerfOS_Processor ❑get-wmiobject Win32_PerfFormattedData_PerfProc_Process ❑get-wmiobject Win32_PerfFormattedData_Tcpip_NetworkInterface … Continue reading
Powershell Day 23
Day 23 SMO programming Part 4 AS we can work with Server, Database, Table, Column. You can get the similar information about Views, Storedprocedures… $database1.Views $database1.Storedprocedures $database1.logfiles $database1.rules $database1.schemas $database1.roles $database1.triggers $tables1.triggers If you observed on this, cmdlets are always … Continue reading
Powershell Day 22
Day 22 SMO programming Part 3 In earlier blog we have discussed about server and database classes, using table clase you can create a table with different options. Table class also require support of other classes like “Datatype” class and … Continue reading