Should Apps Use a Dedicated Port?
Most applications connect on whatever the default port is, typically 1433 for SQL, though it’s common to change that to...
2012-07-24 (first published: 2012-07-18)
1,972 reads
Blog Posts
SQL 2012 evaluate installation requirements
As part of my preparations for 70-462 Administering SQL Server 2012 today I have created a blog post covering "evaluate...
2012-07-24
1,304 reads
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
933 reads
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
997 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
784 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,284 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,283 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
690 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
816 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
775 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