Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Future DBA – Hive Big Data 2

In our last blog on Future DBA, we discussed on HADOOP -HDFS system. how as we know HDFS management is quite difficult so with the help of Vendors -Cloudera/Hortonworks/MapR we can integrate the tools/utility in a GUI way and can be … Continue reading

Read more

0 comments, 88 reads

Posted in Vinay Thakur on 27 September 2016

Future DBA – Hadoop Big Data 1

In our last blog on Hadoop Big Data we have discussed about Hadoop and its tools/utility to connect to HDFS. on continue to that hadoop is mostly for big data and the on hadoop is stored in HDFS with named node … Continue reading

Read more

0 comments, 129 reads

Posted in Vinay Thakur on 26 September 2016

Future DBA – Hadoop Big Data

As we discussed on earlier blog that in future its more than SQL-(R)DBMS, as data is growing we have to know BIGDATA as well, and when we talk about BIGDATA we should be aware of HADOOP. I have gone through … Continue reading

Read more

0 comments, 132 reads

Posted in Vinay Thakur on 21 September 2016

Operational Analytics -SQL Server 2016

What is Operational Analytics:- Operational Analytics is a combination of two words “Operational” and “Analytics”. so your OLTP system is a operational system where day to day task eg order table keeps on updating. and Analytics is a OLAP where analysis … Continue reading

Read more

0 comments, 111 reads

Posted in Vinay Thakur on 20 September 2016

Distributed AG

going though Allan Hirt’s 24 SQLPASS  recording, he has explained the new feature of SQL Server Availability group you can get it here. http://www.sqlpass.org/24hours/2016/summitpreview/Sessions.aspx he is expert in Clustering /AG/ and published several blogs and books. Distributed AG is advance and extended … Continue reading

Read more

0 comments, 110 reads

Posted in Vinay Thakur on 19 September 2016

Future DBA part 2

I do not say you should be expert in other technologies but you should be aware of what it is and whats the purpose and whats its characteristics and basics. when we talk of RDBMS (DBMS) like SQL most of … Continue reading

Read more

0 comments, 129 reads

Posted in Vinay Thakur on 15 September 2016

Future DBA Part 1

As I stated in my earlier blog on future DBA, we should learn many things as we can to be stand strong in the market.. Being DBA from last around 15 Years. and still learning… so cool. So far I … Continue reading

Read more

0 comments, 193 reads

Posted in Vinay Thakur on 14 September 2016

World is changing so DBA should

I was going through SQLPASS recording and on first time I could see a session as “MongoDB for the SQL Server Professional” which make me think that even community is also realizing that things are changing and DBA has to be … Continue reading

Read more

0 comments, 123 reads

Posted in Vinay Thakur on 13 September 2016

24 Hours of SQLPASS

Like every years before PASS summit, this years also SQLpass has 24 hrs sessions… it has great sessions every time, and this time as well. During this 24 hrs SQLPASS invites 24 expertise to present a audio session for an … Continue reading

Read more

0 comments, 121 reads

Posted in Vinay Thakur on 12 September 2016

SQL 2016-Always Encrypted

As you know this has been introduced in sql server 2016, I am not going in details on it but would like to highlights some points which I learned today: YOU WILL NEVER GET/READ THE REAL DATA FROM “SQL SERVER … Continue reading

Read more

0 comments, 192 reads

Posted in Vinay Thakur on 7 May 2016

SQL Server 2016 …whats new…WOW!!!

Hey there…. I wrote on SQL Server 2016 in my earlier blog Lets See and Whats new, during that time I knew that SQL Server 2016 will be good. but when I explore and see it now looks like it is a REVOLUTION for … Continue reading

Read more

0 comments, 331 reads

Posted in Vinay Thakur on 1 April 2016

Index Rebuild VS Reorganize

0 comments, 324 reads

Posted in Vinay Thakur on 11 January 2016

SQL Server 2016 – whats new…lets see

Hey friends. I am here again with what’s new blog … Things are changing quite frequently and requirement is also changing. To fulfill the requirement system has to catch-up to the mark. As you know it’s a BI world and … Continue reading

Read more

0 comments, 199 reads

Posted in Vinay Thakur on 11 January 2016

Installation SQL Server 2016

Here is some of the installation processes(https://thakurvinay.wordpress.com/category/installation/) Below is very nice step-by -step installation  process for SQL Server 2016: http://www.databasejournal.com/features/mssql/installing-sql-server-2016.html

Read more

0 comments, 358 reads

Posted in Vinay Thakur on 15 December 2015

log reader uses single CPU

For replication even if you have multi core CPU it uses only one as log reader agent has single threaded operation it will use only one threaded only.

Read more

0 comments, 220 reads

Posted in Vinay Thakur on 9 October 2015

Whats new in SQL Server 2016

While learning SQL Server 2014. looks like we need to swing on it as SQL Server 2016 is coming with great new advance features and stable SQL Server(just like after 2005 to SQL Server 2008). To learn more about SQL … Continue reading

Read more

0 comments, 846 reads

Posted in Vinay Thakur on 31 July 2015

hey its time for 2016!!!

Hi all Yeah its true microsoft announced SQL server 2016 and CP2 has been released to public also we can read books online for it. http://www.microsoft.com/en-us/server-cloud/products/sql-server-2016/default.aspx First blog from mobile …..happy leaning…    

Read more

0 comments, 582 reads

Posted in Vinay Thakur on 29 May 2015

Whats New 2014

Hey all, Continue to my whats New series,  I am going through its new features and the more I am reading it impresses me a lot. and I am feeling that this is it. I really like it. Other what’s new … Continue reading

Read more

0 comments, 409 reads

Posted in Vinay Thakur on 19 December 2014

Re-initialize replication not working

For someone re-initialization is very simple, just go to publisher and right click and select re-initiallize and it will ask for- do you want to generate snapshot now, if you say “yes” it will create a metadata of the articles … Continue reading

Read more

1 comments, 384 reads

Posted in Vinay Thakur on 22 February 2014

Sql Cluster Resource not comming online

when you check on the sql server services and sql agent services it’s getting started on windows cluster but on cluster its going down again. on error log you may get the cluster service Login failed for user ‘cluster service … Continue reading

Read more

0 comments, 444 reads

Posted in Vinay Thakur on 22 February 2014

Older posts