Thank You–#PASSElections
This week has been a whirlwind; as the results came in earlier this week on the election I wanted to...
2017-09-28
537 reads
Blog Posts
Compañero Conference and SQL Modernization Roadshow
October is a busy month for me. I am flying all over the US and Canada for speaking engagements to...
2017-09-27
553 reads
Concatenation Truncation – Are your strings being truncated?
It wasn’t until recently that i paid attention to truncation during concatenation, but that’s because whenever I used concatenation before...
2017-09-27
1,218 reads
Error – Unable to retrieve child resources in Azure Storage Explorer
Hello friends, Please find the link of this article here – https://social.technet.microsoft.com/wiki/contents/articles/40188.error-unable-to-retrieve-child-resources-in-azure-storage-explorer.aspx
2017-09-27
880 reads
Hmmm… What’s This?
OK So, I am doing some digging and peaking around again in SQL Server and came across a database option...
2017-09-27 (first published: 2017-09-20)
2,048 reads
SQL Puzzle – Prime Numbers
My goal here is to have something fun (and hopefully educational/thinky) (and yes, I did just make up the word...
2017-09-27
462 reads
TSQL2sDay – Get-PostRoundup
First an apology, this round up is late!
The reason for that is an error in the PowerShell testing module Pester...
2017-09-27 (first published: 2017-09-20)
1,069 reads
Clustered vs Nonclustered: Index Fundamentals You Need To Know
Photo by Patrick Tomasso on UnsplashHow many times have you known that adding an index would improve query performance but you weren’t exactly sure which type of...
2017-09-26
1,759 reads
Clustered vs Nonclustered: Index Fundamentals You Need To Know
Photo by Patrick Tomasso on Unsplash
How many times have you known that adding an index would improve query performance but you weren't exactly sure which type of index to add?
This happened to me all the time...
2017-09-26
8 reads
DELETE data on SQL Server HEAP table - Did you know...
Before I complete my question let me provide context.
I’ve received an alert saying that a specific database could not allocate a new page (disk was full)
The message that you...
2017-09-26
12 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