Helping people with knowledge

SQL Server Advantages over MYSQL Ultimately, the choice is yours. As a rule of thumb, if you’re developing medium/small-sized applications and predominantly use PHP, go with MySQL.   Whereas, if you’re interested in building large-scale, secure, resilient enterprise applications, SQL Server should be right up your alley. On the surface, there isn’t much to look at when comparing security differences between MySQL and SQL Server. Both are EC2 compliant, which means that you are mostly in safe hands choosing either of the two. Having said that, Microsoft’s shadow also looms large here, as it has equipped SQL Server with proprietary, state-of-the-art security features. A dedicated security tool – Microsoft Baseline Security Analyzer – ensures robust security for the SQL Server. So, if security is a major priority for you, your choice has just been made for you. Native compatibility: You can use either database with both Windows and Linux projects, but MySQL works native...

Setup source code of Visual studio on Bitbucket  Prerequisites:  Download and install  bitbucket extension for Visual studio  from following URL https://marketplace.visualstudio.com/items?itemName=MistyK.VisualStudioBitbucketExtension Download the following software for command-line access of Bitbucket https://git-scm.com/downloads The following are the steps to set up  VS for Bitbucket. 1.        In the file menu, go to the source control options and clear the bindings. You'll specifically want File - Source Control - Advanced - Change Source Control... 2.        You will see the screen as bellow 3.    Now one by one remove connect checkboxes by clicking the unbind button in the top toolbar and at the end press ok.      4.  To tools--> options--> Source Control change current source control plug-in to as following ...

SQL Server database optimization The basic principle of optimization is Benchmarking. It is a process of measuring the performance of a product and eliminate the gaps. If an individual knows their benchmark, then only one can try to achieve that benchmark and further improve the performance. SQL Server database optimization has serval options through which you can optimize the database as well as enhance the response time of the queries. Hello, my name is Fahad and I have 18 years of experience working with SQL server, queries, and optimization of DB. During all my experience, I faced numerous challenges and problems which were regarding  SQL server and query slowness. Hence, in the light of my experience, I am humbly sharing my views on how to optimize SQL Server and SQL queries. The following are my considerations for the optimization of SQL Server. 1.      If you have SQL database installed on C drive along with DB and log ...

KAFKA installation on windows and producer and consumer in .net Kafka® is used for building real-time data pipelines and streaming apps. It is horizontally scalable, fault-tolerant, wicked fast, and runs in production in thousands of companies. Kafka has four core APIs: The  Producer API  allows an application to publish a stream of records to one or more Kafka topics. The  Consumer API  allows an application to subscribe to one or more topics and process the stream of records produced to them. The  Streams API  allows an application to act as a  stream processor , consuming an input stream from one or more topics and producing an output stream to one or more output topics, effectively transforming the input streams to output streams. The  Connector API  allows building and running reusable producers or consumers that connect Kafka topics to existing applications or data systems. For example, a connector to a relational da...