Adventures in SQL CLR and C#
I’ve toyed with the CLR in SQL Sever 2005 off and on since the first Yukon beta had it enabled....
2009-10-09
2,838 reads
Blog Posts
Baton Rouge October SQL Server User Group
Last night I presented, Monitoring Disk Space using CLR, to the Baton Rouge Area SQL Server User Group. There were...
2009-10-09
718 reads
New Dell PowerEdge R710 Database Server
My long awaited new database server arrived today! It has two, quad-core Xeon X5550 processors, 72GB of DDR3 RAM, and...
2009-10-09
1,788 reads
Next SQL Lunch - Deploying Report Builder 2.0 for Self-Service Reporting
Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=95MQQM&role=attend
Click Here to Add to Outlook Calendar
Click the above Meeting URL around 11:00 AM CST on 10/12/2009 to...
2009-10-09
628 reads
Performance Data Gathering
As a DBA, one of the things I struggled with was gathering all my important system information in one place,...
2009-10-09
772 reads
Reindex and Update stats.
Today I was reading blog by Ben Nevarez it is great... (I am impressed with ben now a days) that's...
2009-10-09
754 reads
Select count(*)
Today I was reading(I always read Paul Randal).
http://www.sqlskills.com/BLOGS/PAUL/post/Which-index-will-SQL-Server-use-to-count-all-rows.aspx
I learned that whenever you query select count(*) it will select the the...
2009-10-09
1,948 reads
SQL Server Announcements From Microsoft
Microsoft has announced the upcoming end of mainstream support for SQL Server 2005 SP2 on January 12, 2010, and for...
2009-10-09
890 reads
What a backed up Database Mirror looks like
One thing you need to be careful about with SQL Server 2005/2008 Database Mirroring is making sure that you don’t...
2009-10-09
1,314 reads
What I did on my vacation
I took a few days off recently to get a break from work. I've rarely taken time off since last...
2009-10-09
660 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Max PK Length
Comments posted to this topic are about the item The Max PK Length
My experience using the GitHub Copilot in SSMS 22
Comments posted to this topic are about the item My experience using the GitHub...
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
Question of the Day
The Max PK Length
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers