Archives: January 2017
I was curious about how the SQL language stands with the other technologies. Next table shows it. The data is taken from StackOverflow.
I love SQL Prompt, especially the new formatting engine. However, it’s not perfect, and there are times I don’t want code reformatted. One great example is when I write INSERT statements. Here’s what I might write:
INSERT dbo.Payments_A ( [Month], SerialNumber, DateBegin, DateEnd, paid) VALUES ( 'Mar-15', '0000000000001', '3/16/2015 0:00',…
As DBAs we all know setting your file growth to grow by percent is not optimal. It can cause all kinds of issues, which rear their ugly heads as performance problems (see these articles by Brent Ozar, & Tim Ford). So, when I have to support… Read more
Starting a business is easy. Have an idea, some skills, a customer or two, and you are in business. However, growing a business is tough. One thing you’ll learn, is to grow a business, you have to build a team. Hiring productive employees or team members will be a core… Read more
I am so honored and excited to have been selected to speak at SQL Saturday Richmond on March 18, 2017.
Hello much younger Yates. Hope you’ve been doing well. Why don’t you pull up a chair and stay for a few minutes so we can talk and maybe help another data professional that is just starting out on his or her journey. Nah, it won’t take us a long time… Read more
I’m delighted to announce that I’m selected as a speaker for the Techorama event.
Techorama is a developer congress focusing (but not limited to) Microsoft technologies. This year, the event is even bigger as they have merged with the IT Pro event ITPROceed (where I have spoken 3 times in… Read more
If you’ve been at least paying attention to my blog a little bit, you’ve probably noticed I occasionally blog about Power BI. Part of the reason I blog so often about Power BI is because that’s the topic of a whole bunch of conversations I’m having with my customers.… Read more
Dynamics AX and SQL Server
More and more I am seeing clients requiring assistance with the Microsoft Dynamics Suite. Each of the products in the suite comes with a different set of performance issues and gotchas. In this article I will only be discussing the AX product and an easy… Read more
2016 was a great year, both personally and professionally. Personally, our family is well and the kids are growing into their personalities. Professional, DawaBI merged with Quanta Intelligence to form Datalere.
Our intent with Datalere is to grow and be proactive in earning new customers. In the past, both Carlos… Read more
When Redgate purchased ReadyRoll a few years ago, I wasn’t sure this was a great idea. After all, SQL Source Control and DLM Automation work really well to bundle up changes in a VCS and easily deploy them.
1 comments, 212 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 30 January 2017
Throughout the Azure portal you will find buttons called Quick Start. You won’t find it everywhere but I’ve found it in the Resource… Read more
Wow, what a week last week was.
The biggest thing that happened was that I got a session at SQL Saturday Iceland! They had loads of submissions and could only pick around 20 so very chuffed to have been one of those selected, cue smug face.
The event is… Read more
SQLServerCentral recently published Something I learned while unemployed. Written by Rod Falanga, it has lessons worth learning about making time to stay current and the difference between knowing concepts and implementing them.