2008-09-18 (first published: 2008-07-15)
697 reads
Scripts
2008-09-16
328 reads
Create string from table
This simple script retrieves a range of values from a table and presents the results as a string.
2008-09-15 (first published: 2008-07-16)
1,601 reads
Get DBMail information
get the profile name and the account name etc about the dbmails created on the server
2008-09-12 (first published: 2008-07-13)
986 reads
2008-09-11
1,517 reads
2008-09-10 (first published: 2008-07-12)
1,493 reads
DB Connection Killer
This script opens a little cursor that will clean out connections to any DBs you specify.
2008-09-09 (first published: 2008-07-21)
1,498 reads
2008-09-09
1,063 reads
2008-09-08 (first published: 2008-07-20)
1,261 reads
Invalid SKU Error when Adding a Node to a SQL 2008 Cluster
When trying to add a node to an existing SQL Server 2008 cluster you get an Invalid SKU Error
2008-09-07
3,195 reads
Blogs
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Book Review – Microsoft Power BI Performance Best Practices
I was asked to do a review of the book Microsoft Power BI Performance...
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