Certification
There seems to be quite a flurry of talk these days about certification. There is evidence of it in the...
2010-03-26
1,257 reads
Jason Brimhall
Security Audit
Of late I have seen a lot of questions on how to audit the logins and users on each SQL...
2010-03-19
1,774 reads
Another Presentation Down
This evening I had the opportunity to once again give a presentation at our local SQL Uses Group (SSSOLV). I...
2010-03-12
620 reads
Log Growing Pains
Understanding the transaction log seems to be a very difficult concept fro mos DBAs to grasp. Jason Brimhall brings us a new article that helps to troubleshoot the cause of log growths.
2010-03-11
18,704 reads
Log Growing Pains Article
I Just had an article published at SQLServercentral on troubleshooting the cause of log growths. At the conclusion of that...
2010-03-11
471 reads
IO IO IO
Once again it is that time. It is TSQL Tuesday. This time it is being hosted by Mike Walsh. Mike...
2010-03-09
1,349 reads
Index your FK
A few months ago I read an article from SQLServerCentral.com about some Foreign Key gotchas. Since that article, I have seen...
2010-03-05
860 reads
Worst Thing to Do to your DBA
Recently Andy Warren Blogged about things that could drive your DBA mad. There was a lot of feedback on SQLServerCentral...
2010-03-05
750 reads
DBA MD
I just had the opportunity to spend some time with my four year old son at the doctor’s office. It...
2010-02-25
598 reads
Why All The Fuzz?
I really must thank Steve for his editorial on FizzBuzz. It seemed like a really good topic to do some...
2010-02-23
780 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