[29 Apr 2013 | One Comment | ]
SQL Performance Issues: Query Compilation

Learn how to improve the performance of your SQL Server database and understand when the recompilation of queries is necessary and when it is not. Understanding query compilation issues from an operational perspective requires intimate familiarity with two indispensable tools: Performance Monitor and SQL Profiler.

Read the full story »

Categories

Recent Content

 

[18 Jun 2013 | No Comment | ]

Writing queries with date and time data types can be tricky! Learn tips and best practices for selecting the right data types, choosing the best performing functions to round (or truncate) values, and how to avoid common pitfalls with dates and times in SQL Server.

[17 Jun 2013 | No Comment | ]

This video explains how to install SQLite3 on both Mac and Windows. It also covers how to use SQLite3 using the console. SQLite is an open source software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

[17 Jun 2013 | No Comment | ]

This lecture provides an overview of what databases are and how they are used. It is concept based and just covers beginning database concepts. It is not a technical lecture and does not cover much outside of basic introduction to the database concept using Oracle as an example.

[13 Jun 2013 | No Comment | ]

This short tutorial explains how to replace your MySQL database with a MariaDB database.

[11 Jun 2013 | No Comment | ]

Rich Hickey is the creator of the Clojure programming language. He discusses new approach to database design and general purpose programmability. He presents Datomic, a database of flexible, time-based facts, supporting queries and joins, with elastic scalability, and ACID transactions. It is implemented in Clojure.

[10 Jun 2013 | No Comment | ]

This webinar highlights DataStax’s newest big data platform, DataStax Enterprise (DSE) 3.0. This video explains the importance of security and visual management tools when selecting a big data stack, and discuss how DSE 3.0 addresses these two key criteria.

[6 Jun 2013 | No Comment | ]

Learn the differences and similarities among Oracle’s MySQL, MariaDB, Drizzle and the Percona patchset. You will learn the coding philosophies of the organizations behind the MSQL forks and how they interact with the community, so you can choose which fork is right for you.

[4 Jun 2013 | No Comment | ]

Ever wonder what role Redis fills? Is it a caching engine like memcached or a database like Mongo? Brett Hoerner gives an introduction to Redis and provides us with the Do’s and Don’ts of Redis based on his experience working with it in production at Disqus and Mass Relevance.

[3 Jun 2013 | No Comment | ]

The past few years have been exciting ones for the database and distributed systems communities. This video explains what all of this NoSQL stuff is really about and then introduces Riak. Riak is a scalable, available open source database. Learn about what makes Riak special, when and why to choose it and how it has worked in a few concrete production use cases.

[30 May 2013 | No Comment | ]

stORM is a simple open source template-based Object Relational Mapping tool for Android SQLite. is This new offering aims for a streamlined developer experience (only two annotations required) and solid performance (preferring code generation over reflection). stORM is extensible, minimally intrusive, and offers built-in CSV backup / restore capabilities to facilitate database version upgrades.