Authors

Frank Gill

Frank Gill

Contributions by Frank Gill

Migrating SQL Server Database Mail Settings

This week, I was working on a migration for a client.  The migration was moving databases from a stand-alone instance to a two-node Availability Group.  When it came to moving the Database Mail settings, I discovered they had 21 sets of profiles and accounts.  Not wanting to manually create 42 Database Mail profiles, I set […]

Frank Gill by Frank Gill

Return SQL Server Context Settings from sys.query_context_settings

Today, I attended Erin Stellato’s (b|t) precon session Solving Common Performance Problems Using Query Store. In her presentation, Erin showed that the same query text can return multiple results in Query Store if the context settings for the queries are different. The context settings can be found in the sys.query_context_settings DMV in the set_options column. […]

Frank Gill by Frank Gill

DBCC SHRINKDATABASE Log Space Usage

Yesterday, I was running a health assessment for a client. They are running a weekly maintenance plan that is shrinking all of their data files. After I picked myself up off the floor, I searched the web for “Paul Randal shrink” and hit on Paul’s excellent post Why you should not shrink your data files. […]

Frank Gill by Frank Gill

My SQL Saturday Season Begins

We are nearly a month into the new year and my SQL Saturday season is about to start. I will be presenting Creating an Azure SQL Database Using PowerShell.  This will be my third year in Cleveland and I am looking forward to another great time. You can find more information and register here. SQL […]

Frank Gill by Frank Gill

Monitoring and Alerting for Availability Groups and Why I Love PASS Summit

I have returned from my eighth PASS Summit and, as in years past, they just keep getting better.  I am amazed and humbled that I am a part of the PASS community.  PASS has given me the opportunity to meet and learn from many of the best and brightest in the SQL world.  When I […]

Frank Gill by Frank Gill

Identifying Object Name for CREATE and ALTER Using fn_dblog()

Last week, Jes Borland (b|t) asked me a question about the transaction log. Those of you who have read my blog or seen me present know that this is my favorite SQL Server topic. Jes’s question was: “For a transaction with a Transaction Name of CREATE/ALTER VIEW, can the name of the view affected by […]

Frank Gill by Frank Gill