Powershell, when were my servers rebooted?
One of my servers wasn’t rebooted when it should have been and I never realized it until after the outage...
2016-06-01
544 reads
SSMS bug #1
This happens at my instance of SSMS and at the colleagues' one it doesn't. The SQL Server Agent duplicates its...
2016-06-01
237 reads
IT People’s Technical Debt and Reputation Credit
In Canada and USA, when people apply for a credit card or a loan/mortgage, the lending institutions will always do...
2016-06-08 (first published: 2016-06-01)
2,037 reads
PowerShell – Deleting those files
Usually I prefer to use C# to delete files (as part of my retention policy for backups) as a stored...
2016-06-01
187 reads
What is the max/min size of a decimal data type?
Recently, I wrote a maintenance script to check every table in every database on our servers at work nightly and...
2016-05-31
1,189 reads
“Tuesday Morning” SQL Break – May 31, 2016
Yesterday it was Monday, which is when I usually aim to post a weekly blog and twitter round-up. But since I...
2016-05-31
852 reads
Running Multiple Threads Quickly
Recently I was looking to generate a quick workload against an instance. I wanted to add to the amount of...
2016-05-31
1,053 reads
Analyzing David and Goliath datasets on a same chart; Dual Axis in Excel, Power BI and SSRS
[2016-May-31] Two different metrics, two different datasets, one may represent a very high value and the other one is very low....
2016-05-31
1,710 reads
THE SQL Server 2016 NYC Launch Event Schedule
Presenting the OFFICIAL SQL Server 2016 NYC Launch Event Schedule for Thursday, June 2, 2016, just ONE day after the...
2016-05-31
1,981 reads
Precedence Goes to Query Store or Plan Guide?
While presenting at SQLDay in Wroclaw, Poland, on the Query Store, I was asked a pretty simple question, which takes...
2016-05-31
944 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