SQLLunch Resources – Mining Nuggets from the Default Trace
I did my first SQLLunch today and it was fun. I don’t know how many attended, my last look was...
2009-12-21
361 reads
MySpace Using SSDs
Glenn Barry (blog, twitter) posted a note about MySpace using Fusion-IO PCi-E cards to replace hard drives in their systems....
2009-12-21
1,133 reads
Developer Stereotypes
It’s interesting to listen when DBA’s get together, there is always a story or two about the evil that developers...
2009-12-21
1,019 reads
String Manipulation - CHARINDEX()
I see charindex used quite commonly in string manipulation. What I rarely see used is the optional third parameter. Here...
2009-12-19
4,440 reads
Have Lunch with Me
I know you all are clamoring for the opportunity to have lunch with me so I agreed to do a...
2009-12-18
342 reads
Anaylsis Services Partitions and Aggregations PASS Session
For a little more than a year now I've been a part of the PASS BI SIG and have tried...
2009-12-18
431 reads
iPhone Stockholm Syndrome?
I’m not sure it’s true. I don’t think I have iPhone Stockholm Syndrome, as suggested by the article. It’s actually...
2009-12-18
1,472 reads
Taking Notes When You Don't Have a Computer
Yesterday I talked about taking notes using Google Docs. It's a great way if you've got multiple systems (especially with...
2009-12-18
1,563 reads
Stop Splashing with –NoSplash
Many times when I'm teaching a class or working with a group, they express frustration at the load time for...
2009-12-18
487 reads
Holidays and Parties, Gift, Expectations, and Wishes
Most companies do something at the holidays, although it seems to be less with each year, and certainly this holiday...
2009-12-17
1,007 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