Collection of SQL utility demonstration scripts. Contribute to OpenLinkSoftware/SQL-Scripts development by creating an account on GitHub.

#KML file generator from SQL Server A simple project for generating a kml file from a sqlserver table. Just change the connection string, look at the query (should be modified to match your own table ...

Now that you’ve automated the fetching of your flat file via FTP, the next step is to automatically import that file into SQL Server. To do this, we’ll use an SQL Server Agent Job.

Just a small tip that I use often when I have a large SQL Profiler trace. Rather than reading through trace files line by line, you can read it into a table and then query it. This syntax creates a ...