Working with large objects, BLOBs in SQL Server, has always been a little tedious. The forums are filled with questions on this topic. New authro Yoel Martinez brings us a more advanced looked at BLOBs in SQL Server 2005 with code and a technique for compressing large amounts of data to save space.
2008-01-11 (first published: 2007-01-30)
8,820 reads
SQL Server 2005 is an ideal database platform for use in shared and dedicated Web hosting environments. This paper provides best practices for configuring SQL Server 2005 to optimize security, tenant isolation, and the performance of your hosted SQL Server 2005 deployment. Sample scripts for provisioning users and databases for use in shared hosting are included.
2008-01-11
1,576 reads
Many application performance problems can be traced to poorly performing database queries; however, there are many ways you can improve database performance. SQL ServerTM 2005 gathers a lot of information that you can use to identify the causes of such performance issues.
2008-01-11
3,144 reads
You can build some very complex reports in Reporting Services and longtime author Raj Vasant brings us a short tutorial on how you can implement internal navigation structures in your reports.
2008-01-10
5,308 reads
Add a Script component and custom Visual Basic.Net (VB.Net) scripting to SQL Server Integration Services (SSIS) packages to get the full power of .Net.
2008-01-10
3,122 reads
This Friday we look forward to the various tech events of 2008 and which speakers you think are worth seeing.
2008-01-10
49 reads
Part 2 of this article discusses how to hack/de-cipher the data that has been encrypted by passphrase.
2008-01-10
4,751 reads
Do we really need to corner the market for our particular business? Steve Jones talks about the need to grow your business at the expense of others.
2008-01-09
578 reads
Do we really need to corner the market for our particular business? Steve Jones talks about the need to grow your business at the expense of others.
2008-01-09
336 reads
Learn how using basic SQL Server security practices of least privilege, delegated administration and separation of duties will protect SQL Server databases.
2008-01-09
3,806 reads
A RAG pipeline that answers questions in the demo is not the same thing...
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Comments posted to this topic are about the item Looking for New Blood
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers