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

Learning – Webcasts/Video

Learning for this week. http://www.pass.org/24hours/2017/security/Schedule.aspxhttp://sqlblog.com/blogs/damian_widera/archive/2017/04/20/sql-server-2017-all-sessions-from-microsoft-data-amp-are-online-complete-list-of-links.aspx http://sqlblog.com/blogs/davide_mauri/archive/2017/05/01/pass-appdev-recording-building-rest-api-with-sql-server-using-json-functions.aspx http://sqlblog.com/blogs/sergio_govoni/archive/2017/04/15/pass-business-analytics-marathon-march-2017-recordings-available.aspx http://sqlblog.com/blogs/andy_leonard/archive/2017/03/31/the-recording-for-biml-in-the-enterprise-data-integration-lifecycle-is-available.aspx http://sqlblog.com/blogs/andy_leonard/archive/2017/03/14/the-recording-for-the-ssis-catalog-compare-version-2-launch-event-is-available.aspx  

Read more

0 comments, 137 reads

Posted in Vinay Thakur on 21 May 2017

Azure CosmosDB SQL Server

As you know Microsoft has retrieve the data from Hadoop with by polybase and extended the R language to External language(R and Phython). now Microsoft is wanted to make sure that it has feasibility for all the environment whichever is available … Continue reading

Read more

0 comments, 191 reads

Posted in Vinay Thakur on 21 May 2017

Vnext – Its SQL Server 2017

Yes thats true, SQL Server New version will be release this year and call it “SQL Server 2017” where sql can also work on Windows, MacOS and Linux     https://blogs.technet.microsoft.com/dataplatforminsider/2017/04/19/sql-server-2017-community-technology-preview-2-0-now-available/ Cooooool.

Read more

0 comments, 189 reads

Posted in Vinay Thakur on 24 April 2017

vNext has AG

Now vNext SQL Server on Linux supports Availability Group HA/DR functionality supported.   https://blogs.technet.microsoft.com/dataplatforminsider/2017/02/17/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups/    

Read more

0 comments, 133 reads

Posted in Vinay Thakur on 23 March 2017

SQL Agent on vNext – Linux

SQL Server is running on Linux now with SQLPAL- SQL Platform Abstraction Layer(SQLPAL) -it will work as a virtual Windows server on Linux so I think now Microsoft should able to include things which we are doing on Windows Server. on that … Continue reading

Read more

0 comments, 165 reads

Posted in Vinay Thakur on 23 March 2017

SQL Server on Linux

Yes that is true, now SQL Server is on Linux. https://www.microsoft.com/en-in/sql-server/sql-server-vnext-including-Linux Download the public preview https://docs.microsoft.com/en-us/sql/linux/ I am learning it and would love to write more blogs soon.    

Read more

0 comments, 274 reads

Posted in Vinay Thakur on 4 February 2017

Future DBA – Big Data -MongoDB 2

In our earlier blog we discussed an introduction to MongoDB. so, how is MongoDB is into BigData, MongoDB has a concept called sharding with replication, so here using sharding it uses a cluster like configuration and data will be load-balance- equally … Continue reading

Read more

0 comments, 281 reads

Posted in Vinay Thakur on 4 October 2016

Future DBA – Big Data -MongoDB 1

We have discussed hadoop and its HDFS management tools for big data system, which works horizontal scaling for data distribution and can be used for data warehousing. can manage big data/heavy data There is another BIG Data system called MongoDB, … Continue reading

Read more

0 comments, 265 reads

Posted in Vinay Thakur on 3 October 2016

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, 236 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, 314 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, 249 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, 229 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, 216 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, 226 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, 313 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, 226 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, 215 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, 297 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, 483 reads

Posted in Vinay Thakur on 1 April 2016

Index Rebuild VS Reorganize

0 comments, 414 reads

Posted in Vinay Thakur on 11 January 2016

Older posts