Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – Webcasts – Resources for IT Managers and their Teams

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Business Intelligence, Data Warehousing, Database, SQL Scripts
Pinal Dave and Jacob Sebastian are both SQL Server MVP are doing webcasts for IT Managers and their Teams. Join us for a 4 series webcast as follows: Part 1: Infrastructure and Resource Management for Business Intelligence – Jan 7 Part 2: BI on your desktop – End to end…
Read More

SQL SERVER – Difference Temp Table and Table Variable – Effect of Transaction

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Transactions
Few days ago I wrote an article on the myth of table variable stored in the memory—it was very well received by the community. Read complete article here: SQL SERVER – Difference TempTable and Table Variable – TempTable in Memory a Myth. Today, I am going to write an article…
Read More

SQL SERVER – Differences in Vulnerability between Oracle and SQL Server

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Business Intelligence, Database, DBA, MySQL, Oracle, SQL Documentation, SQL Download
In the IT world, but not among experienced DBAs, there has been a long-standing myth that the Oracle database platform is more stable and more secure than SQL Server from Microsoft. This is due to a variety of reasons; but in my opinion, the main ones are listed below: A.…
Read More