A High Level Comparison Between Oracle and SQL Server - Part IV
The concluding part of the Oracle / SQL Server comparison looks at error logging, security, installation and finally querying the databases.
Decoding the SQL Server Index Structure
A deep dive into the implementation of indexes in SQL Server 2008 R2. This is information that you must know in order to tune your queries for optimum performance. Partial scans of indexes are now possible!
No More NULL
A change in the support for NULL values has Steve Jones commenting on the implications.
Insider Insights
Insider rumours and gossip from the murky world of the Database Industry, and from the colourful characters that inhabit it.
ORM Mapping
A guest editorial from Phil Factor that discusses ORMs and how they ca be used, or mis-used, in our applications.
Managing Your Backup Files
I recently posted a couple of scripts that backup all databases on your SQL Server instance to disk with a...
SQL Server 2008 - Accessing Audit Details
Learn how to use the SQL Server 2008 catalog view and dynamic management view to access the audit details of existing server and database level audits.
Scaling Out the Distribution Database
Replication is a great technology for moving data from one server to another, and it has a great many configuration options. David Poole brings us a technique for scaling out with multiple distribution databases.
Why Be an MCP?
With Steve Jones on vacation, we reprint on of his more popular editorials from the past. This was originally published on Feb 14, 2005.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA Finance Bekasi Layanan Mobil Telpon/WA:08218168291
BCA Finance Bekasi Layanan Mobil Telpon/WA:08218168291.KOMPLEK MEGA OFFICE PARK, Jl. Harapan Indah Boulevard No.8...
BCA Finance Kudus Layanan Mobil & Motor Tlpn/Wa:6285188120691
BCA Multifininace Cabang Kudus, Ruko Sudirman Square, Blok A3, Nganguk, Kec. Kota Kudus, Kabupaten...
Bagaimana cara reschedule tiket AirAsia
Reschedule pada tiket AirAsia dapat dilakukan melalui WhatsApp AirAsia 0823-2461-4949 Atau hubungi Call Center...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers