SQL Tips and Tricks Archives - Page 195 of 536 - SQL Authority with Pinal Dave

MySQL – Locate the Configuration File – my.ini or my.cnf on Windows Platform

January 7, 2014

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…

SQL SERVER – Start Services or Stop Services with PowerShell – Answer to Question

January 6, 2014

Pinal Dave

SQL Tips and Tricks

Powershell, SQL Server Services

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?

January 5, 2014

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

Powershell, SQL Server

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

January 4, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Humor

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…

SQL SERVER – Tools for Proactive DBAs – Central Management Server – Notes from the Field #009

January 2, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore

[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,…

SQLAuthority News – Happy New Year 2014 – Resolution of the New Years

January 1, 2014

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

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…

Developers – Top Ten Influential Movies for Developers – Add Your Favourite

December 31, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Professional Development, SQL Humor

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,…