284
reputation
1
6

Geoff Griswald
Loading…

I use Microsoft SQL Server in the "Wrong" way, I get it to do things that it isn't "Supposed" to do, and solve problems that aren't supposed to be solved with it. Many closed-minded IT people can't get on board with this as it shakes their worldview of things being done "Correctly".

Most people don't realise that a SQL Server box and some basic internet infrastructure is pretty much all you need to run your entire business. You don't need a Linux machine, you don't need a Message Queue, you don't need any "Services" and you certainly don't need "Docker".

SQL Server can send automated emails, perform the task of a scripting and automation engine, run test scripts, host all of the data for your applications, Query data from external APIs, send commands to external APIs, run a report server, perform file transfers, run Python scripts, run Powershell scripts and so much more.

I despise SSIS and never use it. I try to solve any problem with a combination of SQL Server Stored Procedures and SQL Agent Jobs. I believe that there is no automated task that you could possibly want to achieve that cannot be done with SQL Server in this way.

3
answers
0
questions
~11k
people reached
  • UK
  • Member for 2 years
  • 4 profile views
  • Last seen May 13 at 15:22

Top tags (9)

Score 11
Posts 1
Posts % 33
Score 11
Posts 1
Score 11
Posts 1
Score 11
Posts 1
Score 4
Posts 1
Score 4
Posts 1

Top posts (3)

Badges (7)

Gold

Silver

1

Rarest

Bronze

6

Rarest