Sql Joins- Inner Joins, Self Joins, Outer Joins, Cross Joins
I generally feel that people are afraid of Joins in SQL Server. But if they know what the different types...
2010-01-02
24,849 reads
Blog Posts
This Blog is Moving!
I’ve moved my blog to www.sqlandy.com and the first post of 2010 is up. It’s still very much a work...
2010-01-02
289 reads
2009 Goals in Review
Late last year, I blogged about some goals I had set for myself to accomplish during 2009. No goal-setting session...
2010-01-01
1,112 reads
Board Election for the North Texas SQL Server User Group
The new year is less than 24 hours old and I’ve already been blessed with two different honors. I shared...
2010-01-01
553 reads
I’m a Microsoft MVP!
I received a notification e-mail earlier this morning that I’ve been selected as a Microsoft SQL Server MVP for 2010! ...
2010-01-01
908 reads
Moving My Blog and Rebranding Too
I started blogging about 2-1/2 years ago on SQLServerCentral.com and at the time it was the logical place for hosting....
2010-01-01
327 reads
Plagiarism
And really bad plagiarism at that.
I received an email from someone suggesting I check out a book on Lulu.com, that...
2010-01-01
1,029 reads
Re-Awarded MVP Status for 2010
I have been re-awarded MVP status for SQL Server for 2010. It's a humbling honor, and I will strive again...
2010-01-01
934 reads
Three in a Row – MVP Renewed
I woke up this morning, late, after a great New Year’s Eve with friends. Too tired to get out of...
2010-01-01
332 reads
Three in a Row – MVP Renewed
I woke up this morning, late, after a great New Year’s Eve with friends. Too tired to get out of...
2010-01-01
347 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers