Latest Blog Posts
I’ve been studying Azure recently and came across a really interesting Azure site.
To give you an idea why I find this view so interesting I’m going to drill down to a SQL Database that I have.
Up front, you can see some interesting information. The location, status, service… Read more
Reading this blog post by Shawn Melton Introduction of Visual Studio Code for DBAs reminded me that whilst I use Visual Studio Code (which I shall refer to as Code from here on) for writing PowerShell and Markdown and love how easily it interacts with Github I hadn’t tried T-SQL.… Read more
As per BOL (https://msdn.microsoft.com/en-us/library/ff878058(v=sql.110).aspx) : A sequence is a user-defined schema-bound object that generates a sequence of numeric values according to the specification with which the sequence was created. The sequence of numeric values is generated in an ascending or descending order at a defined interval and may cycle… Read more
Heraflux is proud to announce that I am teaching a preconference training session at this year’s upcoming SQL Saturday in Chicago. The training class is entitled “The Complete Primer to SQL Server Infrastructure and Cloud” and is to be held on Friday, March 10th, at the… Read more
One of the things that I often do is create stored procedures. The syntax for doing so is simple, but it has a number of items that need to be included. SQL Prompt makes this much quicker with the “cp” snippet. When I type “cp”, I get this:
I can… Read more
When I first started working as a technologist some 17 years ago, I was doing fairly low-level stuff: moving and reimaging computers, network cabling, and basic desktop support were the extent of my responsibilities. I decided early on that I wanted to move into a more advanced role, but faced… Read more
Wish you a Happy New Year to all the readers and technical enthusiasts!!!
My interview is published on the Microsoft Technet blog yesterday
While forming Datalere, Carlos and I wanted to continue with our contributions to the community. We have been active in the community for over a decade by running user groups, speaking at local, regional and international events, but have only blogged occasionally.
To continue with the community contributions, we are… Read more
I was rehearsing a demo with someone recently and we had some stored procedure code that looked like this:
CREATE PROCEDURE UpdateEmpID @empid INT AS BEGIN UPDATE dbo.Employees SET empid = 3 WHERE empid = @empid ; END
However, this was part of a batch that had all of this… Read more
I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about that, there were months where I barely managed to read anything
The full list, with Amazon links is at the end of this post, I’ll mention a few of the… Read more
I have always maintained a private bucket list. I have not had the courage to actually put it down in writing – but this year I decided that it is time. My good friend Brent Ozar has been doing this for a few years now, and his list is my… Read more
Its the time of year for reflection and I have had the most amazing 2016, I am blessed that I love what I do so much. I thoroughly enjoy writing and talking and sharing and commenting and supporting and cherishing all the SQL and PowerShell things. I wrote about using… Read more
In fact, the next year I got two different laptops,… Read more
For the 4th year in a row, I am keeping data on my professional engagements to help the others –
public presentations, blogging efforts & organisations of the events.
In 2016, I have made my best efforts to reduce travelling and to increase the effectiveness of my presentations. On the… Read more
Today, I’m proud to announce that I have been named a Microsoft MVP – Data Platform. This is an exceptional honor and I’m humbled to be included in this group of exceptional data professionals. I really look forward to working with everyone in the MVP community and continuing to… Read more
A couple of weeks ago I received the disappointing but expected news that I wasn’t renewed as a Microsoft Data Platform MVP. I say expected because I knew my ability to give back to the community had been greatly diminished over the later part of 2015 and into 2016. Between… Read more