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…
Denali – Day 24: True Black Box Recorder – sp_server_diagnostics
Earlier sql server was having diagnoses tool.
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
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
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
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.
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
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
OFFSET… Read more
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
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…
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