My home office setup
That aging hippie (he likes Apple products and has a goatee) known as Brent Ozar wrote a post recently about his home office studio setup, with a big focus...
2020-01-22
58 reads
Changing the owner of a schema removes all direct permissions of objects owned by the schema.
This is one of those things that probably doesn’t happen all that often, but bit me in the … elbow ... Continue reading
2020-01-31 (first published: 2020-01-22)
409 reads
In Memory Table Indexes
Now that I have written about In-Memory Tables and Migrating to In-Memory tables, let’s look at indexes and how they are created and how they work within those tables....
2020-01-27 (first published: 2020-01-22)
783 reads
Building the Monthly Newsletter for SQLOrlando
One the things I’ve been doing over the last year is sending out a monthly reminder email of upcoming events. Not revolutionary, I know. I’m sharing what we do...
2020-01-30 (first published: 2020-01-22)
167 reads
BlitzWaits custom module available for Inspector V2
We have been working on a new custom module for Inspector V2, in fact this module is part of a new project where we will be producing two other...
2020-01-22
25 reads
New Pluralsight Course – Configuring and Managing Kubernetes Storage and Scheduling
My new course “Configuring and Managing Kubernetes Storage and Scheduling” in now available on Pluralsight here! Check out the trailer here or if you want to dive right in go here! This course offers practical tips...
2020-01-22
8 reads
New Pluralsight Course – Configuring and Managing Kubernetes Storage and Scheduling
My new course “Configuring and Managing Kubernetes Storage and Scheduling” in now available on Pluralsight here! Check out the trailer here or if you want to dive right in go here! This course offers practical tips...
2020-01-22
10 reads
New Pluralsight Course – Configuring and Managing Kubernetes Storage and Scheduling
My new course “Configuring and Managing Kubernetes Storage and Scheduling” in now available on Pluralsight here! Check out the trailer here or if you want to dive right in go here! This course offers practical tips...
2020-01-30 (first published: 2020-01-22)
293 reads
Microsoft Tools That Help Query Tuning
Query tuning is not easy. In fact, for a lot of people, you shouldn’t even try. It’s much easier to buy more, bigger, better hardware. Yeah, the query is...
2020-01-29 (first published: 2020-01-21)
921 reads
Author of the Year 2019 Nomination at MSSQLTips
This year I’ve been nominated again for the Author of the Year award at MSSQLTips. A lot of other fine people have been nominated as well, you can check...
2020-01-21
9 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers