I can connect to my instance locally but not remotely
Every now and again (today for example) I’ll get a call that one of our SQL Server instances is down. ...
2012-10-23
1,274 reads
Listing server and database roles for all logins and users in SQL Server – Part 3 – Using SSRS Reports to Monitor and Fix security problems
Finally the epic conclusion to my three part series about listing server and database roles. In this post I will...
2012-10-23
684 reads
"malpractice" in IT?
Through most of my career, I believed that at some point I would be able to learn enough and master...
2012-10-23
700 reads
Capture Index Usage Statistics for Better Analysis
Starting with SQL Server 2005, Microsoft introduced Dynamic Management Views to help DBAs see what's going inside of SQL Server....
2012-10-23
2,561 reads
Linked Server setup with Oracle
Linked Server
Setup with Oracle in SQL Server:
Suppose you want to access data from
oracle or other database products using T-SQL via...
2012-10-23
2,277 reads
Parallel Data Warehouse (PDW) Tip: Proof of Concept (POC) Guidelines
As with any other project our objective is to drive PDW POC success! To clear and cultivate the playing field for successful POC engagements, we must, at a minimum,...
2012-10-23
31 reads
Parallel Data Warehouse (PDW) Tip: Proof of Concept (POC) Guidelines
As with any other project our objective is to drive PDW POC success! To clear and cultivate the playing field...
2012-10-23
1,146 reads
Don’t Be That PASS Summit Guy
Don’t Be That PASS Summit Guy
PASS Summit 2012 Speaker
The SQL PASS Summit 2012 is just around the corner. Every year...
2012-10-22
1,211 reads
Trace Flag 2371 and Statistics
One of the issues that I see published often on forums like SQLServerCentral is the advice to update statistics on...
2012-10-22
9,583 reads
What Happened to rowmodctr from Sysindexes?
In my blog series Lost in Translation – Deprecated System Tables, I’ve been going through the compatibility views in SQL Server...
2012-10-22
2,600 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