If the design of a relational database is wrong, no amount of clever DML SQL will make it work well. Dr. Codd’s Information Principle is that you have, inside the entity tables, the columns that model the attributes of that entity. The columns contain scalar values. Tables that model relationships can have attributes, but they must have references to entities in the schema. You split those attributes at your peril. Joe Celko explains the basics.
There is a new utility to import data from SQL Server on premises or Azure SQL to Azure SQL Data Warehouse (ASDW)
Today Steve Jones talks about the short cuts that developers might take, many of which aren't necessarily helpful.
Slow, unreliable tests prevent teams doing great work, and make continuous delivery impossible. So what can you do to improve your automated tests?
Azure SQL Data Warehouse is Microsoft’s new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just few minutes. In this installment, Arshad Ali covers the different ways to load data into SQL Data Warehouse.
This week Steve Jones wants to know what type of really interesting projects you are working on. Is there something you really enjoy and look forward to building?
We all make mistakes, what you do next is what is important.
Aaron Bertrand shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns.
How can we be sure that the new DBAs are productive a soon as possible? How can we use highly qualified contractors in the most effective way from day one?
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
CSO BCA : 0817839777 Jl. Indrapura No.35, Kemayoran, Kec. Krembangan, Surabaya, Jawa Timur 60176
Comments posted to this topic are about the item Displaying Money
Comments posted to this topic are about the item The Slow Growing Problems
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers