SQL Crossword #1
Today we start a new puzzle series, with a crossword puzzle from MVP Kenneth Fisher.
How to Read the Transaction Log File
Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file? Greg Larsen shows you how to browse the transaction log using an undocumented function.
Azure DWH part 12: Permissions, roles, logins and users
In this article we will show some common roles and queries related to Azure SQL Data Warehouse.
Containers for enhanced Data Governance and Compliance
Complex data environments sometimes need new techniques to properly manage the information. See how Windocks can help with containers and SQL Server.
The Basics of Good T-SQL Coding Style – Part 2: Defining Database Objects
Technical debt is a real problem in database development, where corners have been cut in the rush to keep to dates. The result may work but the problems are in the details: such things as inconsistent naming of objects, or of defining columns; sloppy use of data types, archaic syntax or obsolete system functions. With databases, technical debt is even harder to pay back. Robert Sheldon explains how and why you can get it right first time instead.
The Case of the Space at the End
A gripping expose into the deep, dark world of ANSI_PADDING! What could be more exciting?
The Financial DBA
The future of the DBA might include lots of asset tracking and financial meetings.
Testing DML Statements for In-Memory OLTP
Erin Stellato takes a thorough look at the way DML statements might benefit from In-Memory OLTP, especially with natively compiled stored procedures.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers