2011-03-29
3,107 reads
2011-03-29
3,107 reads
2011-03-28
3,430 reads
For enterprise systems, purging data is a reality. Today, we will see some strategies that I recently implemented to make this process work efficiently.
2013-03-08 (first published: 2011-03-24)
23,814 reads
2011-03-22
3,551 reads
Dynamic SQL allows stored procedures to “write” or dynamically generate their SQL statements. The most common use case for dynamic SQL is stored procedures with optional parameters in the WHERE clause. These are typically called from reports or screens that have multiple, optional search criteria. This article describes how to write these types of stored procedures so they execute well and resist SQL injection attacks.
2011-03-22
7,301 reads
2011-03-21
3,045 reads
2011-03-18
3,039 reads
2011-03-16
3,154 reads
SQLs CASE expressions can be powerful magic, but can trap the unwary that are used to the more familiar CASE statements of procedural languages.
2011-03-14
6,011 reads
2011-03-11
2,643 reads
The post Analytics vs. Advanced Analytics appeared first on Joyful Craftsmen.
By Brian Kelley
Recently, on a post celebrating a female professional earning a significant achievement within the...
By Rob Sewell
Four of our favorite new themes.
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers