One SSMS Trick That Will Make You a Faster Query Builder
Watch this week's video on YouTube
Here's the scenario: you copy and paste some code into a query you are building. A few minutes later you need that same snippet...
2017-07-25
18 reads
Statistics and the Ascending Key Problem
I’ve mentioned previously how not having up to date statistics can cause problems in query performance. This post looks at...
2017-08-09 (first published: 2017-07-25)
7,782 reads
SQL Server Management Studio: Video Tutorial
SQL Server Management Studio is the all in one tool for developers and DBAs alike to work with SQL Server....
2017-07-25
467 reads
Sudden Differential Backup Failures after an Availability Group Failover
As so many stories do, this story starts with a failover - in this case an Availability Group (AG) failover.
https://cdn.meme.am/cache/instances/folder984/400x/59300984.jpg
There were...
2017-07-24
1,608 reads
Geek Sync on Wednesday: Taking Control of Your Organization’s SQL Server Sprawl
This Wednesday, July 26th, at 12 PM EDT, I’ll be giving a presentation through Idera’s Geek Sync series. You will...
2017-07-24
301 reads
FizzBuzz–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-07-24
552 reads
Database Fundamentals #6: Create a Table with the SSMS GUI
The whole idea behind databases is to store information, data, in order to look at it later. The place where...
2017-07-24
544 reads
SQL Summer Vacation–SentryOne
We are having an extra Louisville SQL Server and Power BI User Group meeting this month due to the SQL...
2017-07-24
416 reads
SQL Server on Linux Series: Additional Drives
One of the biggest differences with managing SQL Server Linux is with drive presentation. With Windows, we’d all scream if...
2017-08-09 (first published: 2017-07-24)
1,658 reads
Upcoming SQL Server User Group Presentations
I’ll be speaking at two New England area SQL Server user groups in the next few days! First, tonight I’ll...
2017-07-24
306 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
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers