Changing Taxonomy
Steve Jones is considering changes to SQLServerCentral and presents a few ideas today.
2008-12-27
521 reads
Articles
Changing Taxonomy
Steve Jones is considering changes to SQLServerCentral and presents a few ideas today.
2008-12-27
516 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,707 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
Merry Christmas 2008
Steve Jones wishes the SQLServerCentral community a Merry Christmas and Happy Holiday!
2008-12-25
20 reads
2008-12-25
3,350 reads
How To Get the List of Files from an FTP Server in SQL Server Integration Services (SSIS) 2005
We use the FTP task in SSIS to process a number of files from an FTP server. We would like to implement a step in our SSIS packages that would retrieve the list of files that are available on the FTP server before we try to process them.
2008-12-24
4,073 reads
Blogs
Future-Proofing: How to Stay Ahead in FinOps
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers