Speaking at SQLSaturday Chicago
I’m happy to announce that my first public session of 2016 will be at SQLSaturday Chicago on March 5! I...
2016-01-26
430 reads
Blog Posts
Tim Ford’s Entry-Level Content Challenge
All bloggers started as beginners. We picked things up, learned them, and got to the point where we wanted to start sharing our knowledge. The problem is that most...
2016-01-26
6 reads
Tim Ford’s Entry-Level Content Challenge
All bloggers started as beginners. We picked things up, learned them, and got to the point where we wanted to...
2016-01-26
572 reads
Webcast: Upgrading and Migrating SQL Server 2005 BI Features to SQL Server 2014 and 2016
Please join me on February 3rd at 10 Pacific Time for this presentation brought to you by Microsoft and SolidQ...
2016-01-26
527 reads
What is an Identity?
Identity (or AutoNumber) is a column that automatically generates numeric values. A start and increment value can be set, but...
2016-01-26
129 reads
What is Normalization in SQL Server?
In relational database design, the process of organizing data to minimize redundancy is called normalization. It usually involves dividing a...
2016-01-26
201 reads
What is RESULT SETS?
I was reading some code the other day and it included the statement RESULT SETS. I’d never seen it before...
2016-01-26 (first published: 2016-01-14)
8,007 reads
From the Power BI dashboard to a specific page in a Report
Recently, I was working with a customer designing Power BI reports and dashboards. Everything was going great until she asked...
2016-01-25
2,790 reads
Goodness-of-Fit Testing with SQL Server Part 4.1: R2, RMSE and Regression-Related Routines
By Steve Bolton
…………Throughout most of this series of amateur self-tutorials, the main topic has been and will continue to be...
2016-01-25 (first published: 2016-01-13)
1,957 reads
Monday Morning SQL Break – January 11, 2016
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-01-25
523 reads
Blogs
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers