For the most part, the default configurations for SQL Server are pretty good. Yeah, there are a few you should definitely change (like say, the ones involving parallelism), but...
2019-08-30
7 reads
For the most part, the default configurations for SQL Server are pretty good. Yeah, there are a few you should definitely change (like say, the ones involving parallelism), but...
2019-08-30
1 reads
I’ve been fortunate to have spoken at a few SQL Saturday events this year, and one of the sessions I’ve had the pleasure of presenting has been about getting...
2019-08-01
4 reads
I’ve been fortunate to have spoken at a few SQL Saturday events this year, and one of the sessions I’ve had the pleasure of presenting has been about getting...
2019-08-01
2 reads
It’s been a while since I’ve had a new post here, and that’s largely due to the quantity of other things on which I’ve been working. This list of...
2019-04-19
5 reads
It’s been a while since I’ve had a new post here, and that’s largely due to the quantity of other things on which I’ve been working. This list of...
2019-04-19
1 reads
Maybe more people would use the Central Management Server feature of Management Studio if it had a name that didn’t sound as utilitarian as a heat pump. Something like...
2019-01-28
6 reads
Maybe more people would use the Central Management Server feature of Management Studio if it had a name that didn’t sound as utilitarian as a heat pump. Something like...
2019-01-28
2 reads
As I’m sure you’re aware, the career path for a SQL Server DBA is a wonderful journey of growing your catalog of knowledge through unexpected lessons. For example: Did...
2018-12-02
1 reads
As I’m sure you’re aware, the career path for a SQL Server DBA is a wonderful journey of growing your catalog of knowledge through unexpected lessons. For example: Did...
2018-12-02
2 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers