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,258 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,799 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,350 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
862 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
781 reads
Blogs
Can I Change a Primary Key Value? #SQLNewBlogger
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
SQL Server Index Primer
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Secure Azure SQL Server Backups Using Managed Identities
By Arun Sirpal
I do believe most people know about the ability to backup your SQL server...
Forums
Update particular record in a table
I need to update greatherthan8 (category) record to Missing (status) if the same member...
Internationalisation
Quick one I hope in case I'm heading off in entirely the wrong direction!...
Size of DB on physical disk doesn't match Disk Usage by Table report
Hi everyone I am looking at the size of my db on disk (ie...
Question of the Day
Getting the TEXTSIZE
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers