Database Administration Laerte Junior in Database Administration Automating the Synchronization of RDS SQL Server Agent Jobs in a Multi-AZ Environment Although Azure is the obvious Cloud service to host SQL Server, Amazon Relational Database Service (RDS) for SQL Server is... 27 June 2017 8 min read
Other Dennes Torres in Other SQL 2017 new DMF: Managing VLOGs in our databases SQL Server 2017 brings to us some new interesting DMV’s and DMF’s, one of them is sys.dm_db_log_info. This new DMF... 20 June 2017 4 min read
Database Administration Dennes Torres in Database Administration Parameter Sniffing: Fix It with Query Store Diagnose and fix SQL Server parameter sniffing problems using Query Store. Identify bad plan reuse, compare execution plans, and force... 06 June 2017 25 min read
Other Dennes Torres in Other News for Differential Backup SQL Server 2017 brings several improvements to us. Sometimes a simple new field in a DMV can turn possible interesting... 02 June 2017 4 min read
Other Dennes Torres in Other Simultaneous Auto-growth in Multiple Files SQL Server 2016 has a new configuration to control the auto-growth of multiple files in the same filegroup. When we... 27 May 2017 4 min read
Joshua Feierman Azure Load Balancers and SQL Server Load balancing in Azure has more importance for the DBA, because it is essential for Windows Server Failover Clustering in... 25 April 2017 11 min read
T-SQL Programming Robert Sheldon in T-SQL Programming Questions About SQL Server Collations You Were Too Shy to Ask Of course we all like our colleagues to think that we know everything there is to know about SQL Server... 06 April 2017 29 min read
Joshua Feierman Azure Networking for SQL Server DBAs The network is important to any DBA because so much performance is dependent on I/O, because of the importance of... 27 March 2017 15 min read
Database Administration Joshua Feierman in Database Administration Exploring Azure Storage for SQL Server DBAs – Part 2 Managed Disks have simplified way that Azure storage interacts with the users' virtual machines, thanks to the way that it... 27 February 2017 15 min read
Database Administration Alex Grinberg in Database Administration SQL Server Temporal Tables: Practical Recipes & Examples Practical recipes for SQL Server temporal tables: create system-versioned tables, query historical data with FOR SYSTEM_TIME, manage retention, and implement... 10 February 2017 16 min read
Database Administration Robert Sheldon in Database Administration SQL Server Encryption: Always Encrypted Is 'Always Encrypted' SQL Server 2016's most widely important new feature? It is significant that 'Always Encrypted' in SQL Server... 10 February 2017 26 min read
Database Administration Alex Grinberg in Database Administration Migrating to SQL Server Memory-Optimized Tables: Indexes, Computed Columns, and Triggers Migrate existing SQL Server disk-based tables to memory-optimized (In-Memory OLTP) tables - covering limitations to plan for, new indexing strategy... 26 January 2017 21 min read
T-SQL Programming Robert Sheldon in T-SQL Programming Encrypting SQL Server: Transparent Data Encryption (TDE) Transparent Data Encryption (TDE) encrypts the data within the physical files of the database, the 'data at rest'. Without the... 12 January 2017 16 min read
Database Administration Joshua Feierman in Database Administration Exploring Azure Storage for SQL Server DBAs If you need to run SQL Server in an Azure Virtual Machine, your choice of Azure storage will have a... 04 January 2017 14 min read
Database Administration Enrico van de Laar in Database Administration Query Store with In-Memory OLTP: What Gets Captured for Memory-Optimized Tables and Natively Compiled Procedures How SQL Server Query Store interacts with In-Memory OLTP features - the statistics available for regular queries against memory-optimized tables... 04 January 2017 12 min read
Database Administration Enrico van de Laar in Database Administration Determining What Happens When You Force an Execution Plan via the Query Store When you force a query plan via the Query Store, you will need to track what happens: Sometimes the request... 29 November 2016 12 min read
Database Administration Robert Sheldon in Database Administration Using Power BI Desktop to Visualize SQL Server Metadata You can easily use PowerBI Desktop to show graphically how your database is growing, which tables are taking the most... 16 November 2016 18 min read
Database DevOps Grant Fritchey in Database DevOps SQL Server Database Provisioning Database provisioning for development work isn't always easy. The better that development teams meet business demands for rapid delivery and... 04 November 2016 8 min read
Database Administration Robert Sheldon in Database Administration Retrieving SQL Server Query Execution Plans Execution plans explain all you need to know about query performance, and how to fine-tune. Sure, you can see them... 18 October 2016 26 min read
Database Administration Phil Factor in Database Administration Exporting SQL Server Query Results and Configuration as YAML with PowerShell and SMO Exporting SQL Server query results and configuration data as YAML using PowerShell and SQL Server Management Objects (SMO). Handling XML... 06 October 2016 21 min read
