Setting All Tempdb Data Files to the Same Size
How to set all tempdb datafiles to same size to meet best practice.
SQLRally
A new event is coming to the East Coast next year that will give people a chance to experience a SQL Server conference at a much lower cost.
Shared Datasets in SQL Server 2008 R2
Shared Datasets are one of the features introduced in SQL Server 2008 R2. This article demonstrates how to implement Shared Datasets as well their use-case scenarios.
ANSI PADDING, Trailing Whitespace, and Variable Character Columns
What does ANSI_PADDING mean and how does it affect my SQL Server database?
Collective Intelligence
Trying to keep up with all the learning going on in the SQL Community can be frustrating. Or is it? Give us your answer in this week's Friday poll.
Extending Hierarchical Data Modeling Demonstrated in SQL
The capability of extending the limits of combining multiple node hierarchical structures has not been fully explored. Michael M. David presents a solution to advanced structure combining that is simple to use, generic and freely extends the way hierarchical structures can be semantically combined to produce advanced new hierarchical data structure mashups that dynamically increase the value of the data.
From “One of the Pack” to “Top Dog”
A guest editorial today from Justin H-Davies examines the change to management from the perspective of someone going through the transition. How do you deal with those former co-workers?
Achieve Spatial Data Support in SSIS
Spatial data support in SSIS is weak in comparison to SQL Server. This article demonstrates how to use the CLR to achieve the SQL Server levels of spatial data support in SSIS.
How to Increase Query Speed With a Little Communication
How my former boss solved a performance issue by changing the business rules, instead of query optimization.
Is it Time to Switch to ELT?
Extract-load-transform integration can offer performance and cost advantages over ETL. Here's how to pick the right approach.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCU MENARA BIDAKARA Telpon/WA:085188120691
BCA KCU MENARA BIDAKARA Telpon/WA:085188120691 Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan...
BCA KCP Tebet Telpon/WA:085188120691
BCA KCP Tebet Telpon/WA:085188120691 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N...
BCA KCP Setiabudi Atrium Telpon/WA:085188120691
BCA KCP Setiabudi Atrium Telpon/WA:085188120691 Setiabudi Atrium, Plaza Setiabudi, Jl. H. R. Rasuna Said...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers