SQL Server articles
Between attending SQL SKILLS immersion events, trying out for the PFE role at Microsoft I have managed to write some...
2016-03-16
179 reads
All About SQL
An Extended Event script
I have been enjoying XE alot recently ( from following SQLSKILLS) so I decided to write something that I used recently...
2015-05-22
144 reads
Carving up CHECKDB
This is a technique that I am using from Paul Randal – concept of splitting CHECKDB: CHECKALLOC, CHECKCATALOG and CHECKTABLE – here...
2015-05-16
167 reads
Welcome to BlobEater
I am an IT Professional from the UK with a huge interest in MS technology especially SQL Server and Azure. During...
2015-03-25
301 reads
A Handy function
If you like learning about internals use the undocumented function to get the FileID:PageID of your table rows and use...
2015-03-03
165 reads
Timed SQL Server tracing
Have you ever wanted to start a SQL trace (server-side trace!) from SQL agent and let it stop after X minutes...
2015-02-07
240 reads
2015-02-06
190 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