Web Development Business

Quick Introduction To SQL Server Profiler

Brian Clay .NET, Databases, Technology Snapshot, Tutorial Leave a Comment

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…

Web Development Business

Creating a SQL Database Project for Isolated Development

Rusty Divine .NET, Databases, Problem Solving, Technology Snapshot, Tutorial Leave a Comment

In this article you see how to create a database project that will let you quickly and consistently deploy a database to your local environment. This approach can help to solve some issues from team members interfering with each other’s work on a shared development database.

Then, in an upcoming article, we will show you how to take the next step to include this database project in your continuous integration process and deploy it to each environment up the chain to production so that you can eliminate the need for any direct interaction with database updates.

data sanitization

Sanitize: Good for Beer, Good for Data

Jeremy Gard Databases, Design, JavaScript, Programming Leave a Comment

When it comes to brewing, one of the most critical considerations is sanitization. The same fact can be said for development. In brewing you can introduce unintended flavors, create a lesser end product, or completely ruin your hard work. With development, you can introduce inaccuracies or bad data, errors can be caused or exposed to attack, and security holes can be created.

With best practices in sanitization, we can all enjoy better applications and better beer. In this blog, I discuss the importance of data sanitization in development (with tips for success), with parallels to sanitization in brewing.

Web Development Business

SQL for Application Developers

Mark Adelsberger Databases, Programming, Technology Snapshot Leave a Comment

“SQL? Isn’t that just something my ORM tools use?” Often application developers can and should remain at least one level removed from SQL. JPA and the Entity Framework each provide more abstract (and OO-friendly) query languages, and it’s often unnecessary to write any queries at all. If you ever diagnose production support issues, though, being proficient with SQL can greatly …

Rethinkdb

Real-Time Applications With RethinkDB

John Hoestje Databases, JavaScript, Microservices, Node, Technology Snapshot 1 Comment

In the last several years, there have been new requirements and expectations placed on enterprise applications that have dramatically increased application code complexity. Users want dynamic websites that provide instant data feedback or to have multiple users work on the same document concurrently. New frameworks and ideas have also evolved along with the requirements to help cope with the new …