SQL Server Logical Query Processing
Recently, while reviewing one of the stored procedure performance, I suggested a couple of changes to a developer to improve...
2018-04-12
19,934 reads
Professional and Proficient PowerShell: From Writing Scripts to Developing Solutions at PASS Summit
PASS Summit is the largest conference for technical professionals who leverage the Microsoft Data Platform. PASS Summit 2018 is happening November...
2018-04-11
315 reads
Contextual View
In this post I describe technique of presenting data that is context specific - for example, data that will be changing...
2018-04-11
1,189 reads
DBA Fundamentals–Tuesday 11 Central–Execution Plans
WHAT: EXECUTION PLANS FOR BEGINNERS
WHEN: Tuesday, 04/17/18 - 11:00 am – 12:00 pm
WHO: Thomas LeBlanc
WHERE: https://attendee.gotowebinar.com/register/7086336336602188044
This will be a Beginners session highlighting...
2018-04-11
600 reads
Trekking Through Formatting Forest on the #SQLPrompt Treasure Map
I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes...
2018-04-11
1,593 reads
Dates and Times in SQL Server: the science of time
Now that we have covered the various date and time data types (see the post from last time) in SQL...
2018-04-11
871 reads
Checking for temporary table existence
Database Code Smells
I was recently reviewing a newly created T-SQL stored procedure. This procedure was verifying temporary table existence with...
2018-04-11
2,445 reads
Cost savings of the cloud
I often hear people say moving to the cloud does not save money, but frequently they don’t take into account...
2018-04-11
172 reads
Cost savings of the cloud
I often hear people say moving to the cloud does not save money, but frequently they don’t take into account...
2018-04-11
1,019 reads
Privacy and Protection, By Design
With all the noise about the upcoming enforcement of GDPR, I know that people are starting to focus more on...
2018-04-11
452 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