PASS Update #20
On the Friday at the end of the Summit we had a 4 hour Board meeting, welcoming new board members...
2009-12-03
1,286 reads
Andy Warren
My Schedule at the Summit/Let’s Connect
I’m flying out Sunday via Alaska Air, taking the direct flight from Orlando to Seattle, arriving at 11:40 am. If...
2009-10-30
1,200 reads
PASS Update #18
Eric Wisdahl posted some questions on my last update, and I thought I’d reply here to make my answers more...
2009-10-27
1,051 reads
Sparse Columns – ConvertSVtoXML & XMLToResv
Not very often I run across something with zero matches in a search engine, but had it happen recently. I had set up a simple demo of a sparse column set and happened to look at the execution plan, was interested to see that the Compute Scalar was backed by ConvertSVtoXML. This was on a select from a table with one row, and then, being a little more curious, updated it with an xml fragment I saw a call to ConvertXMLtoResv. I’d venture that those serve to convert back/forth from XML storage.
2009-10-15
1,219 reads
Networking Sins
I ran across this article about networking sins a while back and have had it on my list to share....
2009-09-25
2,229 reads
Blobs and Filestreams
In the next week or so I’ll be upgrading the SQL 2005 server that has the SQLSaturday database and I’m...
2009-09-24
1,829 reads
PASS Update #14
I’ve been on the board just about 8-1/2 months, so I’m not doing too bad on updates, but think I’ll...
2009-09-18
1,080 reads
PASS Connector Editorial for Sep 9, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-09-10
845 reads
Work Habits
I enjoy woodworking as a hobby and as I try new things I find that my work habits during the...
2009-08-31
2,092 reads
How Much Should You Post Online About Your Life?
I’ve touched on it some in the past, but it’s a question that comes up a lot when we discuss...
2009-08-21
2,360 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers