The Side Project
When I first started working as a technologist some 17 years ago, I was doing fairly low-level stuff: moving and...
2017-01-11 (first published: 2017-01-04)
1,362 reads
Tim Mitchell
ETL Error Handling
In designing a proper ETL architecture, there are two key questions that must be answered. The first is, “What should...
2016-12-28
768 reads
Survey Results: Skipping the Holidays
Last week I posted a brief survey about working the holiday. To those who normally are not required to work...
2016-12-27
386 reads
Survey: Skipping the Holidays?
For a little pre-holiday fun, I’ve got a simple scenario to present to you, and I am interested in your...
2016-12-23
378 reads
SSIS Custom Logging Levels
In my ongoing series on ETL best practices, I recently wrote about the importance of logging in extract-transform-load processes. For...
2016-12-22
482 reads
KPIs in SSRS 2016
Key performance indicators, or KPIs, are at-a-glance metrics for simple insight into the business. These are each designed to provide...
2016-12-30 (first published: 2016-12-22)
1,747 reads
Report Portal in SSRS 2016
SQL Server Reporting Services benefits from a major update in SQL Server 2016, which is obvious from the first interaction...
2016-12-20
573 reads
The Trails We Leave
Over the weekend I got an email from have i been pwned, a website that tracks data breaches and notifies...
2016-12-19
349 reads
SSRS 2016: Great and Getting Better
Although I’ve been a regular user of SQL Server Reporting Services since it was released in the mid-2000s, I’ve done...
2016-12-18
414 reads
SSIS Execution Status Lookup
The SSIS catalog comes packaged with a rich set of built-in reports that give those monitoring Integration Services a window...
2016-12-17
420 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