SQL Quiz 5: SANs Mirroring
My turn to answer Chris Shaw’s questions “Do I feel I have a reliable SAN solution?” and “Describe Database Mirroring...
2009-08-12
618 reads
My turn to answer Chris Shaw’s questions “Do I feel I have a reliable SAN solution?” and “Describe Database Mirroring...
2009-08-12
618 reads
I thought I had captured statement start times within the DMV sys.dm_exec_sessions. I was absolutely wrong. However, this has sparked...
2009-08-11
940 reads
I was introduced to the Thrive program when my user group held a Thrive event back in March. Since then...
2009-08-09
543 reads
Hrmmm… 198. Up four pounds. That just doesn’t seem possible. I did a tabata on Monday. I did have a...
2009-08-08
530 reads
The PASS Application Development SIG is hosting a web cast next week on Tuesday where I’ll be presenting Understanding Execution...
2009-08-07
818 reads
I’m fairly certain Jack Bauer isn’t involved with this new initiative from PASS. Just as I’m also certain I won’t...
2009-08-03
727 reads
Thursday this week I get to hang out, virtually, with some of the heavy hitters of the industry, Brent Ozar,...
2009-08-03
515 reads
PASS is relaunching the SQL Server Standard with a wholly new approach and format. I’ll put more out about it...
2009-08-03
704 reads
I like to blog about technical topics and community, not personal stuff. However, this is a community post. A number...
2009-08-01
618 reads
I thought I had an interesting answer to the question. Unfortunately Adam Machanic, who has been working in this specific...
2009-07-31
1,304 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers