Learn SQL Server Greg Larsen in Learn SQL Server Working with SQL Server identity columns SQL Server identity columns are easy to add to a table, but you must understand how they work to use... 24 September 2021 12 min read
PowerShell Greg Moore in PowerShell Building an ETL with PowerShell There are many ways to load data into a SQL Server database. In this article, Greg Moore demonstrates how to... 22 September 2021 11 min read
Editorials Kathi Kellenberger in Editorials The challenges of ever-growing estates Each year Redgate runs a survey to determine the state of database monitoring. This year, instead of one large report,... 21 September 2021 3 min read
Database Administration Edward Pollack in Database Administration SQL Server Extended Events: Creating Sessions, Events, Actions, Filters, and Targets Build a SQL Server Extended Events session from the ground up - choosing events, attaching actions, applying filters, selecting targets... 14 September 2021 15 min read
T-SQL Programming Kathi Kellenberger in T-SQL Programming LAG in SQL Server: Performance vs Self-Join, CTE, APPLY, and Cursors Benchmarked Benchmarked comparison of the SQL Server LAG function against eight alternative techniques for including a column from a previous row:... 07 September 2021 13 min read
Editorials Devyani Borade in Editorials Lessons learned from achieving a certification I recently became a certified Professional Scrum Product Owner (PSPO). As of today, there are less than 110,400 of us... 03 September 2021 6 min read
Azure Robert Sheldon in Azure The Azure SQL portfolio Microsoft provides many ways to run SQL Server in Azure, but which do you choose? In this article, Robert Sheldon... 01 September 2021 14 min read
Editorials Kathi Kellenberger in Editorials Machine learning, both exciting and scary The 2002 movie Minority Report is about a police unit called PreCrime, which can predict when people will commit a... 25 August 2021 2 min read
Learn SQL Server Greg Larsen in Learn SQL Server SQL Server identity column The SQL Server identity column is used to populate a column with incrementing numbers on insert. In this article, Greg... 23 August 2021 13 min read
Oracle Jonathan Lewis in Oracle Oracle sequences – 12c features including “identity” Oracle added several enhancements to the sequence object in version 12c, including an “identity” column feature. Jonathan Lewis explains how... 19 August 2021 16 min read
Database DevOps Robert Sheldon in Database DevOps Sharing knowledge in communities of practice Communities of practice bring people together to share ideas and learn from each other about a common interest. In this... 16 August 2021 12 min read
Editorials Devyani Borade in Editorials Negative Feedback: What is it exactly? I am trying so hard not to roll my eyes right now. I re-read the sentence. “Cherish criticism instead of... 11 August 2021 5 min read
Performance Fabiano Amorim in Performance SQL Compilations/sec: What This Metric Really Means Why the standard SQL Compilations/sec guideline is misleading for ad hoc workloads. Covers plan cache behavior, auto-parameterization, forced parameterization, and... 29 July 2021 25 min read
Editorials Brett Newski in Editorials Appreciating tiny victories No one is good at something right when they start. When starting something new, it’s normal to feel terrified or... 29 July 2021 3 min read
Azure Dennes Torres in Azure How to query private blob storage with SQL and Azure Synapse Azure storage can be marked Private to control access. Dennes Torres explains how to query private blob storage with SQL... 21 July 2021 17 min read
.NET Lance Talbert in .NET Using post-processing effects in Unity Changing the UI in games makes the games more fun to play. Lance Talbert demonstrates how to use post-processing effects... 20 July 2021 15 min read
Performance Edward Pollack in Performance Collecting SQL Server performance monitor data SQL Server provides information for troubleshooting performance. Ed Pollack demonstrates collecting SQL Server performance monitor data.… 20 July 2021 20 min read
Oracle Jonathan Lewis in Oracle Typical uses of Oracle sequences Oracle sequences supply unique numbers that can be used when populating tables. In this article, Jonathan Lewis explains the typical... 14 July 2021 17 min read
Editorials Kathi Kellenberger in Editorials How to learn about Azure SQL It was always important to me to keep up with the latest versions of SQL Server, but especially so when... 09 July 2021 3 min read
Learn SQL Server Robert Sheldon in Learn SQL Server How to enable SQL Server trace flags DBAs can control many aspects of SQL Server’s behavior with trace flags. In this article, Robert Sheldon explains how to... 07 July 2021 14 min read
