SQL FOREIGN KEY CONSTRAINT Syntax
You can enforce referential integrity (ensure you don't get orphans) by adding Foreign Key Constraint and in this tutorial you...
2012-07-24
937 reads
Blog Posts
SQL Saturday 122: T-SQL 2012 presentation
This last weekend, I had the pleasure of being invited down to Louisville, KY to speak at SQL Saturday #122....
2012-07-24
1,012 reads
SQL Unique Constraint
In this blog psot we show how to restrict users from entering duplicated data by using SQL UNIQUE Constraint. In...
2012-07-24
787 reads
Help others and enter to win a prize
My home state of Colorado has been devastated by wildfires. My vacation this summer was semi-cancelled with a fire closing...
2012-07-23
1,285 reads
O, There’s the Data: Using OData in SSIS
The Open Data Protocol (OData) is an open specification created Microsoft to enable exposing data in a standard way from...
2012-07-23
1,287 reads
PowerPivot default measure aggregation
One of the PowerPivot advantages is flexibility of changing measure aggregation for instance changing average to minimum. PowerPivot applies default...
2012-07-23
695 reads
PowerPivot hide fields and unhide in Excel 2013
In this PowerPivot tutorial I show how to improve user experience by hiding fields from PivotTable (client tool) so user...
2012-07-23
822 reads
Should We Customize the SQLSaturday Hashtag on Twitter?
The question was posed on Twitter recently (or perhaps more along the lines of “why can’t we”), suggesting that our...
2012-07-23
777 reads
SQL CHECK CONSTRAINT Syntax
We have now added SQL CHECK CONSTRAINT to Exam Guide 70-461 Querying SQL Server 2012 and SQL Tutorial
2012-07-23
921 reads
SQL DEFAULT CONSTRAINT Syntax
This time we show how to use SQL DEFAULT CONSTRAINT to provide values for fields that are not given a...
2012-07-23
629 reads
Blogs
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Forums
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Development Is Fun
Comments posted to this topic are about the item Development Is Fun
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers