Webcast “Performance Impacts of User Defined Functions” This Week with Pragmatic Works
Functions might seem to be the answer to all of your desires to consolidate code, and at times they could...
2013-02-25
659 reads
SQL Server Discovery Report
How can I check what all SQL server features and version are installed on my Machine ?
It’s a frequently asked...
2013-02-25
1,573 reads
A Learning Experiment at SQL Saturday #187– Richmond
In a little over a week, SQL Saturday #187 takes place in Richmond, VA. I’m looking forward to going back...
2013-02-27 (first published: 2013-02-25)
1,152 reads
Benchmark SQL Server Disk Latency
Typically, I am a big advocate of performance monitor but one place I commonly see performance monitor being misused is with benchmarking...
2013-03-06 (first published: 2013-02-25)
4,530 reads
Last Weeks Top 10 “Reading” Links #21
Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet....
2013-02-25
1,007 reads
A Month of PowerShell – Day 25 (Integrity Checks)
Welcome to Day 25 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-03-07 (first published: 2013-02-25)
2,317 reads
SQL Saturday #187 Richmond And More
In just a couple of weeks I’ll be flying down to Richmond, VA to speak at SQL Saturday #187. I’ll...
2013-02-25
891 reads
DROP and CREATE vs ALTER
When writing a script to change a piece of code, say a stored procedure or view, there are 3 basic...
2013-03-05 (first published: 2013-02-25)
5,162 reads
Building My Next Workstation–Part 2
Building a computer, at least in the beginning, feels like something you have to do holistically and at the same...
2013-02-25
1,265 reads
SQL BLOG: Calculating total number of days from 1st Jan without using DATEDIFF function
Below script will calculate total number of days based on the input from user from 1st Jan. Though we have...
2013-02-25
902 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers