Migration of SQL Server 2012 Database Mirroring to AlwaysOn Availability group can get a bit tricky if you’re not quite familiar with the workings of SQL Server 2012. This article gives you a better idea about the migration process of database mirroring to AlwaysON Availability group.
Developers – A Fun List of Things Related to Developer
Earlier in the month of December 2013, I have written few articles which were related to the Developer and fun stuff. In those articles I had asked if I have missed anything, which I should have in the article and missed or not. I have got quite a few suggestions…
Read MoreSQL Puzzle – A Quick Fun with Bit Wise Operator – Part 2
This is a follow up, puzzle of SQL Puzzle – A Quick Fun with BitWise Operator. Lots of people really like the earlier puzzle where I have used Bit Wise Operator AND and build a simple puzzle. Today we are going to use another bit wise operator – OR. First execute…
Read MoreSQL Puzzle – A Quick Fun with Bit Wise Operator
It has been a long time since we have puzzle on this blog so let us have a quick puzzle this Friday. It is based on Bit Wise Operator and very simple if you know those operators. We will guess the output of the SQL script. For example, here is…
Read MoreSQL SERVER – Learning SSIS – Where Do I Start? – Notes from the Field #014
[Note from Pinal]: This is a new episode of Notes from the Field series. SQL Server Integration Service (SSIS) is one of the most key essential part of the entire Business Intelligence (BI) story. It is a platform for data integration and workflow applications. As wikipedia says – It features…
Read MoreSQL SERVER – Retrieve All the Data from VARCHAR(MAX) Column
In this blog post we will discuss a very common problem which developer who are working with SQL Server Management Studio and VARCHAR(MAX) Datatype faces. In database table if you have over 8200 characters in a column with datatype VARCHAR (MAX) it is not easy to display them in SSMS.…
Read MoreMySQL – Learning Online MySQL Workbench Guided Tour – Pluralsight Course
MySQL Workbench is the default IDE for MySQL and the most popular IDE among MySQL Developers and Administrator. There are three major sections in MySQL Workbench. 1) Developement – Developer can perform various activities related to SQL development in this area. For example – building queries, executing queries, etc 2)…
Read More
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.