Hadoop For SQL Folks: Architecture, MapReduce and Powering IoT
As the de-facto big data processing and analytics engine, the Hadoop ecosystem is also leading the way in powering Internet of Things (IOT)
4 Keys to a Clean Angular Implementation
Can there be true separation of concerns with MVC? Not entirely, especially when Angular's templates allow you to so much flexibility; but there is a great deal to be gained from following guidelines to ensure that all business logic is performed in the code-behind as directed by the controller or its delegate, and that all operations on the model are done in the controller: Michael Sorens explains the four essential guidelines for an easily-maintained system.
How to download a file from internet using SSIS
In this example, we will show how to download a file from internet using SSIS.
Learn to Earn
Learning more about your craft can translate into more earnings, but it won't be easy.
Script to find oldest open SQL Server transaction
In this post, Eli Leiba shares a script that can be used to find the oldest open transaction and the statement that was issued.
SQL Server 2016: The New @OneResultSet Parameter in SP_SpaceUsed
EXEC SP_SPACEUSED can return only one result set if you want it to. This is possible using a new parameter in SQL Server 2016. If are familiar with the inbuilt stored procedure sp_spaceused, I am sure you will find this new parameter quite useful.
The Pressure to Compromise Ethics
There are always people that ask workers to deceive, defraud, or mislead customers. This is true for software developers as well.
How to Get the Output of a Stored Procedure into a Table
Putting the output of a stored procedure into a table provides you multiple options for parsing and using the output with other TSQL commands. Read on to learn more.
EzAdo Part 4
EzAdo is a very simple api built to exploit some new features of SQL 2016. It combines software, convention, and creativity to get more done in less time.
Finally, Create or Alter
Today Steve Jones looks at the CREATE OR ALTER syntax, added in SQL Server 2016 SP1.
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
BCA KCU TARAKAN Tlp/Wa_Cs:0817-866-887
Jl. Yos Sudarso Pantai No.08, Karang Rejo, Kec. Tarakan Bar., Kota Tarakan, Kalimantan Utara...
Alamat kontak resmi BCA KCP Fatmawati Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Komp. Rs. Fatmawati No.1, RT.1/RW.9, Cilandak Bar., Kec. Cilandak, Kota Jakarta Selatan,...
Alamat kontak resmi BCA KCU SUNTER Telp:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Danau Sunter Utara Jalan Kavling No.3 Blok A, RT.2/RW.18, Sunter Agung, Kec....
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers