David Yard

Microsoft SQL Server Professional

[Bob Ward @bobwardms]

The GA for the Azure SQL Database free offer is here! Learn, develop, or do a POC on Azure SQL for the lifetime of your subscription for now up to 10 databases. https://t.co/a0uYUCLkz1. https://t.co/Hld3SI9kAF #azuresql

[David Yard @SQLYard]

Great day at beginners guide to data integration with Cathrine #PASSDataSummit

[David Yard @SQLYard]

Today I asked the developer did you know you removed the no lock and now we have 10+ deadlocks a day. Response was deadlocks are the preferred method. What’s your comments on that? #sqlhelp

[David Yard @SQLYard]

#sqlsaturday

[David Yard @SQLYard]

Attending pre con Sql Saturday La-SQL Server Performance Tuning with Free Tools by John Sterrett- Great Info

[David Yard @SQLYard]

@jdanton @SqlrUs Thanks Joey

[David Yard @SQLYard]

I’m currently researching how to sync data on prem to azure . Would azure sync be a good candidate? 5TB db. #sqlhelp

[David Yard @SQLYard]

@SqlrUs Migrate the data from on prem to azure data lake

[David Yard @SQLYard]

@AngryPets Thanks for the help

[David Yard @SQLYard]

SQL error logged filled with this today sev17 time out occurred while waiting to optimize the query #sqlhelp anyone experience this?looks about 50 minutes until ended

[David Yard @SQLYard]

@AngryPets Error 8628 that’s it for about 34 minutes thanks

[David Yard @SQLYard]

@PASSDataSummit Thank you it was a great week

[David Yard @SQLYard]

@bobwardms @PASSDataSummit Great session

[David Yard @SQLYard]

@MidnightDBA I’m interested

[David Yard @SQLYard]

Attending #PASSDataCommunitySummit

[David Yard @SQLYard]

#sqlhelp Looking for some suggestions, are network is trying to replace are native backup a solution with Rubrik. Looking for pros and cons if any one has any, thanks

[David Yard @SQLYard]

@jdanton Thanks for the help, we will rebuild that node, we have system dbs on d drive #sqlhelp

[David Yard @SQLYard]

Anyone know using Alwayson in azure with azure node if issues using the D drive when failing over? should D Drive not be used? #sqlhelp

[David Yard @SQLYard]

@jdanton ok thanks, are network told us having the system DB on the d drive is causing the failover process not to work as expected. I was trying to find some documents on this. #sqlhelp

[David Yard @SQLYard]

#SQLHELP Has anyone had this error. I have a case open with Microsoft one month now still waiting ,The Database Engine received a floating point exception from the operating system while processing a user request. SQL 2016 and 2019