Force installation of 64-bit ACE OLE DB provider
Anyone working with SSIS and Excel probably had the following issue: you are creating an SSIS package using an Excel...
2013-04-25 (first published: 2013-04-23)
12,716 reads
Anyone working with SSIS and Excel probably had the following issue: you are creating an SSIS package using an Excel...
2013-04-25 (first published: 2013-04-23)
12,716 reads
Last week I took the final exam to acquire the MCSE – Business Intelligence certification. This blog post describes my preparation...
2013-04-04
18,452 reads
Some time ago Data Explorer, an add-in for Excel 2010 or 2013, was released in Public Preview. In short, it...
2013-03-20
829 reads
When it comes to importing data from an Excel sheet with SSIS, Excel has quite a reputation. And not a...
2012-11-27
1,607 reads
By Zikato
In SQL Server, using the KILL command to terminate a session results in an...
In today’s data-driven world, having the right tools to manage and process large datasets...
By Steve Jones
flichtish – adj. nervously aware how much of your self-image is based on untested...
I took a backup with the CHECKSUM option, which was successful and showed no...
Comments posted to this topic are about the item Realities of Predictive Analysis
Just came across something weird. Was wondering if anyone else has ever seen this....
I have a table in SQL Server 2022 that is an XML data type. I have an index on this column and want to create statistics using CREATE STATISTICS for some of the data in the column. What should I do?
See possible answers