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.
Who the Devil Wrote This SQL Code?
The way that you format T-SQL code can affect the productivity of the people who have to subsequently maintain your work. It is never a good experience to see SQL Code, cry out “Who the devil wrote this code?”, and then realise that it was you. Grant gives some examples of bad formatting and explains why you should never check-in badly-formatted SQL code.
Hire the Right People
Today Steve Jones discusses the need to hire the people to do the tasks we need done, not the position we filled.
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Alamat kantor BCA KCP Batu Telp:0818751777
WhatsApp:0818-751-777 Jl. Panglima Sudirman No.1, Ngaglik, Kec. Batu, Kota Batu, Jawa Timur 65311 (@bcakcpbatu)
Alamat kantor BCA KCP Joyoboyo Telp:0818751777
WhatsApp:0818-751-777 Jl. Joyoboyo No.34, Kemasan, Kec. Kota, Kota Kediri, Jawa Timur 64125 (@bcakcpjoyoboyo)
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers