Scaling Out
Scaling out is hard to do with SQL Server, but why doesn't Microsoft build a better solution?
Scaling Out
Scaling out is hard to do with SQL Server, but why doesn't Microsoft build a better solution?
Custom Report Item - Part I
This article will give a basic introduction of Custom Report Item in SQL Server 2005 Reporting Services.
The Social Contract
How much of a contract for servicing SQL Server should we expect? Has Microsoft broken an implied contract with us?
The SQL Server 2005 XML Temptress
SQL Server 2005 has greatly expanded the XML capabilities of this platform, but should you use it in your database? New author and
MVP Simon Munro brings us a look at how he has used XML and where it might fit in your database.
NCAs and NDAs
When accepting an offer of employment, what do you do about NCAs and NDAs that you might be asked to sign? Steve Jones offers some advice.
NCAs and NDAs
When accepting an offer of employment, what do you do about NCAs and NDAs that you might be asked to sign? Steve Jones offers some advice.
NCAs and NDAs
When accepting an offer of employment, what do you do about NCAs and NDAs that you might be asked to sign? Steve Jones offers some advice.
Schema Comparison with Visual Studio Team Edition for Database Professionals
In this article Dinesh Priyankara describes how schema comparison can be performed using Visual Studio Team Edition for Database Professionals.
Statistics and Indexes
When is it okay to let SQL Server to make a statistic for columns in your queries, and when should you take those statistics and make an index out of them? What I do is to test all of my procs, and if they generate system statistics (_WA_SYS%), then I add an index to the table for the column in the statistic. But is this a good practice?
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
Forums
BCA KCP Permata Kota No. Telp:083831617937
Whatsapp.083831617937 Ruko Permata Kota Blok A No. 10 Jl. Pangeran Tubagus Angke No. 170...
BCA KCP Pluit Kencana No. Telp:083831617937
Whatsapp. 083831617937 Jl. Taman Pluit Kencana Selatan No. 1-3 Jakarta Utara, DKI Jakarta, Indonesia...
BCA KCP Pluit Samudra No. Telp:083831617937
Whatsapp.083831617937 Jl. Pluit Samudra No. 9 Blok N Kav. 5 Jakarta Utara, DKI Jakarta,...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers