IT & Digital Marketing Articles

Filtering posts by category: Data Solutions

Remove filter

February 20, 2023 Laura Moss 5 minute read

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.

Excel SQL

January 17, 2022 Carlos Chacon 1 minute read

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.

January 22, 2021 Carlos Chacon 1 minute read

Information on Microsoft SQL Server Vulnerability CVE-2021-1636 and how you can keep security up to date.

March 26, 2015 Carlos Chacon 1 minute read

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

December 17, 2014 Carlos Chacon 1 minute read

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...

December 15, 2014 Carlos Chacon 1 minute read

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...

April 29, 2014 Carlos Chacon 1 minute read

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.

Let's find what you're looking for