Importing Excel Spreadsheets is something that we often do with SQL Server. However it's not as easy as you would like as we move to the 64 bit platform. Peter He brings us a method that will work on all platforms.
2010-02-17
20,591 reads
Importing data into SQL Server is one of the strengths of the platform. However it can require a bit of work for a DBA to make this an automated process. New author David Jansen brings us a technique for importing Sharepoint and IIS logs into SQL Server for later analysis.
2009-12-24
3,934 reads
A useful SQL function to parse a single string with delimited values for the "N"th occurrence
2009-11-06 (first published: 2009-10-15)
1,443 reads
2009-11-03 (first published: 2009-10-06)
1,947 reads
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
I don't see a PowerBI forum, so I'm posting here. I have a need...
Comments posted to this topic are about the item SQL Server Certificates
Comments posted to this topic are about the item Connect an Azure Function to...
Which of these is not true for certificates used for SQL Server connections?
See possible answers