Showing posts with label sqlserver. Show all posts
Showing posts with label sqlserver. Show all posts

Sunday, 31 July 2016

Difference between renderer and convert

In Extjs everyone has small confusion what is the Difference between renderer and convert.

renderer: renderer is an "Interceptor" method which can be used to transform the data like value, appearence..before it rendered to the browser.

renderer: function (value, metaData, record, rowIndex, colIndex, store, view) {
    // style the cell using the dataIndex of the column
    var headerCt = this.getHeaderContainer(),
        column = headerCt.getHeaderAtIndex(colIndex);

    metaData.tdCls = 'app-' + column.dataIndex;
    return value;
}


It will returns the HTML string.

convert: convert is a function this converts the value provided by the reader into an object that will be stored into the Model.
This function access the rows information inside the store, based on this we can modify the data.



Wednesday, 1 June 2016

Introducing Microsoft SQL Server 2016 – get your free ebook today

Microsoft SQL Server 2016 arrives today and with it comes the opportunity to deliver breakthrough in-memory performance, unparalleled security, end-to-end mobile BI and advanced analytics. We want you to see for yourself why Microsoft is recognized as an industry leader across the data platform, with Gartner Magic Quadrant leadership in Operational DBMS (ahead of Oracle, IBM, and SAP), BI, and Analytics and Data Warehousing.  
Download this free nine-chapter ebook today to learn from expert authors Stacia Varga, Denny Cherry, and Joseph D’Antoni, who describe the features and enhancements that make this release of SQL Server 2016 the best ever:
  • Mission-Critical Performance: Chapters cover faster queries, better security, higher availability, and the improved database engine.
  • Deeper Insights Across Data: Chapters cover the broader data access, increased analytics, and better reporting in SQL Server 2016. 
  • Hyperscale Cloud: Chapters cover the improvements in Azure SQL Database and how to expand your options with SQL Data Warehouse.



Microsoft SQL Server Team

Wednesday, 7 October 2015

SQL Special In-Person Event, Hyderabad, October 10, 2015, Saturday at Microsoft

Location:


Microsoft India PVT LTD
AG-MPR-001 (96) VTC, Building – 3, Survey No 210, Microsoft Campus,
Manikonda Jagir, Gachibowli
Hyderabad, 500032
India

Saturday, October 10, 2015 from 10:00 AM to 1:00 PM (IST)

  



[Note: The event is strictly for working professionals]
[Note: Please note this is an in-person event & absolutely free.]
Session details are as follows:
----------------------------------------
Deadlocks – Everything You Need to Know
Abstract: Come to this session and learn the internals of deadlocks in SQL Server. Why they happen. Different types. Troubleshooting. How to minimize. Best Practices. Deadlock Internals. And much more, everything you want to know about deadlocks. This will be an extended two hour spotlight session with some awesome demos. Well, all SQLMaestros Special In-Person Events are deep-dives and each session is at least two hour of content followed by Q&A.
Speaker Bio: Amit R S Bansal is a Director & Principal Consultant at SQLMaestros.com. He leads the SQL & BI practice with a much focused team providing consulting, training, content development & SQL support services to more than 120+ SQL Server customers globally. A top-rated speaker; he frequently speaks at major events and conferences including Ignite, TechEds, PASS, SQLBits, SSGAS, GIDS, etc. Since 1999, he has worked on countless SQL Server projects, consulted, trained & mentored more than 9000 IT professionals on SQL Server, delivered more than 500 workshops. Amit is the first and the only Microsoft Certified Master of SQL Server in India (outside Microsoft). He is also a Microsoft Most Valuable Professional (MVP) awardee on SQL Server holding the status since 2007.  Also honored as Microsoft Regional Director & founder of SQLServerGeeks.com. To know more, visit www.amitbansal.net
Target Audience: SQL Server Database Administrators, SQL Server Developers, SQL Server Architects
Prerequisites: You need to have at least 1 year of working experience with SQL Server and should know the basics of Indexes. This session is not meant for freshers.
----------------------------------------
Date: 10 October 2015, Saturday
Time: 10.00 am to 1.00 pm
Venue: Microsoft India PVT LTD, AG-MPR-001 (96) VTC, Building – 3, Survey No 210, Microsoft Campus, Manikonda Jagir, Gachibowli, Hyderabad – 500032
(Note: The event will start sharp at 10.00 am. Come by 9.30 am for registration and security formalities. Please be seated by 9.45 am.)
We look forward to your participation. Please forward this to your friends & colleagues to make them aware of the event. Do spread the word for the SQL Community!
Please note this is an in-person event & absolutely free.
Thanks & Regards,
SQLMaestros (www.SQLMaestros.com)
Follow us on Facebook at www.facebook.com/SQLMaestros
Follow us on Twitter at www.twitter.com/SQLMaestros

Note: By registering for this free event, you automatically subscribe to our Newsletter. You are free to unsubscribe in case you do not find our newsletters valuable.
[Note: The event is strictly for working professionals]

Also, did you know about SQL Server Master Classes? - http://www.sqlmaestros.com/sql-server-classes-india/

Sunday, 12 April 2015

Restoring database from .mdf files of SQL SERVER 2012

Today am going to explain today how to restore mdf file into sql server 2012.

Step1:  first we need to save the ,mdf and .ldf file save into the following folder

C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA

Step2: Open the sql server management studio ans select the database then choose attach







Click on Add button, it will open the file dialog box to select the .mdf file.




Wednesday, 5 November 2014

Member mapping specified is not valid.after updating edmx

Updating of Entity Framework Model

face one issue Member mapping specified is not valid after altering the column in the dataBase.








No need to worry about this issue. just Select the affected table in the model. If you observe, there you will find a
column name post fix with an boolean (This behavior is only because of the change in the datatype of that column).

then you have to change datatype in the column and build solution then  it will fix the Issue.


OR

one more method to solve this issue need to delete the table
from the model. update the edmx with add new table build and it will resolve the Error.


 

Wednesday, 29 October 2014

Triggers backup from ssms 2012

Today we will see how to take the back Up of triggers from Database.