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

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, 179 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, 307 reads

Posted in Vinay Thakur on 1 April 2016

Index Rebuild VS Reorganize

0 comments, 304 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, 184 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, 334 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, 206 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, 813 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, 550 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, 392 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, 374 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, 423 reads

Posted in Vinay Thakur on 22 February 2014

TempDB Contention 2.1.%

Problem: When you are performing many DML operations and makes tempdb contesnion on it, You may get wait_resource of  2.1.103 check perfomance counter: Temp Tables Creation Rate Temp Tables For Destruction When you are performing many DML operations and makes … Continue reading

Read more

0 comments, 521 reads

Posted in Vinay Thakur on 16 October 2013

Cluster failover fails

you may get an error while trying to failover to another node cluster.   to resolve this issue create an alias on the node with the cluster name and it should work. will blog more on this later.  

Read more

0 comments, 536 reads

Posted in Vinay Thakur on 16 October 2013

LogReader agent failed

You may get an error on log reader agent failed with following error:   Cannot execute as the database principal because the principal “dbo” does not exist, this type of principal cannot be impersonated, or you do not have permission. … Continue reading

Read more

0 comments, 544 reads

Posted in Vinay Thakur on 16 October 2013

Sql Server 2014…….What!!!

Yes, its true. Microsoft vice president has announce  that new version of sql server 2014, will release on 2014… do you think it is possible, as  most of us yet familiar with 2012 …. any way…as MS already clear  that they … Continue reading

Read more

0 comments, 809 reads

Posted in Vinay Thakur on 17 June 2013

Sql server 2012 links

Feature of sqlserver 2012 http://arifudin.com/sql_server_2012_features good alternative to dbcc ind in sqlserver 2012 SYS.DM_DB_DATABASE_PAGE_ALLOCATIONS http://www.jasonstrate.com/2013/04/a-replacement-for-dbcc-ind-in-sql-server-2012/

Read more

0 comments, 712 reads

Posted in Vinay Thakur on 21 May 2013

Good Bye 2012 and welcome 2013

Hey Everyone….. from quite some time I have not written Blogs due to some personal and transiting from my old company … yeah If you read my last year good bye Blog I have indicated about my interest for changing the company took … Continue reading

Read more

0 comments, 498 reads

Posted in Vinay Thakur on 19 January 2013

Denali –Memory : Memory Error Recovery in SQL Server 2012

  Continue on What’s new in Denali and Memory enhancement, come across another great article by SQLCAT and Glenn Berry a new feature of Sql server 2012 in association with windows server 2012 called Memory Error Recovery in SQL Server … Continue reading

Read more

0 comments, 646 reads

Posted in Vinay Thakur on 25 October 2012

DBCC Cleaning CACHE – Memory

DBCC Cleaning CACHE – Memory I wanted to write this blog for quite some time, here you go, as you know at sql everything is on memory, memory information retrieve quickly compare to Disk. So if things are not in … Continue reading

Read more

0 comments, 683 reads

Posted in Vinay Thakur on 6 September 2012

Error: ACCESS DENIED on installation

Error: ACCESS DENIED on installation Generally you would get error on: >> During installation >> when try to start the sql services. >> After installation when try to access instance. You would get “ACCESS DENIED” error. To resolve this issue, … Continue reading

Read more

0 comments, 619 reads

Posted in Vinay Thakur on 5 September 2012

Older posts