Big Data: An Introduction with Hive
Hive is a data warehouse system for Hadoop that facilitates easy data summarization, ad-hoc queries, and the analysis of large...
2012-12-26
420 reads
Blog Posts
FOR XML Clause
FOR XML CLAUSE: Sometimes we need to data in form of XML from
Database.SQL Server provide FOR XML Clause. For XML clause...
2012-12-26
773 reads
NULL Values Impact the Performance of MAX() and MIN()
We know that we need to take special attention about NULL values while writing queries because they may lead us into...
2012-12-26
2,327 reads
Querying the Procedural Cache: Just in Time for the New Years’
I sincerely wish that everyone enjoyed their recent holidays and recent downtime with family, and pass on my hope for...
2012-12-26
1,500 reads
SSIS Precedence Constraint Tutorial
Recently we decided to create a series of videos for our SSIS Precedence Constraint Tutorial which is part of our...
2012-12-26 (first published: 2012-12-18)
9,164 reads
Big Data - An Introduction to Pig
In my previous article, I have explained Big Data and Hadoop in details. In this article I would like to...
2012-12-25
455 reads
Index Analysis: The Re-Return
A couple years back, I wrote a few blog posts about an indexing script that I use with clients from...
2012-12-25 (first published: 2012-12-18)
3,255 reads
Last Weeks Top 10 “Reading” Links #12
Happy holidays, seems this post missed coming out this morning as typically scheduled. Thus, a late afternoon post on this...
2012-12-25
723 reads
2012-12-25
912 reads
On the Twelfth Day…
Bacon wrapped frog legs (twelve of them) for Christmas. No more drumming for these guys!!
What could be better than bacon...
2012-12-25
1,139 reads
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers