(Rohit Garg) SQL Server Database Mirroring keeps running all time to sync data between Principle & Mirror database. We need regular monitoring of Database Mirroring to ensure that everything is working fine.
Tag: sql server
Changing Your SQL Server Name
(Chris Bell) When the name of the actual host machine’s server name does not match the server name stored in SQL Server a lot of things can start to go wrong.
Tempdb: Checksum or Torn Page Detection (or None)?
(Michelle A. Poolet) Tempdb performance tuning can be an art unto itself. We probably all know the standard stuff:
Get Ready to Learn SQL Server: 17. How to use the Intersect Operator
(Kris Wenzel) All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database. You can get started using these free tools using my Guide Getting Started Using SQL Server.
Playing with the log – Before the first full backup
(Kenneth Fisher) The log file tends to fascinate me. In fact one of my favorite posts is where I looked into the effect of VLF size on shrinking the log. So the other day I was asking about VLFs and got sent to this great video of a recorded session from PASS SQLRally Nordic 2013 by Mikael Wedham (b
Solution : Cannot add new node – Rule ‘SQL Server Database Services feature state’ failed.
(blakhani) While deploying SQL Server 2014 cluster in my lab I ran into this problem when I was trying to add second node (Node 2) to SQL cluster.
SQL Server Video on Reporting Services Trace Logs and PerfMon Counters
(Scott Murray) In addition to the SSRS Execution Log that many SSRS developers and administrators are familiar with, SSRS includes both Trace Logs and SSRS specific Performance Monitor (PerfMon) counters.
A faster CHECKDB – Part III
(Bob Dorr) Bob Ward introduced Part 1 and Part 2 of ‘A faster CHECKDB’ as highlighted in the following links.
SQL Server Enterprise or Standard? A Hands-On Planning Tool to Get it Just Right
(Don Boxley) For my last blog, “Dead Birds in the Storm of a SQL Server Audit: 3 Tips to Keep from Getting Killed on Licensing Costs,” I talked about reducing your overall SQL Server costs by changing your mix of SQL Server Enterprise edition and Software Assurance (SA).
Tips and Tricks: One Query – Multiple Servers – One Result Set
(blakhani) How many times you have been into a situation where you need to run one query across many servers? I have asked his question from one of the DBA and his answer was I will create a linked server and then modify the query to refer linked server. Well this needs modification to server config