SQL Server Debugging With RAISERROR Instead Of Print
When testing/debugging TSQL it’s common to use the print statement throughout to see what was happening where in much the...
2018-05-21
671 reads
Blog Posts
SQL Server Debugging With RAISERROR Instead Of Print
When testing/debugging TSQL it’s common to use the print statement throughout to see what was happening where in much the...
2018-05-21
101 reads
SQL Vulnerability Assessment
Vulnerability assessment is probably one of the most underrated new security features in SSMS 17. This feature is not new...
2018-05-21
135 reads
SQLpassion Online Trainings in June 2018
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-05-21
359 reads
Tactics to Find Outdated Statistics in SQL Server
Statistics in SQL Server are used to identify the type of plan that needs to be executed for a query. SQL Server is pretty good in estimating the statistics....
2018-05-21
14 reads
Tactics to Find Outdated Statistics in SQL Server
Statistics in SQL Server are used to identify the type of plan that needs to be executed for a query....
2018-05-21
2,103 reads
What are the system databases?
I get to help with technical interviews every now and again, and one of the questions we always ask is...
2018-05-21
513 reads
Why PASS?
In case this is your first time hearing of it, PASS is the single largest community of Microsoft Data Platform...
2018-05-21
714 reads
C# – Read emails from exchange online mailbox (Office 365) into SQL Server
You have an Office 365 mailbox. You want to use C# to read those mails and save them to SQLServer.
The...
2018-05-20
1,773 reads
SQL Server Error Handling In Depth
TRY/CATCH RAISERROR Pre SQL Server 2012 Since SQL Server 2005 we’ve had TRY CATCH syntax in SQL Server handle errors....
2018-05-20
98 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