Retrieve Default SQL Server Backup Folder using PowerShell
As I’ve been translating a lot of my TSQL script to Windows PowerShell with SMO, here’s another articleI wrote on how to check for the default SQL Server backup folder
Who Have You Blessed Recently? Changing The World One Act of Kindness At A Time
I’m a big fan of communities, particularly technical communities, because I have benefitted a lot from them when I was starting out in the IT industry. I remember the time I used to spend on BBS and IRC channels when I was “forced” to learn computer programming. If not for the generosity and kindness of […]
Understanding ASP.NET session state management from a DBA’s perspective
While I no longer do .NET development nowadays, I find it hard not to use my previous background as a reference when talking about databases. One specific discussion that came up today was how ASP.NET manages session state. In order to configure an ASP.NET application to do session state management, you need to configure the […]
Slipstream Office SharePoint Server 2007 Service Packs for Windows Server 2008 R2
This article took quite a while in the making. I’ve been seeing a lot of IT Pros deploy SharePoint in their infrastructure particularly on a Windows Server 2008 platform. However, SharePoint with Service Pack 1 is not supported on a Windows Server 2008 R2 platform. This article outlines the steps in slipstreaming service packs for […]
Connecting to SQL Server via Windows PowerShell with SQL Server authentication
Most of the articles I’ve written about SQL Server with Windows PowerShell have been using Windows Authentication. And while it is highly recommended to use Windows authentication to connect to SQL Server, the reality is that the IT infrastructures we have don’t run on Microsoft Windows. Here’s an article I wrote on how to use […]