IT & Digital Marketing Articles
With more than 10 years of working with SQL Server, Carlos helps businesses ensure their SQL Server environments meet their users’ expectations. He can provide insights on performance, migrations, and disaster recovery. He is also active in the SQL Server community and regularly speaks at user group meetings and conferences. He helps support the free database monitoring tool found at databasehealth.com and provides training through SQL Trail events.
When you need the date of export in the name of a newly created Excel file for validation or version tracking, dynamically append a date with this expression.
Information on Microsoft SQL Server Vulnerability CVE-2021-1636 and how you can keep security up to date.
Installing SQL Server with PowerShell makes life easier. Here's a handy reference of component abbreviations you can use when setting up your SQL Server
In many instances there is a development team or even a warehouse team that needs to run SSIS packages and you want to store those packages in SQL Server and run them through the SQL Agent Service. You may not; however, want to grant those...
I was setting up an availability group in SQL Server 2012 on a pair of servers and came across the following error. “the local node is not able to communicate with the wsfc cluster” Interestingly enough, I had already installed an availability...
The patch restarted the sql server service rendering the drive from which the service pack was trying to install unavailable. I copied the temp folder to the local c: drive and I was able to install with no problems.
The other day I was working in SSMS and connected to an instance. Pretty normal there. I later opened some window (I don’t recall exactly–perhaps a report or some db option) and was met with this error message. I could then do nothing in the...