Impetus The purpose of this blog is to clarify the confusion regarding the behavior of FORMAT function with the time datatype in SQL Server Scenario It all started with a discussion that happened in one of the groups. A person…
SQLServer Tips: Distributed Query Issues With ACE Provider in 64 bit
Here is another quick blog on solution for an issue you may face while working with ACE provider in 64 bit windows server ScenarioA colleague of mine came to me today morning with an issue. He was trying out few…
SQL Server Data Tools BI Installation Issues on Windows 10
This is a short blog to share the details of an issue that you may face while installing SQL Server Data Tools for BI (SSDT-BI) on Windows 10 ScenarioYou’ve a laptop or desktop which you upgraded to Windows 10 recently…
Guest Post: Shrink the SQL Database Log File!
For the first time I’m introducing a guest blogger through this post.Priyanka Chouhan has gladly volunteered to be the guest blogger for us. She has come up with an informative article on shrinking log file which you can read below.…
SSMS Tips: How to Get This Debug Button Away From My Execute Button?
This has been an annoying issue for me many times.The positioning of Debug button so close to Execute button in SQL Editor toolbar has caused me to hit Debug by mistake which would launch the debugger many times when all…
ANSI NULLS Behavioral Difference – Variables vs Literals
ImpetusThe impetus for writing this blog comes from a recent interesting discussion that happened in one of the groups.The topic of discussion was regarding ANSI NULL setting behavior. There is a difference in the way ANSI NULLS setting works while…
In Memory Tables vs Table Variables – Comparison
IntroductionRecently there was a casual discussion with one of my colleagues who was asking me regarding the newly introduced memory-optimized tables in SQL Server 2014. The discussion went through few aspects of memory-optimized tables and their comparison against table variables. This blog…
Implementing Automatically Tidying Up Adhoc Jobs in SQLServer Agent
Business CaseRecently I had an opportunity to inherit a system from a client for doing some enhancements. One of the tasks involved in the project was also to clean up the system which had lots of left overs like unused…
SSMS Table Designer Not Recognizing Rowversion Datatype
This blog is the result of a recent discussion I had with my fellow colleagues. One of my colleagues asked me why rowversion is not recognized as a valid datatype with SQLServer. I was surprised at this statement and told…
T-SQL Tips: Customizing CDC for Oracle Service Implementation in SQLServer
The purpose of this blog is to explain a quick tip which you can implement to customize the default functionality of CDC for Oracle service in SQLServer to help you overcome the limitation posed by the default deployment script. Business…