Why nested views are bad
Nested views are bad. Let’s get that out of the way. What is a nested view anyway? Imagine that you have a SELECT statement you… Read More »Why nested views are bad
Home » Archives for Randolph »
Randolph
Help the fight against cancer
Tom Roush The SQL Family lost a much admired member to cancer last month, Tom Roush. In our little community, Tom was a well-known raconteur… Read More »Help the fight against cancer
Speaking at SQLSaturday 725 in Victoria
Victoria is on an island off the coast of Vancouver, British Columbia. The island is wisely called Vancouver Island. It is beautiful there, and I… Read More »Speaking at SQLSaturday 725 in Victoria
Speaking at SQLBits next month
As I mentioned a couple of weeks ago, I will be presenting for the first time at SQLBits in London, on Saturday 24 February 2018.… Read More »Speaking at SQLBits next month
Secure or fast? Secure, obviously …
By now you have probably seen the news about a major flaw in the design of CPUs from all major vendors (Intel, AMD, and ARM)… Read More »Secure or fast? Secure, obviously …
The cloud is not just someone else’s computer
A year ago, I wrote in a post that cloud computing is just someone else’s data center. I was wrong. Whether we like it or not,… Read More »The cloud is not just someone else’s computer
Welcome to 2018
I have been working on a new information session, which I’m hoping to deliver this year. It’s about one of my favourite topics: dates and… Read More »Welcome to 2018
No moving parts, the story of persistent memory
In November 2017, during the PASS Summit keynote, Microsoft’s Bob Ward (Principal Architect) demonstrated a “diskless database” running on Hewlett-Packard Enterprise (HPE) hardware. The storage… Read More »No moving parts, the story of persistent memory
Disable, don’t delete those indexes
A quick post this week, since it’s that time of the year when people do gift exchanges and put up colourful lights. Here goes: If… Read More »Disable, don’t delete those indexes
Take a walk
When I need to clear my head, I go for a walk. When I need to think about a problem, I go for a walk.… Read More »Take a walk
All Mac users should do this immediately
This post is a public service announcement for all users of macOS High Sierra (10.13). (Note: Apple has already released a fix, but if you… Read More »All Mac users should do this immediately
Introducing Azure Data Studio
(Last edited on 9 January 2020) Note: This was originally written for the book SQL Server 2017 Administration Inside Out, but did not meet the… Read More »Introducing Azure Data Studio
MySQL has this feature that SQL Server needs
In the grand scheme of things, MySQL and SQL Server operate in different realms. It’s difficult to compare them because MySQL is predominantly used for… Read More »MySQL has this feature that SQL Server needs
SQL Server 2017 Administration Inside Out
For the last five months or so, I have been helping some really smart people put words on paper, both the physical and electronic kind,… Read More »SQL Server 2017 Administration Inside Out
T-SQL Tuesday: The Contributing Factor
Ewald Cress writes: Find a person or several people to pick on, and tell us a shareable story or two about how they have made… Read More »T-SQL Tuesday: The Contributing Factor