Skip to main content
Geoff Griswald's user avatar
Geoff Griswald's user avatar
Geoff Griswald's user avatar
Geoff Griswald
Application Developer
  • Member for 5 years, 3 months
  • Last seen more than 3 years ago
  • UK
Stats
1,073
reputation
1.2m
reached
48
answers
26
questions
Loading…
About

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.

2
gold badges
15
silver badges
29
bronze badges
41
Score
46
Posts
62
Posts %
34
Score
25
Posts
34
Posts %
24
Score
7
Posts
9
Posts %
10
Score
15
Posts
20
Posts %
10
Score
11
Posts
15
Posts %
4
Score
11
Posts
15
Posts %