Database Configuration Checklist
This is number four in a series of checklists that I am putting together for a new book I am...
2010-07-03
3,606 reads
There will be no 'Free Lunch' -just great feelings of accomplishment
NEW: Project Criteria and Submission Here I was again awarded the ‘Most Valuable Professional’ (MVP) designation from Microsoft for my...
2010-07-02
555 reads
Using a UDF as a SARG. Make a hash of it!
I am somewhat uncomfortable blogging this, as I feel that it falls into “Polish a turd” category. Having said that,...
2010-07-02
749 reads
The Raw Bloopers
A raw dump of stuff from Memorial Day 2010 until July 4, 2010
Since Community Server has trouble with this,...
2010-07-02
611 reads
SQL Blog (Basic)
1. SQL Objects
a. Stored Procedures : a bunch of SQL statement which can be stored under one name.
Adventages :
can be used...
2010-07-02
1,060 reads
Taking Time Off
I’m trying to better manage my workload. When I owned this site, I struggled to find time off, and typically...
2010-07-02
350 reads
Winner of the June SQL Aloha Contest
This month’s question of the month was:
What is your best advice for boosting index performance?
As usual, selecting the winning entry...
2010-07-02
439 reads
Indexes are best utilized in WHERE, not JOIN
A pervasive oversight in database indexing by newer database users is relying solely on indexes used for joining tables together...
2010-07-01
3,757 reads
Electricity Conservation and Solar PV Power
Since I got my grid-tied solar PV system on my roof turned on almost two weeks ago, I have gotten...
2010-07-01
3,107 reads
SQL Server MVP - Are you kidding me?
I received an email today stating that I had been selected as a Microsoft SQL Server MVP for 2010. This is my...
2010-07-01
734 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
does anyone used https://github.com/ktaranov/sqlserver-kit
Could you please let me know if anyone is used https://github.com/ktaranov/sqlserver-kit github for deployment...
How Can Database Performance Improve the Overall Website Experience?
I’ve been looking into ways to improve the connection between a website and its...
When And How to Automate?
Comments posted to this topic are about the item When And How to Automate?
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers