SSIS Alpha Splits using the CODEPOINT() Function
A relatively common requirement in ETL processing is to break records into disparate outputs based on an alphabetical split on...
2010-02-04
4,408 reads
PASS Update #23
January has been a slow month for me as far as PASS involvement, I show about 10 hours logged for...
2010-02-04
453 reads
Searching for Objects or Text Strings Using SQL Search
As a DBA, at one time or another, you will need to quickly find an object within a database, such...
2010-02-04
4,336 reads
The Events that Brought Me Here
1st event: I am here because my father wanted to be reunited with his family. He also hoped that his...
2010-02-04
680 reads
Questions About SQL Server Backups
SQL Server backups are a “funny” topic to talk about. If you are talking with experienced DBAs, the topic of...
2010-02-03
801 reads
Am I working too much?
The other night I was tired, a few long days, early mornings with the kids, and slightly wired, but needing...
2010-02-03
289 reads
SQLSaturday & PASS – More Details
Yesterday I posted the news that SQLSaturday is now owned by PASS, today I’d like to share a bit of...
2010-02-03
1,096 reads
What Would I Do With a Week?
After my editorial this week on Coding By the Sea, my boss actually pinged me to say that I could...
2010-02-03
388 reads
Knowing how to use ATTRIB
ATTRIB is one of those commands back from the days of DOS which most folks don't even realize it's there....
2010-02-03
2,232 reads
DBCC CHECKDB() on ResourceDB?
A few days ago I was answering a forum post about CHECKDB() and as part of the research I checked...
2010-02-03
1,488 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