233
reputation
1
5

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.

12
answers
1
question
~45k
people reached
  • UK
  • Member for 1 year, 8 months
  • 22 profile views
  • Last seen Jun 2 at 14:56

Top tags (27)

Score 3
Posts 9
Posts % 69
Score 3
Posts 1
Score 3
Posts 1
Score 3
Posts 1
Score -1
Posts 2
Score -1
Posts 2

Top posts (13)

View all questions and answers

Badges (6)

Gold

Silver

1

Rarest

Bronze

5

Rarest