Normalisation
The purpose of normalisation is to remove redundancy and prevent conflict. 1st Normal Form (1NF) – Every field can have only...
2013-08-07
538 reads
Client Pressures and Code Quality
In my experience, code quality always trumps urgency because when code has been released that has questionable quality, it is...
2013-06-09
426 reads
SQL Query Result Order
Every time an SQL query is run without the ORDER BY clause, the sort order of the results returned is...
2013-06-05
639 reads
SQL Logical Query Processing Order
This probably applies more to beginners or people who have been using SQL for a while but have been wondering...
2013-06-03
485 reads
SQL and Relational Theory
Do you know the foundation of SQL? According to the book Querying Microsoft SQL Server 2012 Training Kit on the...
2013-05-31
991 reads
The right terminology for the right audience
For those who has the privilege of being in the technology consulting industry for some time and started out in...
2013-01-17
389 reads
Address Clean-up for Mail Merge using SSIS
Remember the good ol’ days of going through a list of addresses and manually cleaning up hundreds if not thousands...
2012-10-19
735 reads
Blogs
What do client diagnostics in Cosmos DB mean?
This topic keeps coming up with my customers so the purpose of this blog...
Adding Row Numbers to a Query: #SQLNewBlogger
By Steve Jones
I realized that I hadn’t done much blogging on Window functions in T-SQL, and...
Adding Row Numbers to a Query: #SQLNewBlogger
By Steve Jones
I realized that I hadn’t done much blogging on Window functions in T-SQL, and...
Forums
service is not available
I was trying to access SSRS report in host server browser , throwing an...
FIFO and manufacturing ... how do I get the current cost?
Sorry, more bakery stuff. Say I buy ingredients over time and I want to...
Linked server and trouble between manager and agent
Hello, I have a problem and i don´t understand it. After to link a...
Question of the Day
Starting to Estimate Disk Storage for Memory-Optimized Tables
If I have durable memory-optimized tables, what is the starting point for estimating storage space?
See possible answers