5 Top Features Your Company Can Use in SQL Server 2014 Standard Edition
In a few days SQL Server 2014 will be made available, we’re not all lucky enough to be running Enterprise...
2014-03-26
1,150 reads
Richard Douglas
Grant View Server State
There are lots of Dynamic Management Objects (DMO’s, more commonly referred to generically as DMV’s) that require extra permissions. Without...
2014-04-02 (first published: 2014-03-25)
83,512 reads
Speaking at Luxembourg SQL Server User Group
Tomorrow evening I have the honour of speaking at Microsoft’s office in Clausen, Luxembourg. The session I will be presenting...
2014-03-25
776 reads
Remaining Vigilant, my contribution to #DBAJumpStart – Part 3
This post is part of the SQL Community Project #DBAJumpStart by John Sansom. As I mentioned previously, this post has...
2014-03-27 (first published: 2014-03-20)
1,575 reads
Remaining Vigilant, my contribution to #DBAJumpStart – Part 2
This post is part of the SQL Community Project #DBAJumpStart by John Sansom. As I mentioned yesterday, this post has...
2014-03-24 (first published: 2014-03-19)
1,458 reads
Remaining Vigilant, my contribution to #DBAJumpStart – Part 1
This post is part of the SQL Community Project #DBAJumpStart by John Sansom.
“If you could give a DBA just one...
2014-03-18
756 reads
A Tale of Two SQL Server Webcasts
Things have been quiet on my blog of late (hosting issue) but now things are back online. Talking of online,...
2014-03-17
749 reads
PASS Performance Virtual Chapter Webcast
A quick check of my calendar this morning reminded me that I am presenting a session for the PASS Performance...
2013-12-02
831 reads
SQL Server events in the UK – December 2013
The Christmas countdown has begun for a number of us. This doesn’t mean it’s time to relax, there’s still plenty...
2013-12-02
595 reads
SQL Cruise competition, and the winner is …
Earlier this month SQL Cruise, (an initiative created by Tim Ford (B|T)) and Dell Software announced a competition to win...
2013-11-26
708 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