Finding the Client IP
It’s not often that I’ve had the need to trace back a client to their host computer, but there are...
2010-04-06
855 reads
Nested views causing query performance woes....
Just ran into an interesting issue AGAIN. It seems that when you nest views in a query you are opening...
2010-04-05
8,694 reads
HTC Pro Trade-In
I saw a note that T-Mobile is accepting trade-ins of an iPhone for credit towards a new HTC HD2. That’s...
2010-04-05
666 reads
Get Users By Connection
Introduction
I was recently working a production issue that required me to log in via the Dedicated Administrator Connection (DAC). When...
2010-04-05
344 reads
Microsoft Drops Support For Itanium after SQL Server 2008 R2
Microsoft’s Dan Reger has announced that Microsoft will not be supporting the Itanium architecture after Windows Server 2008 R2, SQL...
2010-04-05
2,346 reads
nHibernate, First Look at TSQL
I’ve blogged in the past about the nHibernate project that has been going on at my company for the last...
2010-04-05
1,018 reads
Express Yourself Clearly
Recently my son had a short paper to write for school. He’s a sixth grader, and this year is a...
2010-04-05
561 reads
Product Review: Fences
Fences is a free utility for the Windows desktop that lets you drag shortcuts into boxes you define (fences) and...
2010-04-05
432 reads
A DMV a Day – Day 5
The DMV for Day 5 is sys.dm_db_mirroring_auto_page_repair, which is described by BOL as:
Returns a row for every automatic page-repair attempt...
2010-04-05
1,024 reads
SQL Server 2008 MCM Results
SQL Server 2008 MCM Results
3 weeks of intense training, intense studying, 3 written tests, and one 6 hour lab exam....
2010-04-04
1,443 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Forward Deployed Engineers
Comments posted to this topic are about the item Forward Deployed Engineers
TRY_PARSE vs TRY_CONVERT in SQL Server: From Basics to Practical Usage
Comments posted to this topic are about the item TRY_PARSE vs TRY_CONVERT in SQL...
DBCC CHECKDB Limits II
Comments posted to this topic are about the item DBCC CHECKDB Limits II
Question of the Day
DBCC CHECKDB Limits II
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers