Get Rid of These 5 T-SQL Bad Habits with SQL Prompt
We all have bad habits. Maybe we eat too many snacks, spend too much time on the couch watching TV,...
2014-01-21
614 reads
Understanding CXPACKET wait stats in SQL Server
Understanding CXPACKET From the SQL BOL (Books on Line) CXPACKET is defined as Class Exchange Packet and “occurs when trying...
2014-01-21
1,261 reads
Best advice I ever got on negotiating consulting rates and salary negotiations
Back when I was getting ready to take the plunge and begin consulting I sought advice from a friend who...
2014-01-20
799 reads
Schema-only Backups and Restores
I was reading the blog post Time for a Quick Rant by Grant Fritchey (blog|@GFritchey) about people who choose to...
2014-01-20
1,548 reads
Powershell in a Month Day 11 – Filtering
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month...
2014-01-20
1,142 reads
Monitor availability groups and availability replicas status information using T-SQL
Just a quick blog post to share a query, which I wrote to monitor availability groups and replicas and the...
2014-01-20
1,832 reads
Power BI Contest Entry Voting
You’ve watched my video (hopefully) now vote for it! In a previous post I wrote about my Power BI contest...
2014-01-20
705 reads
Counting the Existing, and Missing, Rows
I saw this as a problem recently from someone and thought it would make a good post. As I was...
2014-01-20
736 reads
Assumptions and clusters – the double whammy
I was recently investigating an issue that stemmed from a database being in the recovery_pending state. A quick investigation through...
2014-01-20
849 reads
Last Weeks Top “Reading” Links #67
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-01-20
637 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers