Failed SSIS Build – DtsRuntimeException
Hello!
I was helping a team debug a failed build today. Despite the fact that the build compiled on the devs...
2017-10-06
317 reads
Blog Posts
Getting a New R Package–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-10-06 (first published: 2017-09-27)
1,804 reads
Introduction to SQL Server Always On
Today I'll write with one of the features I like the most and is Always On. There will be two...
2017-10-06
1,272 reads
Introduction to SQL Server Always On
Today I'll write with one of the features I like the most and is Always On. There will be two post of this subject, this first one is an...
2017-10-06
22 reads
Simplified Networking with a Wsky USB NIC
I used to share an office with my wife. We both needed Internet connections, with both desktops needing Ethernet cables....
2017-10-06
447 reads
The Death of SQL Server Service Packs
SQL Server Service Packs are going away, starting with SQL Server 2017. I talk about why I think this is a good thing, and discuss Cumulative Updates, Service Packs,...
2017-10-06
13 reads
The docker kill command
When running demos and experimenting with containers I always clear down my environment. It’s good practice to leave a clean...
2017-10-06 (first published: 2017-09-28)
1,573 reads
T-SQL Basics: MERGE Statement
One useful sentence when you need to add data to an existing table from an external source or database, and...
2017-10-06
404 reads
What’s new in SQL Server 2017 presentation
I just uploaded a new presentation called “What’s new in SQL Server 2017”. It covers all the new features in...
2017-10-06
741 reads
Compound FKs with SQL Data Generator
This is a series on SQL Data Generator, covering some interesting scenarios I’ve run into. If you’ve never tried it,...
2017-10-05
1,324 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