For this post I will show you how to bulk insert multiple files in a folder to a SQL Server database, regardless the file name or extension, this with the help of the ForEach Loop Container.
2018-10-09
15,034 reads
PowerBI is a powerful reporting solution for Business Intelligence for analytical reports, it is not meant to replace SSRS, the focus of this tool is to be able to...
2018-10-03
3 reads
On a previous post, we discussed what is an extended event (XE) and how to create one.
With the following T-SQL...
2018-10-03
224 reads
On a previous post, we discussed what is an extended event (XE) and how to create one.With the following T-SQL you can quickly check what are the currently running...
2018-10-03
8 reads
This post is part of #tsql2sday event :)I know, in the world of the database administrators and developers, the triggers...
2018-09-11
531 reads
This post is part of #tsql2sday event 🙂
I know, in the world of the database administrators and developers, the triggers are the ugly duck of the database development.They are...
2018-09-11
1 reads
One of the things I enjoy about my job is when I have to develop or review some T-SQL code,...
2018-09-10
728 reads
One of the things I enjoy about my job is when I have to develop or review some T-SQL code, for my own projects or reviewing someones else code....
2018-09-10
4 reads
JSON (JavaScript Object Notation) is a file format used to transmit data from various applications, very similar to XML, it...
2018-09-06 (first published: 2018-08-22)
3,695 reads
JSON (JavaScript Object Notation) is a file format used to transmit data from various applications, very similar to XML, it also used to stored NoSQL unstructured data, and because...
2018-08-22
1 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers