You’re doing your POC wrong! : T-SQL Tuesday #152
It’s T-SQL Tuesday again! Deborah Melkin (blog|twitter) is our host this month and she’d like to hear our opinion. A ... Continue reading
2022-07-27 (first published: 2022-07-12)
378 reads
SQLStudies
#PowershellBasics: Expanding the column width to avoid truncation
I was recently asked to get a list of all of the services running on one of the boxes we ... Continue reading
2022-07-20 (first published: 2022-07-07)
434 reads
SQL Homework – July 2022 – Update your resume.
Resumes have been on my mind a lot recently. I’ve been thinking that I wish I’d kept mine up to ... Continue reading
2022-07-06 (first published: 2022-07-05)
31 reads
What’s next? Pt 2
Well, it’s only been about a week and a half but here’s an update. First a piece of advice. You ... Continue reading
2022-06-30
94 reads
Creating a Database Audit Specification can create new users & schemas in the background
I love database audits. They are simple, easy to use, effective, not overly resource intensive, and can be turned on ... Continue reading
2022-06-28
26 reads
How do I tell if identity_insert is turned on and if so what table?
TLDR; The code to do this is below but it’s a bit hokey and probably isn’t worth it. It’s pretty ... Continue reading
2022-07-11 (first published: 2022-06-24)
481 reads
What’s next?
As I’m sure a fair number of you already know I was told my position had been eliminated. They are ... Continue reading
2022-06-21
335 reads
Too many coding standards : T-SQL Tuesday #151
One of my favorite people, Malathi Mahadevan (blog|twitter), is our host this month and she’d like to talk about coding ... Continue reading
2022-06-14
80 reads
SQL Homework – June 2022 – SQL Agent Jobs continued.
A few years ago I gave you homework to create a SQL Agent Job and play with it a little ... Continue reading
2022-06-02
21 reads
An auditing mind set
I little while back I presented at Pass Data Community Summit. Specifically the presentation was Auditing your data and data ... Continue reading
2022-06-15 (first published: 2022-05-31)
228 reads
Blogs
SQL Inventory Dashboards: From Raw Data to Real Insight
Tired of inventory headaches? Stock shortages and gluts don't just cause stress; they cost...
Free SQL Practice: 9 Killer Resources to Boost Your Query Skills
So, you want to get your SQL skills razor-sharp without dropping any cash? You're...
DevOps Devour Hour Slides
By Steve Jones
Here are the slides from my talk today at the Redgate NYC Devour Hour:...
Forums
Isolation Level in Azure SQL Database
Hello, Can you please clarify the following: In Azure SQL DB both ALLOW_SNAPSHOT_ISOLATION/READ_COMMITTED_SNAPSHOT are set...
Question of the Day
CONCAT_WS
What output do the queries produce?
SET CONCAT_NULL_YIELDS_NULL ON; SELECT CONCAT_WS ('-', NULL, NULL); SET CONCAT_NULL_YIELDS_NULL OFF; SELECT CONCAT_WS ('-', NULL, NULL);See possible answers