Latest Blog Posts
More information here at their awesome-looking website: http://acadianasql.org/index.php/events/8-our-first-meeting
We will be discussing a review of SQL…
I will be speaking and whiteboarding for Data Architecture Virtual Chapter meeting on February 27, 2014 on the fitting topic of Application Data Architecture!
This is an informative and thought-provoking Architecture presenting that I have presented multiple times and enjoy sharing. We will cover three large architectures - not specifically…
Streaming video giant Netflix is experimenting with the advanced artificial intelligence method commonly known as deep learning, it explained on its tech blog Monday. The authors didn’t get into how it might use the technology (other than “to improve our product”) but the chances are it’s eyeing deep learning as… Read more
One of the key tasks of a DBA is to maintain the database indexes and make sure they are not fragmented. You can use a sys.dm_db_index_physical_stats in a script to rebuild or reorganize indexes based on fragmentation. However, sometimes we may need to rebuild all indexes on all tables in… Read more
This week the AzureCAT team is excited to make our first team appearance at the Strata conference. For those of you unfamiliar with the AzureCAT team, we are an international group of about 70 Azure and data geeks nestled in the heart of the Cloud and Enterprise division at Microsoft.… Read more
Today, one of the developers come to me and asked me the question that is there any T-SQL function that he could use to remove everything before and after a specific character in string. For example, if the table contains the full names of the people in the format… Read more
There are two major reasons baseball has been such a boon to statisticians trying to measure human performance. First, sample size: the United States alone fields 30 major league teams — each with a 40-man roster — that play 162 regular-season games. Every game comprises hundreds of plays. Second, because… Read more
A Strategic alliance between the biggest Linux vendor and the leader in fully opensource hadoop is a killer combo. Read more about it and how it will impact your business here!
from Planet big data http://ift.tt/1lWC91x
The first step in treating rust is keeping it from forming, which means keeping your truck’s metal painted, plated, or otherwise protected so oxidation can’t get a foothold. If it’s already too late and you see those tell-tale bubbles under the paint or surface rust spreading across a panel or… Read more
Well, Kem’s cruiser was actually just a bit faded but pretty much in great shape. He had hired someone else to do some work on the truck and they had it for five years!!!. Damn, I thought I was slow. We took some starter photos and then got started on… Read more
Here is a cool looking 1964 FJ40 Toyota Land Cruiser in good original condition…a road warrior that has a great vibe to it….perfect for a semi or full restoration…this rig is currently available on eBay
What is (SSAS) SQL Server Analysis Services Tabular Mode?
SQL Server 2012 ships Analysis Services that can be installed in the traditional OLAP engine or in the Tabular engine mode. Tabular mode is an in-memory database that compresses and queries the data with great performance. In most cases, you may… Read more
The Toyota FJ40 Land Cruiser has been out of production for 26 years, but you wouldn’t know it when talking with the “FJ40 Faithful.” They’re as devoted to their vehicles now as they were when the last one rolled off the assembly line in 1983. Maybe even more so, now… Read more
On February 17, 2014, Microsoft released SQL Server 2008 R2 SP2 CU11, which is Build 10.50.4302. This cumulative update has twelve hotfixes in the public fix list.
If you are running SQL Server 2008 R2, the only supported Service Pack level is SP2. Both SP1 and RTM have been… Read more
Sometimes old stuff is just as cool as new stuff. Over the past few years, I’ve written a few things that are worth a revisit from time to time. In this post, you’ll find a list of previous year’s blog posts that came… Read more