PowerShell: Get Security Updates List From Microsoft By Month/Product/KB/CVE With API

I am a regular at my local PowerShell user group. I keenly look forward to our monthly meetings. We share a lot amongst ourselves. It is a small but close-knit group. Recently, one of the members, Julie came up with a coding challenge for the group. This blog post is about the challenge. My solution … Continue reading PowerShell: Get Security Updates List From Microsoft By Month/Product/KB/CVE With API

Advertisements

SQL Server: Identify And Defragment Indexes Using DBCC SHOWCONTIG & DBCC INDEXDEFRAG

Update SepĀ 7, 2018: This article uses deprecated commands. Please checkout this blog post on "Alter Index Vs DBCC IndexDefrag Vs DBCC DBReIndex". In the newer versions, I prefer ALTER INDEX although it has not been good at defragmenting in all cases. A good defrag script is worth its weight in gold. This time, I copied … Continue reading SQL Server: Identify And Defragment Indexes Using DBCC SHOWCONTIG & DBCC INDEXDEFRAG

SQL Server – Breakup A Monolithic Data File (Database) Into Multiple Small Files And Breakaway From Shrinking!

If the SQL Server databases being manged are a few GB in size each, then having a single .mdf file for data is fine. However, if the size is anywhere in the hundreds of GB or more, then a single .mdf file is certainly not the way to go. Related to this, please checkout my … Continue reading SQL Server – Breakup A Monolithic Data File (Database) Into Multiple Small Files And Breakaway From Shrinking!