MatrixDB
A new feature for SQL Server? Steve Jones talks about a very interesting job posting from Microsoft.
MatrixDB
A new feature for SQL Server? Steve Jones talks about a very interesting job posting from Microsoft.
Measuring Performance of Stored Procedures
Database developers need to write stored procedures which are not only fully functional, but also which perform acceptably. This article concentrates on some of the counters used to measure performance and analyses methods of capturing these counters.
Using xp_ReadErrorLog in SQL Server 2005
I would like to share some interesting parameters I found for the undocumented extended stored procedure xp_ReadErrorLog. In doing some testing with this extended stored procedure I found four very interesting parameters. Adding to some of the articles already on the web that discuss undocumented stored procedures, in this article I will explain my testing, use and some examples of the procedure.
RESEED in SQL 2000 and SQL 2005/2008
This article looks at the difference in behavior of RESEED in SQL Server 2000 and SQL Server 2005/2008
Making the Most Out of the SQL Server 2005 Performance Dashboard
The SQL Server 2005 Performance Dashboard is a new add-on to SQL Server 2005 that became available shortly after the release of Service Pack 2 for SQL Server 2005.
What BI Practitioners Can Learn From Operations Research
Growing interest in analytics and the trend toward automated decision making will lead the business intelligence crowd toward the mix of mathematical and statistical techniques used by operations researchers.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Fatmawati Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Jl. Komp. Rs. Fatmawati No.1, Cilandak Bar., Kec. Cilandak, Kota Jakarta Selatan,...
BCA KCP Wahid Hasyim Tlpn/wa0853.7373-7551
Jl. K.H. Wahid Hasyim No.82, Kb. Sirih, Kec. Menteng, Kota Jakarta Pusat, Daerah Khusus...
BCA KCU KEBAYORAN BARU Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Jl. Melawai Raya No.Blok B, RT.7/RW.5, Kramat Pela, Kec. Kby. Baru, Kota...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers