SQL Server – How to Search/Query the SQL Server Error Log
Often times I keep checking the error log to make sure if everything is running fine. Here is an undocumented stored...
2013-03-25
416 reads
A Week from Omaha–SQL Saturday #197
Next week I head out to SQL Saturday #197 in Omaha NE. I’m looking forward to it as I’ve never...
2013-03-25
979 reads
Last Weeks Top “Reading” Links #25
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-03-25
1,103 reads
How do I move a SQL login from one server to another without the password?
This is an uncommon task but one that does turn up every once in awhile. A SQL login has to...
2013-04-03 (first published: 2013-03-25)
9,628 reads
Cumulative Update – 10 for SQL Server 2008 Service Pack 3 Is Now Available !
The 10th cumulative update release for SQL Server 2008 Service Pack 3 is now available. Cumulative Update 10 contains all...
2013-03-25
726 reads
Execution Plans in Azure SQL Database
Microsoft has stated pretty clearly that they’re putting code on Azure first, ahead of the desktop. Which makes one wonder...
2013-03-27 (first published: 2013-03-25)
3,645 reads
Implicit Conversions and Avoiding Them With Computed Columns
I recently encountered an interesting performance issue (due to implicit conversions) that I was able to solve using a lesser known technique and I wanted to share it with...
2013-03-25
39 reads
Implicit Conversions and Avoiding Them With Computed Columns
I recently encountered an interesting performance issue (due to implicit conversions) that I was able to solve using a lesser known...
2013-04-02 (first published: 2013-03-25)
3,982 reads
SQL Server – Executing Multiple Script Files Using SQLCMD
There are different options available when you want to execute a .sql script file on a server. You can open...
2013-03-25
9,774 reads
Count Weekdays in MDX
I recently implemented an MDX expression to count the number of weekdays in a given timeframe. This logic is likely...
2013-03-25
2,746 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