Fun Fact: AWS RDS and system_health
Did you know that the system_health Extended Event session was running in your RDS instances? Well, it is. HOWEVER. This query, which works perfectly fine on my on premises...
2020-06-02
58 reads
Did you know that the system_health Extended Event session was running in your RDS instances? Well, it is. HOWEVER. This query, which works perfectly fine on my on premises...
2020-06-02
58 reads
I’m expanding my skill set into AWS in a big way. So, one of the things I do when I’m learning a technology is to write blog posts about...
2020-06-17 (first published: 2020-06-01)
322 reads
I’m launching a new initiative called the Community Circle Cloud Conversation Club (c5 for short). It’s going to a panel discussion lead by experts on cloud technologies. I’ll be...
2020-05-29
13 reads
If you have been reading through all my fundamentals posts and following along, you have built a small sample database, loaded it with data, and learned how to retrieve...
2020-06-10 (first published: 2020-05-26)
298 reads
The general idea for this question came from dba.stackexchange.com: could we, and if we can, how, get row counts after execution. I was intrigued with the idea, so I...
2020-06-01 (first published: 2020-05-18)
580 reads
One of the most frequent questions you’ll hear online is how to determine if a particular index is in use. There is no perfect answer to this question. You...
2020-05-25 (first published: 2020-05-11)
329 reads
In this Database Fundamentals post we continue discussing the functionality of the WHERE clause. We started with the basics of the logic using things like AND, OR and LIKE...
2020-05-04
102 reads
Questions absolutely drive my blog content and I really liked this one: how does the T-SQL CHOOSE command affect performance. On the face of it, I honestly don’t think...
2020-05-11 (first published: 2020-04-27)
630 reads
Over the next couple of months, I’ll be putting on a number of different sessions teaching about the tools supplied by Microsoft, for free, that can help you when...
2020-04-20
233 reads
I am very excited to announce that I will be taking my paid precon content “Tools for SQL Server Query Performance Tuning” and presenting it for free. This is...
2020-04-23 (first published: 2020-04-16)
164 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers