Testing as another user–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is one of those things I do…
Blog Posts
Can SQL Ids be used on an instance with Windows Authentication only?
tl;dr; Yes, but. It’s generally considered more secure to have your SQL Server instance set to Windows Authentication and not … Continue reading
CISA Accredited Trainer!
My certification came in! I’m now accredited to provide training for the Certified Information Systems Auditor (CISA) certification. It’s not the Microsoft Certified Trainer (MCT) accreditation I once had…
Correlated Subqueries vs Derived Tables
Correlated subqueries provide an intuitive syntax for writing queries that return related data. However, they often perform poorly due to needing to execute once for every value they join on….
Video – Creating Azure SQL Database
A quick 2 minute upload (with sound, my voice) showing you how easy it is to create an Azure SQL Database using the Azure portal and then using SSMS…
Storytelling Without Data?
There are many great resources out there for data visualization. Some of my favorite data viz people are Storytelling With Data (b|t), Alberto Cairo (b|t), and Andy Kirk (b|t)….
Cool Stuff in Snowflake – Part 8: Time Travel
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to…
Weekly reading #12
It was an Easter Monday yesterday and I thought it was not a good time to prepare a blog post. It was a time to rest with the family…
Speaking at SQL Saturday Raleigh
I am happy to announce that I will be speaking at SQL Saturday Raleigh this Saturday, April 27, 2019. I have been part of the organizing team for this…
Drop It Like It’s Hot (Part 2 of the Rename/Drop Objects Process)
Dread the drop no more! Part 2 of the rename/drop process.
Blogs
CISA Accredited Trainer!
By Brian Kelley
My certification came in! I’m now accredited to provide training for the Certified Information...
Correlated Subqueries vs Derived Tables
By Bert Wagner
Correlated subqueries provide an intuitive syntax for writing queries that return related data. However,...
Video – Creating Azure SQL Database
By Arun Sirpal
A quick 2 minute upload (with sound, my voice) showing you how easy it...
Forums
Can Azure Stack Reduce Software Development Costs?
Comments posted to this topic are about the item Can Azure Stack Reduce Software...
Splitting a multi-dimensional Array in SQL Server 2012
Hello, I have data from an Orders table has the following columns; OrderId (int)...
Ask SSC