If you have not had the chance to work with SQL Server 2005, or even if you have, Robert Pearl brings us some important information about what your upgrade or installation of the next version of SQL Server will bring. This is information every administrator needs to know to get prepared.
2008-01-11 (first published: 2005-06-29)
199,281 reads
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,780 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,267 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
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Every organization I talk to has the same problem dressed up in different clothes....
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item Creating a Simple and Flexible...
Comments posted to this topic are about the item SQL Art, Part 3: Happy...
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers