ApexSQL Refactor is a free SQL Server Management Studio and Visual Studio add-in for database refactoring and SQL code formatting. ApexSQL Refactor has 11 databases and SQL code refactors including:
MySQL – Locate the Configuration File – my.ini or my.cnf on Windows Platform
Since the release of my MySQL course on Performance Tuning and Optimization, I have received quite a few questions on MySQL. The top most questions which I have received is how to find my.ini or my.cnf file on Windows Platform. This is a fantastic question and I can understand the…
Read More
SQL SERVER – Start Services or Stop Services with PowerShell – Answer to Question
You can check out the original post here: SQL SERVER – Start Services or Stop Services with PowerShell – Question to Readers?.
SQL SERVER – Start Services or Stop Services with PowerShell – Question to Readers?
Recently I received a very interesting question- I have no idea about its answer so I will request your help to answer this question.
Question:
“I am using a Powershell script to shutdown SQL Services. Here is the command I use.
Developers – Seven Foods Developers Love
I am a developer and I have certain food choices. When I look around, I see many more developers and interestingly enough, I have noticed their eating habits very closely. It seems that all the developer has similar taste in food. Here is a quick list of the food which…
Read More
MySQL – MySQL Query Optimization and Performance Tuning – Online Video Courses
In year 2013, I had focused on MySQL along with SQL Server in database products. As I learn more and more MySQL, I quickly realized that there is no proper course or structured information for MySQL Performance Tuning. I had decided to build a course around common MySQL Performance Problems. I have decided to build the performance tuning course in two parts. 1) MySQL Indexing for Performance and 2) MySQL Query Optimization and Performance Tuning. I had released MySQL Indexing for Performance course earlier this year and right before the end of the year 2013 the second course MySQL Query Optimization and Performance Tuning has released as well.
SQL SERVER – Tools for Proactive DBAs – Central Management Server – Notes from the Field #009
[Note from Pinal]: This is a ninth episode of Notes from the Fields series. If you are DBA and Developer there is always a situation when you want to execute the same query on multiple servers. This can work out very well if you have a servers in single digit,…
Read More
SQLAuthority News – Happy New Year 2014 – Resolution of the New Years
First of all, happy New Year to all of you – 2014 has started! Every year I make at least one resolution, some I do for the public on my blog. The reason is simple – if I declare something in front of all of you, there is a good…
Read MoreDevelopers – Top Ten Influential Movies for Developers – Add Your Favourite
Today is Dec 31st and last day of the year. I suggest everyone should go out and meet friends & family. At least everyone should spend their time with people they like and have fun with. In past many times, I have gone out to a new years party, however,…
Read More
SQL SERVER – MySQL – LIMIT and OFFSET – Skip and Return Only Next Few Rows – Paging Solution
Working with MySQL and SQL Server together has its own sets of fun. Here is one example how you can implement paging in MySQL or SQL Server. Both of them have LIMIT and OFFSET mechanism. You can Skip few rows and return few rows from the sorted result set with the help of OFFSET keywords. Let us see how we can do that quickly in the both of the database. We will use AdventureWorks sample database for SQL Server and sakila sample database for MySQL.