Non-obvious APS/PDW benefits
The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has a lot of obvious...
2014-10-07
1,073 reads
The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has a lot of obvious...
2014-10-07
1,073 reads
You might be reading a lot about Cloud computing and see three acronyms frequently: IaaS, PaaS, Saas. Cloud providers offer...
2014-09-30
1,770 reads
Thanks to everyone who attended my session “Modern Data Warehousing” at the Central New Jersey SQL User Group yesterday. The abstract...
2014-08-14
1,219 reads
I will be presenting the session “Modern Data Warehousing” tomorrow (Wednesday, August 13th) at the Central New Jersey SQL User...
2014-08-12
639 reads
All the videos for the sessions at 24 Hours of PASS (Spring 2014) are available for free. Check the session schedule for...
2014-08-07
1,264 reads
When doing ETL, you have the choice of using T-SQL or SSIS (see When to use T-SQL or SSIS for ETL). ...
2014-07-22
1,323 reads
I have a lot of books on my shelves dealing with business intelligence, data warehousing, master data management, and consulting....
2014-07-16
1,218 reads
All PASS Business Analytics Conference 2014 recordings are now available. If you purchased the online sessions, to view, log on to your myPASS...
2014-06-19
881 reads
Thanks to everyone who attended my session “Modern Data Warehousing” for Pragmatic Works last Thursday. The abstract for my session is below...
2014-05-25
1,002 reads
I see a lot of confusion when it comes to Hadoop and its role in a data warehouse solution. Hadoop should...
2014-05-12 (first published: 2014-05-06)
5,397 reads
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
WA:0821-4447-7715 Jl. Veteran No.18-24, Krembangan Sel., Kec. Krembangan, Surabaya, Jawa Timur 60175
WA:08218154393 Jl. Jend. Sudirman No.49-51, Terban, Kec. Gondokusuman, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55223
WA:08218154393 Jl. Kisamaun No.57, RT.001/RW.006, Sukasari, Kec. Tangerang, Kota Tangerang, Banten 15118
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