Choosing the right professional
I’m writing this blog post from my bed, you may think that’s a little too much information there is a...
2012-01-11
478 reads
Richard Douglas
2011 – The dissection
Blimey, doesn’t seem like a year since I wrote my last end of year review End of year review 2010...
2012-01-01
674 reads
Why I blog #Meme15
I’d seen various #meme tweets on twitter but it wasn’t until I saw this blog by John Sansom (Blog|Twitter) that...
2011-12-15
468 reads
T-SQL Tuesday #025 – How to view the size of all your databases – #TSQL2sDay
It’s that time of the month again, no not time, T-SQL time! If you have not heard of T-SQL Tuesday...
2011-12-13
857 reads
Speaking Engagements
It only seems like a couple of weeks ago since I wrote a post about new years resolutions which you...
2011-11-15
518 reads
Writing queries without data
Sometimes it’s not possible to have the data you need in order to create the most efficient queries possible. This...
2011-11-15
690 reads
Top 5 Third Party Quotes
Unless you’ve worked in a vacuum the likelyhood is that you either are a third company or you have many...
2011-11-09
476 reads
SQLRelay: The Final Sprint
The UK SQL community has never had so many events in such a short space of time. Last week there...
2011-10-06
417 reads
SQLRelay: The Third Leg
Feedback from the second leg of SQLRelay was very positive indeed. The attendees from my Maidenhead group were very impressed...
2011-10-05
667 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
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
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...
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