SQL Table Columns Disappear in Access
A couple weeks ago a user complained that on one of our development databases, one of the views he was...
2011-09-28
1,602 reads
Seth Phelabaum
Replication DDL Triggers
Because this was a problem that Google was zero help on and I did find a couple other people afflicted...
2011-09-21
2,144 reads
Normalize your Linked Server Names
This is a technique I’m sure many people are already using in their environments. Instead of using the actual name...
2011-09-14
3,593 reads
SSMS Tips & Tricks – Registered Server Groups
Here are a couple more SSMS tricks I’ve stumbled upon recently. Both involve the functionality of registered servers. If you...
2011-04-17
1,587 reads
SSMS Tips & Tricks – Scripting Multiple Objects
This is one that I figured most everyone would know, but repeatedly over the past couple weeks in my office,...
2011-04-02
1,337 reads
SSMS Tools Pack – Script Grid Results
Most of us like things that make our lives easier. When they’re free, it’s just that much sweeter. I would...
2011-02-13
1,570 reads
SSMS Tips and Tricks – ALTernative Highlighting
This isn’t exactly the best thing since bread (or even sliced bread for that matter), but I figured I’d share...
2011-02-07
1,301 reads
2010 Goals Review
So… this is late. And I missed my q3 goals review all together. Oh well, not much I can do...
2011-01-23
721 reads
2011 Goals
Last year I posted professional goals along with quite a few other bloggers and it helped to keep me somewhat...
2011-01-23
758 reads
Going to SQL Saturday #46 in Raleigh, NC
So, after a rather hectic few months, I’m finally crawling back out of the hole I’ve been occupying and getting...
2010-09-16
736 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