The December 2008 Energy Update
Steve Jones gives one last update on energy issues in the US in 2008 with a look at the construction and building industries.
2008-12-28
729 reads
Articles
The December 2008 Energy Update
Steve Jones gives one last update on energy issues in the US in 2008 with a look at the construction and building industries.
2008-12-28
945 reads
Changing Taxonomy
Steve Jones is considering changes to SQLServerCentral and presents a few ideas today.
2008-12-27
516 reads
Changing Taxonomy
Steve Jones is considering changes to SQLServerCentral and presents a few ideas today.
2008-12-27
746 reads
Changing Taxonomy
Steve Jones is considering changes to SQLServerCentral and presents a few ideas today.
2008-12-27
521 reads
How Would You Rate This? - Database Weekly (Dec 29, 2008)
Steve Jones wonders if Microsoft is doing a good job with their efforts to patch SQL Server security issues?
2008-12-27
500 reads
SSIS and Stored procedures using temp tables
SSIS has a problem with stored procedures that use temporary tables to generate output. This article describes a useful technique for working around this problem.
2008-12-26
27,693 reads
Finding a better candidate for your clustered indexes
When creating tables it is difficult to determine exactly how the data will be accessed. Therefore when clustered indexes are chosen they are often just the ID column that makes the row unique. This may be a good choice, but once the application has been used and data access statistics are available you may need to go back and make some adjustments to your tables to ensure your clustered indexes are providing a benefit and not a drain on your applications.
2008-12-26
3,880 reads
How Would You Rate This? - Database Weekly (Dec 29, 2008)
Steve Jones wonders if Microsoft is doing a good job with their efforts to patch SQL Server security issues?
2008-12-26
720 reads
Peer-to-Peer Replication in SQL Server 2008
This article describes the new Peer-to-Peer replication features in SQL Server 2008
2008-12-26
2,534 reads
Blogs
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026)
By SQLPals
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026) ...
The 2026 Redgate Summit in New York City
By Steve Jones
We’re coming back to New York, which is exciting for me. I love NYC....
Monitoring Fabric Mirroring for SQL 2025
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL...
Forums
Why SQL Server Orphaned Users Cause Login Failures
SQL Server Orphaned Users often appear after restoring or migrating a database to another...
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Question of the Day
Historical Data Tracking
If I want to track historical data values, which mechanism should I use?
See possible answers