SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Parallelism setting in SQL Server – reduce CXPACKET waits?

This is one of the hot topic within the DBA community, what should be the best setting for parallelism in your environment? The answer is – it depends! J

Let’s look at what is the default setting and where should we start to tune it. There are two related setting…

Read more

0 comments, 1,084 reads

Posted in on 13 January 2016

Free learning materials

If you are new to a technology, you might want to have a place to get you started. It would be great if can be free and can guide you through from beginner to expert. Microsoft Virtual Academy can be here to help, if you are going learn SQL server,…

Read more

0 comments, 451 reads

Posted in on 2 October 2015

SQL Licensing

Recently, there are lots of questions about SQL licenses, many of them came from the fact that they starting to upgrade to 2012/2014 from their old 2005 servers as they are going to be end of life in 2016. As the major confusion was the changes made in licensing from…

Read more

0 comments, 2,763 reads

Posted in on 30 September 2015

Why do companies need DBA?

Have been asked by few IT pros in the past few weeks about why does a company needs to hire a DBA, many of them are from small to mid-size companies and ranging from IT managers to system admin, more precisely about SQL DBAs.

Normally I used to say in…

Read more

0 comments, 732 reads

Posted in on 7 September 2015