SQL Named Instance – Static Port Overrides with SQL Browser
I ran across an issue that I haven’t seen since SQL 2000 and had almost forgotten about. Let’s do a...
2014-03-03
1,277 reads
Blog Posts
SQL Server Quickie #11 – Non Clustered Indexes
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-03-03
438 reads
SSRS Top N and Bottom N reporting with Duplicates
Previously I wrote a blog on Top N and Bottom N reporting. There were a couple of gotcha I did...
2014-03-03
1,252 reads
Suggestion for SQL Prompt and SQL Test (Red-Gate)
Recently I moved my job on ALM topics, focusing on Source Control Management and Testing, in order to reach Continuous...
2014-03-03
537 reads
Upcoming Conferences: SQLSaturdays in Denmark and Portugal. – Presenting In-Memory OLTP Deep-Dive for Administrators
(de)
Im März und April finden 2 europäischen SQLSaturdays statt, die Potential zu einem Geheimtipp haben:
Am 29. März in Kopenhagen, Dänemark
...
2014-03-03
830 reads
Using SQLFiddle
SQL Fiddle is a free website that you can use to demonstrate and save a query example in any one...
2014-03-03
3,112 reads
Fun in DateTime Calculations
Recently I was working on a task that needs to handle various datetime calculations, and it is really fun.
Usually there...
2014-03-02
732 reads
Browser Based Web Notifications
3 of the 4 major browsers now support web notifications (Safari, Firefox, Chrome) and no where near enough sites are...
2014-03-01
53 reads
Cloning a SQL Server Database
The following script will backup and restore a database to the same server with a different name. Tested on SQL...
2014-03-01
54 reads
Friday Followup For February 28, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-02-28
1,138 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