Latest Blog Posts
Just in time for Christmas the Microsoft product teams responsible for Power BI have a slew of amazing updates. The list of updates can be found here but for my notes specifically on Power Query updates continue reading!
Power Query now has 3 new data sources that you… Read more
Congratulations for winning a free month of PluralSight. I'm E-Mailing you the code right now.
We still have two free months to give away and a great book on the 30th!
There are multiple user groups around the country online and offline. I'm…
Today I ran through the first tutorial at Code.org. It has 20 very short lessons that use Angry Birds and zombies to teach the very basics of programming – instructions, loops, and conditionals. It was very well done, a nice UI supplemented with some short and interesting videos as you… Read more
0 comments, 51 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 10 December 2013
Info from Microsoft on how the MCSA and MCSE certifications will be altered for SQL Server 2014:
In reviewing the SQL Server 2014 product, the Microsoft Learning Experiences team determined that the new features focus on performance tuning and high availability. As skilling and testing around these features is best… Read more
It’s T-SQL Tuesday again and this time it’s being hosted by the SQL Soldier. He’s picked the subject of Waits. As in, why am I having to wait for my query to finish. Or more specifically what is my query waiting for. Waits are a popular subject. You can… Read more
This post is for T-SQL Tuesday #49, the monthly blog party of the community.
It’s Friday, Friday
It… Read more
“If you could give a DBA just one piece of advice, what would it be?”
John asked 20 successful and experienced SQL Server professionals this exact question. I share my own thoughts… Read more
When you are an aspiring DBA, there are many things that come with that job role that you’ll have to consider as part of the job. You will need to look at disaster recovery, high availability, platform performance, security and a variety of other areas that are… Read more
As I was waiting for the next TSQL Tuesday topic to be announced, we all know that when SQL Server performance is slow, and becomes a big issue in your company, sometimes we need to throw an army at the problem to resolve it. Other times, we can employ… Read more
A couple of weeks ago I gave you some scripts to collect wait stats from your SQL Server instance over time. Assuming that you downloaded those scripts and started using them right away, you now have two weeks worth of wait stats data collected. Do you know what to do… Read more
December 7, 2013 – A day that shall live in infamy….. Ok, not that famous December 7 – in 1941, when the attack on Pearl Harbor occurred. This last Saturday was a day that will be remembered as a great entry into the history books of SQLSaturday events! … Read more
If you could give a DBA just one piece of advice, what would it be?
I asked 20 successful and experienced SQL Server professionals this exact question. You can find their answers inside DBA JumpStart, a unique collection of inspiring content just for SQL Server DBAs.
Just Another Blog…
Tis the season once again. We have SQL gifts a plenty for any and all who wish to partake.
2 comments, 84 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 9 December 2013