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.
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.
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.
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.
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.
This Friday we look forward to the various tech events of 2008 and which speakers you think are worth seeing.
Part 2 of this article discusses how to hack/de-cipher the data that has been encrypted by passphrase.
Running backups is enough for disaster recovery, right? That's a myth that could get you into trouble. Steve Jones explains there's more that's needed.
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.
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.
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
BCA Finance Bekasi Layanan Mobil Hubungi:0851•8812•0691 KOMPLEK MEGA OFFICE PARK, Jl. Harapan Indah Boulevard...
Jl. Alaydrus No.47 & 47 A, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat, Daerah...
Jl. Bungur Besar Raya No.32 & 32A, Gn. Sahari Sel., Kec. Kemayoran, Kota Jakarta...
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers