A New Word: Vaucasy

Posted on November 17, 2023 by way0utwest

vaucasy – n. the feat that you’re little more than a product of your circumstances, that for all the thought you put into shaping your believes and behaviors and relationships, you’re essentially a dog being trained by whatever stimuli you happen to encounter, reflexively drawn to whoever gives you reliable hits of pleasure, skeptical of ideas that make you feel powerless.

I think a lot about how my life has gone, and how I react to things. My thoughts, my behaviors, and how my past shapes me. I do try to learn more, and I think I do a good job.

I’m also proud of watching my kids grow and change as adults. When I look at them, I think they have a really interesting mix of things they inherited from my wife or I, and also from their experiences. They are all very different, but similar.

Vaucasy is certainly something that I think affects all of us. There is a very human need to react to simuli, looking for pleasure. I also think we can change that and put our thoughts into shaping behaviors and thoughts, but it takes effort.

It’s worth it.

From the Dictionary of Obscure Sorrows

Posted in Blog | Tagged , | Comments Off on A New Word: Vaucasy

Republish: Singular or Plural

Posted on November 17, 2023 by way0utwest

I still in Seattle attending the PASS Data Community Summit 2023. I decided to republish Singular or Plural today as my thinking has changed on these items. This isn’t worth a long debate. Get everyone in the room and let 2-4 people get 5 minutes to make a case, take a vote, and move on.

I need to write an editorial on that.

Posted in Editorial | Tagged | 1 Comment

Deploying Indexes with SQL Compare

Posted on November 15, 2023 by way0utwest

I suspect many people assume this is the case, but a customer recently asked if SQL Compare handles indexes. It does, and this post shows the basics of index comparisons with no filters.

This is a part of a series of posts on SQL Compare on my blog. You can read other posts I’ve written by clicking the link.

The Setup

I have two databases that are completely synced from a schema perspective.

2023-10-30 13_56_53-SQL Compare - E__Documents_SQL Compare_SharedProjects_(local)_SQL2017.SimpleTalk

I’ll now create an index in Compare1. This is a simple index on a single table. I use this code:

CREATE INDEX IDX_mychar ON dbo.MyTable (Mychar)

Once I refresh the compare, I see this. Note that I’ve selected the table that has a difference and it shows the new index. This bottom left shows the scripted version of the code I ran above.

2023-10-30 13_58_13-SQL Compare - E__Documents_SQL Compare_SharedProjects_(local)_SQL2017.SimpleTalk

If I create the deployment script, I see the index in it, as shown here:

2023-10-30 13_59_03-Deployment

By default, SQL Compare includes almost all objects and that includes indexes. There are options to change the behavior with indexes, and I’ll cover those in future posts. You can also set a filter that might exclude indexes (or include those), but those are also future posts.

SQL Compare is a fantastic product for simplifying work and it does so much more than this. Give it a try if you own it or download an evaluation today.

Posted in Blog | Tagged , , | Comments Off on Deploying Indexes with SQL Compare

Republish: Can Data Save the World

Posted on November 15, 2023 by way0utwest

I still in Seattle attending the PASS Data Community Summit 2023. I decided to republish Can Data Save the World? because I do think data is important for improving all aspects of the world. It’s not all we need, but it does matter. The more we measure and learn, the better decisions we can potentially make.

Posted in Editorial | Tagged | Comments Off on Republish: Can Data Save the World