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
917 reads
Blog Posts
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
623 reads
SQL PRIMARY KEY CONSTRAINT Syntax
In this tutorial we show how to use ALTER TABLE and add Primary key constraint. This tutorial support our Exam...
2012-07-23
746 reads
SQL Server 2012 AlwaysOn Availability Groups – Part 2
It's already a long time since I have blogged how
to configure your Windows- and SQL Servers for SQL Server 2012...
2012-07-23 (first published: 2012-07-19)
5,321 reads
SQL Server 2012 and summertime in London
The week just passed I have been teaching Learning Tree course 2108 SQL Server 2012 Database Administration in London. It...
2012-07-23
1,018 reads
TechEd Europe 2012 videos online
Microsoft has posted ALL the session videos for TechEd Europe 2012 and they are available for free! What a great...
2012-07-23
844 reads
The Mentoring Experiment–New Call for Mentees
With both Steve Jones and I done with our summer break, we’re ready to continue with several experiments we’ve been...
2012-07-23 (first published: 2012-07-19)
2,570 reads
Windows Cluster: Moving Quorum Disk to Another Node
In my earlier post I have explained about various quorum settings available in Microsoft windows 2008 cluster environment. While we plan to...
2012-07-23
15,396 reads
Cycling is good for you
It’s been a great day for British cycling with Bradley Wiggins becoming the first Briton to ever win the Tour...
2012-07-22
1,103 reads
How to use PowerPivot in Excel 2013
In previous lessons we create basic PowerPivot model now it is time to see how it looks in Excel 2013...
2012-07-22
1,268 reads
Blogs
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Forums
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries