DevSpace is an annual developer’s conference that takes place in Huntsville, Alabama. DevSpace offers talks on a variety of languages, offering attendees the ability to improve their skills within their daily technology of choice and the ability to become familiar with new technologies.
When a column is wrapped around in a function call in the WHERE clause, the query processing speed can be extremely low because of the potential resultant scan operation. We should avoid using functions on columns in predicate. Especially on large tables, it can create a noticeable performance overhead by preventing the Query Optimizer to use available indexes.
Couple of days back on 10th October, the Microsoft SQL Server Team announced the release of the next version of SQL Server Management Studio 17.3. I downloaded the latest version and started playing around with the new features. One thing which I was interested to check out was the new ‘Import Flat File’ wizard which promises to improve/simplify the import experience of flat files to SQL Server.
Last weekend I attended the Microsoft Community Connection event at the Microsoft Office in Charlotte, NC. It is primarily an event for MVPs, RDs, few Microsoft Employees and Community Influencers to get together and connect with each other. I was lucky enough to get a chance to participate in this event as a Community Influencer.
SonarQube is a great tool for identifying anti-patterns in your code base and help you improve Code Quality. However while installing the tool, you might come across a number of issues. In this article, I have explained issues which I encountered while configuring my SQL Server database instance and the resolution.
The Gulf Coast Code Camp is a free one-day code camp being held at the University of South Alabama, Mobile, Alabama. This will be Mobile’s largest technical event in 2017 and a great networking opportunity. There will be quality talks on Web Development, Cloud Technologies, DevOps, Database, Front end technologies and more. If this interests you, make sure you register and also help spread the word in social media.
I started seeing a weird issue while working in Visual Studio 2017 few days back. I was not able to attach to running processes with the Visual Studio debugger. The IDE used to freeze/hung each time I tried to do so. The ‘Attach to Process’ window used to come up but it was blank and all I saw was the spinner – eventually the screen became unresponsive after some time.