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,840 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
721 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
631 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
773 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
755 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,949 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
892 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,318 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
661 reads
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
SQL Art, Part 3: Happy Easter Fun in SSMS
Comments posted to this topic are about the item SQL Art, Part 3: Happy...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers