Join Microsoft's Rohan Kumar, and a full team of Azure SQL experts, for Innovate Today with Azure SQL. This free digital event from Microsoft lets you choose the sessions and technical demos that are most interesting to you and focus on the capabilities and possibilities that you want to learn more about.
Oracle sequences can be used to create artificial IDs for a table. In this article, Jonathan Lewis explains how they work under-the-hood.
In Part 1 of this series, we examine the structure of data pages and how your tables are stored on these pages.
Learn how to export data from SQL Server into Excel and programmatically add new columns to the spreadsheet using C#.
Redgate has committed to organizing a free virtual Summit for the PASS Community this fall. To help guide the format and provide you and the data platform community with the best virtual event experience possible, we'd appreciate your input. As a thank you for your feedback you could win a Peloton Bike or $3,000 (the equivalent in your local currency) to donate to your chosen charity.
Companies are starting to bring people back to the office. Microsoft has announced their policy, and Steve wonders if more will follow.
When we don't have all the information needed to model data, we often use NULL. However, that causes other issues.
Join Microsoft's Rohan Kumar, and a full team of Azure SQL experts, for Innovate Today with Azure SQL. This free digital event from Microsoft lets you choose the sessions and technical demos that are most interesting to you and focus on the capabilities and possibilities that you want to learn more about.
Out-of-control tempdb growth must be managed to keep the server running. Monica Rathbun gives her strategy to handle unexpected tempdb growth.
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Hello, I think I need a recursive cte query but unsure of the logic....
Comments posted to this topic are about the item The Security of Old Tech
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers