Latest Blog Posts
And now for something not so different with week 6 of the Expert Performance Indexing for SQL Server book giveaway. So far, I’ve sent out five copies of the book based on comments from these (1, 2, 3, 4, and 5) posts.
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
Fair warning, this is a discussion piece. I had a task, I went through several possibilities and I’m going to share each of them and the results of those I tried. I will not be giving any specific examples or code. Feel free to give me your opinion in the… Read more
Question from someone in one my recent classes: “What tool do you use to send email from ETL processes?” My response: “I don’t.” The tl;dr version of this post is I let my extract-transform-load processes do just ETL, and leave notifications to the scheduling system where they belong. Get Your… Read more
The monthly Data Professionals blog party has come and gone. It happens the second Tuesday of every month – or at least is supposed to happen on that day. This month, the formidable Chris Yates (blog | twitter) has invited everybody to a birthday party Read more
This is the 2nd post in the series named SQL Server and Continuous Integration. The previous post explained the problems I encountered at work and how they provided the inspiration for using source control in my SQL Server projects. This post will focus on using the version control system… Read more
Next Tuesday is the next installment of our DLM series from Redgate. I’m off the hook, with Grant and Arneh showing off Git, Team City, and Octopus Deploy as the main tools. Register today and see how you can get started.
We’ve been running this series for a year, with… Read more
In brief, SQL DW is a fully managed data-warehouse-as-a-service that you can provision in minutes and scale up in seconds. With SQL DW, storage and compute scale… Read more
I heard the news this week, and I’m still sad. Karla Landrum is leaving PASS after five years of acting as the Community Evangelist.
Thank you, Karla, for all you’ve done.
In the last five years, we’ve seen tremendous growth in the SQL Saturday franchise, as well as other chapters.… Read more
0 comments, 229 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 12 July 2016
In this module you will learn how to use the Enhanced Scatter Power BI Custom Visual. This new-and-improved scatter chart allows for more customization and better data representation over the standard scatter chart that is provided to you by default with Power BI.
Module 07 – Enhanced Scatter
This month’s T-SQL Tuesday (#080) is being hosted by Chris Yates (B|T) (Happy B-day Chris!). He decided that this month’s theme was to be a gift to the community of something you had to offer that someone else may find as a gift. Or maybe it isn’t. That’s my interpretation.…
It’s Chris Yates (b/t) birthday! (I think he just tured 19.) And in honor of his birthday we are writing blog posts! Well, technically it’s T-SQL Tuesday again, but we can pretend we are writing for Chris’ birthday. In fact that’s the subject he’s selected. “Give… Read more
This month’s invitation is from Chris Yates, with today being… Read more
Here's a list of resources I'd recommend, in no particular order.
EDIT: I presented this content,…
The staple of every SQL Server developer's world, SSMS has been impossible to usurp for the majority of us. However, it's also been behind the development cycle of visual studio, and didn't have continual updates. That changed recently, as I've previously posted on. SSMS (Sql Server Management Studio) now being… Read more