sql-server 26
- Microsoft SQL Server Trace Flags
- SQL Server Development Using Free Tools
- SQL Server DateTime Best Practices
- Please stop using this UPSERT anti-pattern
- SQL Calendar Functions
- SQLWATCH
- SQL SERVER – Reduce Deadlock for Important Transactions With Minimum Code Change
- SQL Server Maintenance Solution
- rowversion (Transact-SQL)
- Why You Should Switch in Staging Tables Instead of Renaming Them
- Changing a column from int to bigint, without downtime
- SQL SERVER – SQL Agent – Job Start Whenever the CPUs Become Idle
- dbatools
- EXCEPT and INTERSECT (Transact-SQL)
- STRING_AGG (Transact-SQL
- 5 Performance Optimizations Must Do for TempDB
- Free SQL Server Load Testing Tools
- SQL Server 2016: Implement Column Level Encryption/Decryption
- Supercharge Your SQL Server Scalar Functions By Switching To Table Value Functions
- Powershell One Liners: Get current cpu utilization on all your SQL Servers
- Detect SQL Injection Attacks Using Extended Events and SQL Monitor
- Dates and Times in SQL Server: AT TIME ZONE
- What Were Your Game-Changing Discoveries in SQL?
- Don’t do these things in SQL Server
- SQL: Fastest way to insert new records
- Format Query as JSON