I see no SQL Server 2008 Counters in Perfmon?
This problem is a real pain and I’m yet to determine why this issue occurs because my understanding is SQL...
2012-02-21
4,584 reads
This problem is a real pain and I’m yet to determine why this issue occurs because my understanding is SQL...
2012-02-21
4,584 reads
The following trace flags are essential for a variety of recovery scenarios. The use of trace flags allow the DBA...
2012-02-20
1,731 reads
Run the SQL Server Configuration Manager, expand SQL Server Network Configuration and select the protocols for appropriate instance. Double click...
2012-02-18
8,994 reads
To gather statistical information on how a server is performing requires, you need to use operating system tools to gather...
2012-02-16
3,190 reads
Check out my article on SQLServerCentral.com in which I discussed SQL Server 2008 R2 installation setup which you can use to install...
2012-02-14
1,100 reads
Replication often plays an important part in your database management strategy. An organization may use database replication for load balancing,...
2011-12-17
2,251 reads
Microsoft introduced database snapshots with SQL Server 2005. A database snapshot is a static, read-only copy of a source database...
2011-12-17
8,236 reads
As we know xp_fixeddrives can only be use to retrieve normal fixed drives space information. It cannot be used to retrieve information...
2011-12-16
2,009 reads
I’ve started my own SQL blog. Hopefully I’ll write some interesting SQL blog posts here soon.
2011-12-16
530 reads
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
By James Serra
Starting last week is a rollout of the public preview of a new and...
By Stewart "Arturius" Campbell
Comments posted to this topic are about the item Read Only Replica in SQL...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I've had some backups of my encrypted databases failing with the error "BACKUP 'DBName'...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers