Blogger Awards
A few days ago I wrote about an election that was taking place (ok so it was a week ago...
2010-11-10
566 reads
Jason Brimhall
November S3OLV Recap
Last Thursday we had the monthly meeting for our local PASS chapter. I would normally try to get the recap out a bit sooner. This month, I intentionally delayed...
2010-11-09
November S3OLV Recap
Last Thursday we had the monthly meeting for our local PASS chapter. I would normally try to get the recap...
2010-11-09
495 reads
S3OLV Nov Reminder
This is a last minute reminder about the monthly S3OLV User Group meeting. It is being held on Nov. 4th, the first Thursday of the month rather than the...
2010-11-04
S3OLV Nov Reminder
This is a last minute reminder about the monthly S3OLV User Group meeting. It is being held on Nov. 4th,...
2010-11-04
510 reads
Defensive Db Programming Chapter 07
We are here again after another …um long lapse in time … and ready for another episode in this series. Today we get to talk about chapter 7 in...
2010-11-03
1 reads
Defensive Db Programming Chapter 07
We are here again after another …um long lapse in time … and ready for another episode in this series. Today...
2010-11-03
734 reads
DB Maintenance
About a month ago I read a post by Brad McGehee (Blog | Twitter) concerning a checklist for SQL Server. It...
2010-11-02
568 reads
T-SQL Tuesday #012 – Skills
November is upon us and in some areas this also means that the leaves have changed color. With the change...
2010-11-02
626 reads
Voting Day is Here
Tis the season for voting and SQLServerPedia has thrown out an election as well. The SQLServerPedia awards are under way...
2010-11-02
422 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