Antipathy for Entity Attribute Value data models
EAV models have their uses but the costs are often hidden and if not hidden, more than anticipated.
The Data Scientist
Phil Factor on why Data Science is about much more than just clever visualizations and big data.
The Optimists
A develop should be a glass-half-full kind of guy, at least according to Steve Jones. This editorial was originally published on April 15, 2008. It is being re-run as Steve is on holiday.
VARCHAR (MAX), NVARCHAR (MAX) and NTEXT Data Types
Despite NTEXT and TEXT being deprecated in SQL Server for some time they are still both used in production systems. In this article, I will briefly demonstrate the difference between a VARCHAR (MAX), NVARCHAR (MAX) and the NTEXT data types, and the impact on performance from using NTEXT/TEXT.
The Growth of Storage
This week Steve Jones asks you to predict the future of hardware. When will we have laptops that rival the specs of today's large SQL Server servers.
Working With Multi-Select Parameters for SSRS Reports
Multi-select parameters give your users control over their reports while reducing the number of reports they have to work with. This example demonstrates how to create a multi-select parameter list and pass the values to a stored procedure that will then populate the report.
Fun with ACID
What is ACID and why should we care? A look at the principal that drives all database and DB management software design: A.C.I.D.
Serious Security
The password issue has Steve Jones concerned. So many of us that use computing devices don't do a good job of securing our information.
Free eBook: SQL Server Execution Plans
Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. This book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy.
Blogs
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kontak Resmi BCA KCU GADING SERPONG Telp:08218154393
WhatsApp:08218200205 Summarecon Serpong, Perumahan Gading Serpong, Jl. Gading Serpong Boulevard Cluster Scientia Garden No.001...
Alamat Kontak Resmi BCA KCP Kepa Duri Telp:08218154393
WhatsApp:08218200205 Jl. Mangga Raya No.20, RT.4/RW.3, Duri Kepa, Kec. Kb. Jeruk, Kota Jakarta Barat,...
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers