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

Normalization & Denormalization

Normalization & Denormalization Someone asked me about this basic thing which we generally do not think much, so realize that should write a short blog on it. Normalization: For any database the way data is stored using different data models … Continue reading

Read more

0 comments, 1,010 reads

Posted in Vinay Thakur on 4 September 2012

RAID (Redundant Array Independent Disk)

RAID (Redundant Array Independent Disk) As disk/storage plays a very important role in any application, everything is saved on disk sql server is no exception. Generally all activity happens on memory as memory is very fast compared to Disk. Earlier … Continue reading

Read more

0 comments, 724 reads

Posted in Vinay Thakur on 17 August 2012

Denali – Memory: “any size” page allocations

I blog introduction to Memory here. Considering you already know memory concept, till sql server 2008 R2, memory management is divided into two parts: BPool – Single page allocation Mem_to_Leave – Multipage allocation. Single page allocation is a 8k page allocated … Continue reading

Read more

0 comments, 804 reads

Posted in Vinay Thakur on 12 July 2012

Different ways to move Sql Server file location

Different ways to move Sql Server file location For space issue on drive , performance load balancing or some other reasons, we may have to move physical file of the database to another location. Following are the different ways to … Continue reading

Read more

0 comments, 863 reads

Posted in Vinay Thakur on 11 July 2012

Download: Consolidated Denali a Day – May 2012

Download: Consolidated Denali a Day – May 2012 If you like what’s New in Denali (Sql server 2012) a day, for the month of May 2012, then I can provide you a consolidated (for all 31 days) blog into a … Continue reading

Read more

0 comments, 718 reads

Posted in Vinay Thakur on 5 June 2012

Denali – Day 31: Discontinue and Breaking/Behavior change features

Denali – Day 31: Discontinue and Breaking/Behavior change features Discontinue Features: As discussed about Deprecated will going to discontinue with that in Denali there are some features which has already discontinued. Means if you try to use those features they … Continue reading

Read more

0 comments, 1,169 reads

Posted in Vinay Thakur on 31 May 2012

Denali – Day 30: Deprecated Features

Denali – Day 30: Deprecated Features Deprecated feature means these features are available in the current version of Sql server but it’s highly possible that would not be available in future version of sql server, so you should plan your … Continue reading

Read more

0 comments, 1,919 reads

Posted in Vinay Thakur on 30 May 2012

Denali – Day 29: Resource Governor Enhancements (Database Engine)

Denali – Day 29: Resource Governor Enhancements (Database Engine) Introduction to Resource Governor: Resource Governor is a feature introduced in sql server 2008. It requires Enterprise and developer edition.   As name implies It controls the resources allocation for users, … Continue reading

Read more

0 comments, 1,280 reads

Posted in Vinay Thakur on 29 May 2012

Denali – Day 28: CDC for ORACLE

Denali – Day 28: CDC for ORACLE Sql server has provided a great features for changes monitoring as Change data Capture Change Tracking http://www.mssqltips.com/tipprint.asp?tip=1819 Change data capture is introduced in 2008 now on Denali it supports for ORACLE database as … Continue reading

Read more

0 comments, 1,083 reads

Posted in Vinay Thakur on 28 May 2012

Denali – Day 27: System Center Advisor (aka ‘Atlanta’)

Denali – Day 27: System Center Advisor (aka ‘Atlanta’) As Microsoft is working more on Cloud base system, on that basis Microsoft has introduced a Tool for sql server called “System Center Advisor – SCA – aka Atlanta. Its internet … Continue reading

Read more

0 comments, 721 reads

Posted in Vinay Thakur on 27 May 2012

Denali – Day 26: Tool: Power View- Reporting Power View (Aka Crescent)

Denali – Day 26: Tool: Power View -Reporting Power View (Aka Crescent)   If you are good with: Xls Pivot table Power point   And you are on administration position to get reports and want to get stats. Power View … Continue reading

Read more

0 comments, 805 reads

Posted in Vinay Thakur on 26 May 2012

Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)

Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)

 

MDS and Best Practice Analyzer new features were introduced in sql server 2008 R2,

System Health Session – Introduced in Sql server 2008

in Denali Microsoft tried to make it improved and stable.

  • MDS (Master Data Services) – Introduced…

Read more

0 comments, 596 reads

Posted in Vinay Thakur on 25 May 2012

Denali – Day 24: True Black Box Recorder – sp_server_diagnostics

Denali – Day 24: True Black Box Recorder – sp_server_diagnostics

 

Earlier sql server was having diagnoses tool.

Default trace.

SQLDiag

And other tools but could not got the one which we can all it as True Black Box Recorder
by “Bob Dorr – Principal SQL Server Escalation Engineer“”…
Read more

0 comments, 1,033 reads

Posted in Vinay Thakur on 24 May 2012

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,106 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, 751 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, 683 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, 784 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, 797 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,494 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, 827 reads

Posted in Vinay Thakur on 17 May 2012

Newer posts

Older posts