In this blog post, I will demonstrate a technique to query the status of a SQL Server Agent job that executes the SSIS package. SQL Server Agent scripts are asynchronous in nature. This can make it difficult to make code decisions based on the execution status of a script of this type.
This is just a short article (more of a blog-ette than a full blog) about some things we as developers need to consider when sending queries to Microsoft’s SQL Server. While some of this information may also be true for other flavors of database servers, these things are known to be true for SQL Server.
When working with SQL Server, you might run across a situation where it is just not running fast enough. While there could be many reasons for this, there are tools that can help you track down just what is going on behind the scenes. SQL Server Management Studio’s SQL Server Profiler or just (Profiler) is a tool that can be used to monitor queries run on your database.
In this blog post I’ll give a brief demonstration of the SQL Server Profiler tool. I’ll show you how to keep an eye on all the queries that are being run against your database, as well as how to use a filter to narrow your search to just slower-running queries…
Attention: This article was published over 9 years ago, and the information provided may be aged or outdated. While some topics are evergreen, technology moves fast, so please keep that in mind as you read the post.We are pleased to announce that Keyhole Software is a sponsor of the 2016 SQL Saturday Kansas City. SQL Saturday is a one-day, free training opportunity …
Attention: This article was published over 10 years ago, and the information provided may be aged or outdated. While some topics are evergreen, technology moves fast, so please keep that in mind as you read the post.An example Node.js application which connects to a SQL server and serves up data via HTTP endpoints. Before leaving my last client, I was …
