IT & Digital Marketing Articles
Importing data from Excel into SQL Server without a bulk import option can be a challenge. Here's how data expert Laura Moss solved this by using Excel to generate T-SQL.
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.