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

Denali – Day 23: Data Quality Services (DQS)

Denali – Day 23: Data Quality Services(DQS)

Data intelligence vs. human intelligence: Sql server RDBMS is a database system which has data in it, most of the time, we enter the data but as a user they enter the data assuming things are good, like “USA, US or America are… Read more

0 comments, 1,120 reads

Posted in Vinay Thakur on 23 May 2012

Denali – Day 22: SQL Server Developer Tools SSDT (Aka “Juneau”)

Denali – Day 22: SQL Server Developer Tools SSDT (Aka “Juneau”)

 

As stated earlier on blog on “LocalDB” discussion, developers are involved in development and has to interact with database, in this case Denali has introduced another tool called “SSDT” a visual studio shell tool for developers… Read more

0 comments, 755 reads

Posted in Vinay Thakur on 22 May 2012

Denali – Day 21: Security

Denali – Day 21: Security

 

Security wise Microsoft sql server is going great and on compare with other RDBMS in the market it has very little flows with regards to Security. It’s a one of the great achievement by sql server.

Contained databases-

As blogged about contained database,… Read more

0 comments, 686 reads

Posted in Vinay Thakur on 21 May 2012

Denali – Day 20: More Programmability Feature

Denali – Day 20: More Programmability Feature

  • Native XML Web Services (SOAP/HTTP endpoints) is Removed:

 

Earlier version of sql server support Web services of End points to connect to sql server, could be due to security reason (my opinion) this has been removed, now you could not able to create… Read more

0 comments, 789 reads

Posted in Vinay Thakur on 20 May 2012

Denali – Day 19: Programmability Feature -T-Sql

Denali – Day 19: Programmability Feature -T-Sql

ORDER BY .. OFFSET and FETCH :mysql LIMIT (srno ):

OFFSET is a location of the rows to be fetched and FETCH is how many number of rows to be fetched. This options should be specified with ORDER BY clause

By default

OFFSET… Read more

0 comments, 802 reads

Posted in Vinay Thakur on 19 May 2012

Denali – Day 18: Engine: Express LocalDB–Command line

Denali – Day 18: Engine: Express LocalDB–Command line

Express LocalDB is an express edition with minimum files required to start sql server for developers to work. This is only for developers assuming they donot have much knowledge of DBA and do not want to know much, they are more focus… Read more

0 comments, 1,507 reads

Posted in Vinay Thakur on 18 May 2012

Denali – Day 17: Distributed Replay

Denali – Day 17: Distributed Replay

Distribution replay a new command prompt utility provided by Denali, this works same as Profiler Reply but has additional features over it.

  • Unlike profiler reply distributed replay also reply the trace but it can be on multiple servers.
  • For reply on profile it takes…

Read more

0 comments, 834 reads

Posted in Vinay Thakur on 17 May 2012

Denali – Day 16: Tool: Database Recovery Advisor –SSMS tool

Denali – Day 16: Tool: Database Recovery Advisor –SSMS tool

As blogged on “Denali – Day 11: SSMS enhancement” about Features added on SSMS, now you can restore a page using SSMS, to add to it SSMS has another tool called “Recovery Adviser” where you could restore database… Read more

0 comments, 579 reads

Posted in Vinay Thakur on 16 May 2012

Denali – Day 15: Support for Windows Server Core

Denali – Day 15: Support for Windows Server Core

 

Windows Server Core: Microsoft Server has so many features which is not required on the server and would never been used, but it exists and sometime cause issue. For this reason Microsoft has introduced an operating system called “CORE” from “windows… Read more

0 comments, 728 reads

Posted in Vinay Thakur on 15 May 2012

Denali – Day 14: New DMV & DMF

Denali – Day 14: New DMV & DMF

 

As there has been so many DMV/DMF already introduced in earlier version of Sql server, Denali does not have much on this part, but 5 new dmv/dmf and 1 modified here most of the stuff is related to OS, below are the… Read more

0 comments, 621 reads

Posted in Vinay Thakur on 14 May 2012

Denali – Day 13: FileTable

Denali – Day 12: FileTable

 

“FileStream” is introduced in sql server 2008, for storing BLOB data like varbinary(max), it is integrated with NTFS file system by creating a separate FileGroup to stored BLOB data, and make it more efficient and stable in sql server”

 

FileTable is a new feature to… Read more

0 comments, 740 reads

Posted in Vinay Thakur on 13 May 2012

Denali – Day 12: More Manageability Features

Denali – Day 12: – More Manageability Features:

  1. -K switch

    With new feature added in an engine to use that feature with different way you may have to add options to use it, as HADRon – AlwaysON feature where secondary server is read-only and active, there is an option -K…

Read more

0 comments, 850 reads

Posted in Vinay Thakur on 12 May 2012

Denali — Day 11: SSMS enhancement

Denali — Day 11: SSMS enhancement

SSMS is a separate tool now, and it has enhanced features on it. This helps developer/DBA to manage the system efficiently.

Like IntelliSense/Debug is introduced in sql server 2008 now in Denali it has improved.

Following are some of the new features added in… Read more

0 comments, 486 reads

Posted in Vinay Thakur on 11 May 2012

Denali — Day 10: Sequence object

Denali – Day 10: Sequence object

Sequence is an object introduced in Denali, this is similar to ORACLE sequence, earlier sql server was having identity column which is associated with particular table but now sequence is a separate object which has sequence values and can be ascending or descending order… Read more

0 comments, 1,014 reads

Posted in Vinay Thakur on 10 May 2012

Denali — Day 9: Additional Scalability Features

Denali – Day 9: Additional Scalability Features

  1. 15,000 Partitions earlier it was 1000

For the enterprise system having huge amount of data to achieve the best performance for huge data developer requires more partition to distribute the data and manage it appropriately, for that Microsoft were introduced partition of data… Read more

0 comments, 359 reads

Posted in Vinay Thakur on 9 May 2012

Denali — Day 8: Startup Parameter

Denali – Day 8: Startup Parameter

Startup Parameters means you are providing the parameter to sql server at the start of sql server, what needs to assign internally, by default you must have to provide following 3 parameters

-d: Specify the location of “Master” database data file.

-l: Specify the… Read more

0 comments, 550 reads

Posted in Vinay Thakur on 8 May 2012

Denali — Day 7: Contained Database

 

Denali – Day 7 : Contained Database

Contained database is another new feature for sql server 2012 – Denali, earlier version has a big issue on logins/users associated with particular database when you want to move the database from one server to another there is a big issue of… Read more

0 comments, 888 reads

Posted in Vinay Thakur on 7 May 2012

Denali — Day 6: indirect Checkpoint

Denali – Day 6: indirect Checkpoint

I have already blog some information about checkpoint here

As I have already blog about Checkpoint and how it works. Generally it works approximately every 1
minute(internal – default) . You could do this on instance specific using EXEC sp_configure recovery…
Read more

0 comments, 1,213 reads

Posted in Vinay Thakur on 6 May 2012

Denali — Day 5: Column-store indexes (aka Project Apollo)

Denali – Day 5: Column-store indexes (aka Project Apollo)

 

There is another great achievement for Denali, especially for Data warehouse, where data is static and very huge – READONLY, and user always require data to be retrieved quickly as possible. So in Denali another great feature called “Column stored”… Read more

0 comments, 676 reads

Posted in Vinay Thakur on 5 May 2012

Denali – Day 4: Editions & Licensing

Denali – Day 4: Editions & Licensing

Editions:

Here is a brief edition summary of Editions available for all sql server from 2005 to 2012.

Sql Server 2005

Sql Server 2008

Sql Server 2008 R2

Sql Server 2012

      Data Center Edition   
Enterprise Edition Enterprise Edition Enterprise Edition Enterprise Edition

Read more

0 comments, 421 reads

Posted in Vinay Thakur on 4 May 2012

Newer posts

Older posts