No, Simple Mode Doesn’t Disable The Transaction Log
If you’ve spent any time with me in person, trading war stories, you’ve likely heard my rant about the consultant...
2013-10-21
6,248 reads
RealSQLGuy - Helping You To Become A SQL Hero
One-stop Shopping for Backups
First, let me say that yes, I’m aware of Ola Hallengren’s excellent set of maintenance scripts, including those for doing...
2013-10-05
374 reads
New Blog Series – Origins
I’ve been struggling for months to bring this blog back to life. I’d love to produce content dedicated to the...
2013-10-02
420 reads
Using A Non-correlated Subquery To Avoid DISTINCT
Nobody wants duplicate data. It’s messy, wastes space, and looks really bad on a report – I get that. What I...
2013-10-02
1,298 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