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
BI Sanil Mhatre in BI Text Mining and Sentiment Analysis: Oracle Text Oracle has built-in functionality to analyze text. Sanil Mhatre demonstrates how to perform a sentiment analysis on data stored in... 30 August 2021 12 min read
Learn SQL Server Joe Celko in Learn SQL Server A UNIQUE experience A properly designed table must have a key to uniquely identify each row. In this article, Joe Celko explains unique... 23 August 2021 14 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
Performance Fabiano Amorim in Performance SQL Compilations/sec is not what you think it is SQL Server perfmon counters provide a wealth of information about performance. In this article, Fabiano Amorim shows how current wisdom... 29 July 2021 24 min read
Database Administration Greg Larsen in Database Administration Improving performance with instant file initialization Instant file initialization can speed up database creation, file growth, and restores. Greg Larsen explains how to configure it and... 23 July 2021 12 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
Learn SQL Server Priyanka Chouhan in Learn SQL Server SQL Server High Availability and Disaster Recovery Plan Microsoft provides quite a few features for high availability and disaster recovery. In this article, Priya describes the HA/DR options.… 14 July 2021 26 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
Performance Edward Pollack in Performance SQL Server performance monitor data: Introduction and usage Monitoring SQL Server for performance is a critical part of a DBA’s job. In this article, Edward Pollack explains some... 29 June 2021 13 min read
Learn SQL Server Greg Larsen in Learn SQL Server Managing SQL Server transaction log size The SQL Server transaction log must be managed to keep a database running and performing well. In this article, Greg... 29 June 2021 14 min read
Database Administration Robert Sheldon in Database Administration SQL Server and hyperconvergence To be efficient and save money, many organizations are looking at hyperconverged infrastructures for SQL Server. In this article, Robert... 15 June 2021 16 min read
BI Dennes Torres in BI Embed Power BI in Jupyter Notebooks Power BI and Jupyter Notebooks are popular tools, but you may have never thought about using them together. Dennes Torres... 14 June 2021 12 min read
BI Adam Aspin in BI Introduction to generic Power BI themes Formatting Power BI visuals can be tedious. In this article, Adam Aspin explains custom Power BI themes that will save... 11 June 2021 17 min read
Learn SQL Server Greg Larsen in Learn SQL Server SQL Server transaction log architecture The transaction log file for a SQL Server database critical for for maintaining database integrity. In this article, Greg Larsen... 08 June 2021 12 min read
T-SQL Programming Joe Celko in T-SQL Programming Data, N-Tiles & Medians Joe Celko takes a look at how SQL Server can do some of the work for you such as calculating... 01 June 2021 14 min read
Database Administration Robert Sheldon in Database Administration SQL Server performance tuning: Nine best practices SQL Server performance tuning can seem overwhelming when you don’t know where to start. In this article Robert Sheldon explains... 28 May 2021 14 min read
Learn SQL Server Pamela Mooney in Learn SQL Server DBA in training: SQL Server high availability options DBAs must make sure data is highly available, and there are many SQL Server high availability options. Pamela Mooney discusses... 19 May 2021 23 min read
Editorials Kathi Kellenberger in Editorials What is an ad hoc query? Someone recently asked me which queries are ad hoc in SQL Server. An ad hoc query is a single query... 04 May 2021 4 min read
Security Greg Larsen in Security SQL Server security – Providing a security model using user-defined roles Greg Larsen continues his series and shows how user-defined roles roles can control SQL Server security.… 26 April 2021 13 min read
