Database Administration Robert Sheldon in Database Administration More SQL Server Features that Time Forgot SQL Server produces some great features, but it would be impossible to get them spot-on target every time. We are... 20 September 2017 14 min read
Laerte Junior Questions About RDS SQL Server That You Were Too Shy to Ask There are a number of different ways that you can host SQL Server. RDS SQL Server, for example, uses SQL... 13 September 2017 12 min read
Dennes Torres How much should you worry about CXPACKET? Several experts already wrote about CXPACKET before, there are plenty of articles about this subject on the internet, so, why... 11 September 2017 3 min read
Database Administration Brent Ozar in Database Administration Six Scary SQL Surprises The working life of the DBA can be punctuated by surprises, but they aren't generally nice surprises. This is especially... 06 September 2017 24 min read
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
Other Dennes Torres in Other 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
Other Dennes Torres in Other 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
Other Dennes Torres in Other 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
Other Dennes Torres in Other 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
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
