A Long Trip Ahead
This is my last day at home for a long time. At least long by my standards. I head to...
2015-10-07
569 reads
Blog Posts
A Long Trip Ahead
This is my last day at home for a long time. At least long by my standards. I head to...
2015-10-07
404 reads
Backup Database
One of the most important processes for a DBA is backing up and restoring a database. In its simplest form,...
2015-10-07
264 reads
Do you write ugly T-SQL?
Are your scripts littered with commented blocks of T-SQL code?
select fname,lname
from usertable
where id=1
--and lname like 'smith%'
/*
-- Who knows why...
2015-10-07 (first published: 2015-09-29)
6,377 reads
Exposing Deployed Event Metadata with PoSH
Now that some of the basics concerning how to access Extended Events via PowerShell have been covered, it is appropriate to start digging in a little deeper. This deeper...
2015-10-07
9 reads
Exposing Deployed Event Metadata with PoSH
In the last article I introduced a power tool that can be used to help manage Extended Events. That tool is...
2015-10-07
519 reads
HOW WE CAN GET WHO IS CONNECTED TO DATABASE?
Some time we need to know that who is using database as of now or who all are connected to...
2015-10-07
601 reads
Load Testing Your Storage Subsystem with Diskspd – Part II
In this post we’re going discuss how to implement load testing of your storage subsystem with DiskSpd. We’re going to...
2015-10-07 (first published: 2015-09-29)
7,733 reads
Speaking at SQL Saturday #445 - Raleigh, NC - October 10
I will be speaking this weekend at SQL Saturday #445 - Raleigh, NC. If you are in the area, please come...
2015-10-07
496 reads
TDE and Availability Groups
Caution must be exercised when mixing Transparent Data Encryption (TDE) and Availability Groups to ensure databases don't end up in...
2015-10-07
695 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