SQL Saturday in Iowa City This Weekend
In just a few short days, it will be time for SQL Saturday #98 in Iowa City. If you’ve got...
2011-09-27
715 reads
Blog Posts
SQL University SSIS : Named Pipes -- Producer
Yesterday, I set up the premise for using named pipes in SSIS. Today we are going to get into the...
2011-09-27
689 reads
SSIS Child Errors in Parent Package
If you have a parent package that is looping through a set of files and calling child packages and want...
2011-09-27
2,722 reads
Start daily programs – More n00bz fun with #Powershell!
When I get in to work in the morning, I like a good cup of coffee waiting for me, a...
2011-09-27
1,213 reads
workaround for orphaned users
The server principal is not able to access the database under the current security context, is the error message appears...
2011-09-27
392 reads
Book Review: Smarter, Faster, Cheaper
In my continuing quest to not get personal visits from Buck Woody (blog|twitter) I’m making sure that I make good...
2011-09-26
1,477 reads
Database Properties Health Check
For some time now, I have been working on a new book called How to Perform a SQL Server Health...
2011-09-26
949 reads
Notes from SQLSaturday #85
I’m writing this on Sunday afternoon after the event, thinking about the event and what I want to share with...
2011-09-26
630 reads
PASS 2011 Countdown – 2 Weeks To Go
I’m not sure how we got to 2-weeks until this year’s PASS Summit. If you haven’t registered yet it’s really...
2011-09-26
532 reads
Paying for Free
It seems like there is a widespread malaise in the country these days. Everyone's clamoring to cut taxes -but no one wants to have their neighborhood school closed, or...
2011-09-26
9 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