Breaking Into SQL Showbiz
You can tell by my face, I'm an expert
Matthew Velic (blog, Twitter) just asked this question on Twitter:
And really that’s...
2010-09-20
685 reads
SQL Awesomesauce
SELECT: If ON preceeds JOIN, then how….
I got some excellent questions from my 24HOP session yesterday, and when presenting the same session at NTSSUG last night. ...
2010-09-17
491 reads
T-8d till SQL Saturday #52 (CO)
SQL Saturday: All the COOL kids are doing it!
It’s only twelveeight days until SQL Saturday #52 in Colorado! I’ll be...
2010-09-17
588 reads
Know a young IT go-getter? Get her nominated!
Yesterday, I told our Groupies: I feel give-y today. Is there anything you’d like me to promote for you? Wendy...
2010-09-15
476 reads
New Hotness: sys.sql_modules
I’m still old school in many ways. And they’re not the ways that let you get away with wearing wayfarers, or...
2010-09-15
520 reads
Brief Intro to Indexes and INCLUDE – TSQL Tuesday #10!
Content rating: Beginner
This blog was originally posted on December 17, 2009. I’ve pulled it out of the closet for...
2010-09-14
689 reads
Tip: Use System Views to Compare Column Datatypes
Let’s say that you have a staging table, that then loads to a destination table in the same database. If...
2010-09-13
550 reads
T-12d till SQL Saturday #52 (CO)
SQL Saturday: All the COOL kids are doing it!
It’s only twelve days until SQL Saturday #52 in Colorado! I’ll be...
2010-09-13
710 reads
Tip: RESTORE FILELISTONLY / WITH MOVE
As we’ve seen in recent DBARant-able tales, not everyone is completely familiar with methods of restoring SQL backup files to...
2010-09-08
1,733 reads
SELECT, Deconstructed
Today let’s expand on the logical processing order of SELECT that I mentioned in last week’s N Things Worth Knowing...
2010-08-31
2,561 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