Improving cube processing time
As your SSAS cube gets bigger, cube processing time will become a problem. This is especially true as more and...
2012-01-25
11,368 reads
James Serra's Blog
Want to recruit me? Please follow these rules
I get 15-30 calls/emails a week from recruiters (not counting the dozens of auto-generated emails I get). Being a contractor...
2012-01-23
909 reads
PASS Summit session videos online
If you are interested in viewing the recorded sessions for the PASS Summit 2011, you can order the DVD. You...
2012-01-20
904 reads
SQLInspire NYC 2011 Videos available
There are some FANTASTIC videos of the sessions from SQLInspire New York 2011. I highly recommend that you check out...
2012-01-18
535 reads
SQL Server 2012 (“Denali”): SSIS Logging
In previous SSIS versions as the developer you were responsible for configuring all of your logging options, such as what...
2012-01-16
1,233 reads
HP DL980…now this is a server!
I have been fortunate the past few months to be working on a HP ProLiant DL980 G7 Server. This is...
2012-01-13
954 reads
Video/Voice conferencing and Microsoft Lync
Since I work mostly from home, video/voice conferencing and IM are of major importance to me, and using the right...
2012-01-11
1,023 reads
Houston Area SQL Server User Group Presentation
Thanks for everyone who attended my presentation “How To Make a LOT More Money as a Consultant” at HASSUG.
Here is...
2012-01-11
606 reads
Surrogate Keys
When building a data warehouse, it is important that primary keys of dimension tables remain stable. To accomplish this, it...
2012-01-09
3,970 reads
Normalizing Your Database
If you’ve been working with databases for any length of time, you have heard the term normalization.
Normalization is the process...
2012-01-11 (first published: 2012-01-06)
5,083 reads
Blogs
Project Management – Part 1
By Vinay Thakur
The soul of project management is Process Group(PG) and Knowledge Area(KA). they are related...
Install SQL Server 2025 Container on macOS Using OrbStack
My old Dell XPS that I used for personal stuff started to degrade; well,...
Flyway Tips: Immediate Code Review for Developers
By Steve Jones
At the Redgate Summits this year, we’ve highlighted a few things in the Flyway...
Forums
Impact of Single-Threaded PVS Cleanup on ADR in SQL Server 2019
We want to enable ADR on our SQL Server 2019 instances. I’ve heard that...
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...
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