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 Query Store and Parameterization Problems The query store gives us a novel way of identifying those queries that are causing performance problems when they are... 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
Alex Grinberg SQL Server Temporal Tables: How-To Recipes Tables that return the value of the data in the table at a particular point of time have been with... 10 February 2017 15 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 a Disk-Based Table to a Memory-Optimized Table in SQL Server The feature formerly known as Hekaton, now In-Memory OLTP can provide very useful performance gains where you carefully select the... 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
Database Administration Enrico van de Laar in Database Administration Query Store and In-Memory OLTP Once you have Query Store enabled on your databases, runtime statistics are generated for your queries; but what about the... 04 January 2017 11 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
