I know I have been fortunate to write back-to-back on topics around SQL Server. I get a number of you do take time in writing down to me over emails, comments and even sometimes over Skype pings. I see every such mail as an opportunity to learn something from you for sure. One of my friends from the networking team pinged me to check if I knew a query about the last bootup time he had:
SQL SERVER – Script: Change Service Account Using WMI / SMO
Last week I wrote a post where my friend faced problem because he changed the service account of SQL Server from services. mass rather than SQL Server Configuration Manager. Let us learn how to change service account using WMI/SMO.
SQL SERVER – Starting / Stopping SQL Server Agent Services using PowerShell
Writing utility scripts are one way to become smarter when working with computers. From time to time I get asked about some tasks folks use repetitively and are being counterproductive. On this note, I wanted to paint a scenario which I saw one of the DBA’s doing on their environment…
Read More
SQL SERVER – Working with Event Viewer and PowerShell
Sometimes I go into these simple explorations that make me learn something new that gets me off the routine. SQL Server is always on the agenda and that passion will never die. This exploration was based on the fact when I was talking to someone about some of the super…
Read MoreSQL SERVER – PowerShell – Knowing SQL Server Information
If you search this blog, there are a number of PowerShell scripts that I have shared in the recent past. Some of them include: Using PowerShell and Native Client to run queries in SQL Server Identify Disk Latency on SQL Server Box Using PowerShell How to Find Logical and Physical…
Read MorePowerShell: How to Find Logical and Physical Processors on SQL Server?
Working on PowerShell scripts have been an interesting journey. I have written a couple of posts before on using WMI events. Was pondering on this thought and this blog is inspired by combining using of WMI with PowerShell. So what are we trying to solve? When SQL Server changed its…
Read More
SQL SERVER – PowerShell to Count Number of VLFs in SQL Server
If you are a seasoned DBA, then the conversations and monitoring VLFs is something you are already doing. To learn about the basics of VLF, check my earlier blog at: SQL SERVER – Detect Virtual Log Files (VLF) in LDF. Having a large number of VLFs has a performance impact and there are a number of blogs that discuss the same. As a DBA in this blog I thought of showing a simple script that will help identifying the number of VLFs available inside a SQL Server instance or a number of instances.