Opinion Pieces Robert Sheldon in Opinion Pieces The SQL Server Features that Time Forgot Every new release of SQL Server comes with new features that cause a ripple of excitement within the industry: well,... 23 August 2017 12 min read
Blogs Dennes Torres in Blogs Monitoring UnmatchedIndexes Warning If you are using filtered indexes in SQL Server, it worthwhile monitoring the UnmatchedIndexes warning, it can give us very... 07 August 2017 4 min read
Blogs Dennes Torres in Blogs Auto Starting SQL Server Agent I faced this problem some years ago. The company I was working for had a lot of clients with very... 17 July 2017 2 min read
Database Administration Laerte Junior in Database Administration SQL Server High CPU: Investigating the Causes Any DBA who is trying to find the cause of an intermittent problem such as SQL Server high CPU dreams... 17 July 2017 9 min read
Blogs Dennes Torres in Blogs SQL Server 2017: New ‘Queries with high variation’ Graph A few weeks ago I published an interesting article about how to use query store to identify parameterization problems. At... 30 June 2017 3 min read
Blogs Dennes Torres in Blogs New T-SQL Functions in SQL Server 2017 SQL Server 2017 brings us some new T-SQL functions. They are very simple to use, and can also help us... 28 June 2017 5 min read
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
Blogs Dennes Torres in Blogs 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
Blogs Dennes Torres in Blogs 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
Blogs Dennes Torres in Blogs 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 20 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
