Also, my daughter learning to turn 

Cool. I've sold a few pens (and made more as gifts), and I agree. Not much more than offsetting costs.

Here's one of mine. 

Ooh, that's interesting. I didn't see that when I edited this. I'll try to ping Frank, but my guess is that it was some sort of typo that didn't work...

Need to see more code to know what might work, but PoSh is often easier for programming some stuff than T-SQL, especially looping type constructs.

Ah, apologies. I'll correct this. I'm sure my test db had an _sc collation

Many years ago I needed to better support my family while working a job 7:30am-5:30pm, so I got a second job working 6:00pm-10:pm.  When my main employer found out,...

I was an on-call firefighter for nine years. Made for a great way to get out from in front of a computer screen. Also made for some long days...

Yeah, I think a few of my code examples got absorbed. I'll correct them

Thank you for the sum up of the new "Operator".

I believe it's beneficial to have this operator available as an ANSI standard in SQL Server. This is especially true...

Worth mentioning: the CONCAT function implicitly converts all arguments to character data types, while the + operator always chooses the cheapest possible type conversion. This often results in errors...

Posted on X and go this:

"Initial thoughts without any googleing, is that it could be a long process using a transaction that got deadlock killed mid-flight but not being caught...

I've been looking for a reference. The AIs say that you can't filter on an AD group, only users. That seems like a failing, but one I'm not surprised. I...

turning on encryption for the server? Likely there is, but not sure I've seen this documented. Most of the server side items require the MMC for SQL Server Configuration Manager...

It's not adult content. X.com is formerly twitter.

It's this page

You need to connect from the SSAS server to the source db, not from your SSMS local. That's where the connection issues are. Your SSMS is a client, which has...