Latest Blog Posts
- Speaker dinner at Spaghetti Warehouse was packed. Great crowd, not such great service. At 8:45 pm we still had not had a chance to order dinner. With a crowd of 40+ its challenging to get a good venue that can handle the service and provide an environment conducive to networking.…
This post is to Export SQL Data to Excel with Powershell.In this example, a connection is made to a SQL server Instance using DSN and then SQL output…
The “Perfectly Optimized” Page infographic states that there is no such thing as a “Perfect Page”. But don’t be discouraged! Moz.com presents 3 key points to be followed to increase user happiness and outreach.
One important takeaway from this post should be that modern on-page SEO is about juggling competing… Read more
A few years back, I put together a blog series on SQL Server Integration Services (SSIS) titled 31 Days of SSIS. This series focused on a number of lessons learned that I’d gone through with while working with SSIS. That version focused on using SSIS with SQL Server 2008… Read more
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (
so exciting), follow me on twitter (@StrateSQL). And see these throughout the day as I tweet out links of things I find interesting. While these links aren’t the answer… Read more
Accenture and DataStax have signed an alliance agreement, formalizing their longstanding collaboration in helping clients manage and drive insights from big data seamlessly and rapidly across the enterprise. The two companies will continue to work closely providing clients with real-time, open source-based big data capabilities that enable businesses to detect… Read more
I recently saw an answer to this question on dba.stackexchange.com written by Martin Smith. It was probably one of the most complete answers to this question I have ever seen. In fact it’s probably one of the most complete answers possible. I highly recommend that you read it. In… Read more
We’ve probably all heard the famous quote by John Wanamaker, the father of modern advertising: “Half the money I spend on advertising is wasted; the trouble is, I don’t know which half.”
Wanamaker would love Apache Hadoop for retail applications, because it diminishes (or eliminates) the dilemma he described.
When… Read more
Over the last year, I was presenting and touring the SQL Saturday circuit with my HealthySQL 2.0 presentation. HealthySQL is my campaign to raise awareness in the greater SQL Server Community for the need for regular performance and security health checks, and to maintain a healthy SQL… Read more
Because of some Enterprise edition-specific feature usage, this turned out to have two…
I was working with a client recently getting the number of standard deviations a student was off the average number of suspensions. I accomplished this with two Common Table Expressions, (CTE).
The first CTE gets the standard deviation and the average for the entire database. The Database holds all of…
Two recent salary surveys have shown that R language skills attract median salaries in excess of $110,000 in the United States.
In the 2014 Dice Tech Salary Survey of over 17,000 technology professionals, the highest-paid IT skill was R programming. While big-data skills in general featured strongly in the top… Read more
As you have likely noticed in my series, Oracle Tips for MSBI Devs, I have done a lot of work with Oracle through the years while delivering BI solutions. One of the pain points of working with Oracle in development is setting up an Oracle development server. Even though… Read more
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