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
Blog Posts
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,269 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 wrapped frog legs? Oh yeah, more Virtual lab...
2012-12-25
5 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,141 reads
A Trip Down the Rickety Stairway…
I’ve had to delay my series of self-tutorials on data mining for a few weeks following an antibiotic resistant infection...
2012-12-24
765 reads
Big Data And Hadoop Part 2
In my previous blog I have given more insight on Big Data and now we will take a closer look at...
2012-12-24
446 reads
Big Data And Hadoop Part 2
In my previous blog I have given more insight on Big Data and now we will take a closer look at Hadoop.
Hadoop
Hadoop is a software framework that supports data-intensive...
2012-12-24
40 reads
Merry Christmas from gethynellis.com
This is a very short post on Christmas Eve to wish all my readers a very Merry Christmas!
I’m going to...
2012-12-24
796 reads
Blogs
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers