1,007 reputation
617
bio website linkedin.com/in/briandknight
location Glen Allen, VA
age 37
visits member for 4 years, 10 months
seen 2 days ago

I am a database and emerging technology expert, focusing on new trends and technologies in the world of software. I develop computing platform architecture solutions using cloud-computing and high-scale data platforms.


Jul
23
comment Sql Server 2008 Database Mirroring
Hi Chris - I believe you can only have one witness per mirrored pair of databases. technet.microsoft.com/en-us/library/ms189902.aspx
Jul
23
answered Sql Server 2008 Database Mirroring
Jul
23
answered why I dont have Audit option in SQL server 2008?
Jun
30
comment MSSQL Two Database Servers 1 Database
Just a quick comment on Facebook and large corporations.... these businesses never write to the database synchronously. Facebook has a layer of memcache between the application and the MySQL databases it uses - the memcache is updated/read and the database is updated/re-read asynchronously at a later time. Google "database sharding" to find out more.
Jun
22
answered unable to connect to sql server analysis services on windows vista
Jun
22
answered When successfully configured SQL Server for database mirroring, got an error saying it's not configured for database mirroring
Jun
21
answered SQL Server log backups “stalling”
Jun
16
answered SQL Distributed Reporting Services Setup
Jun
4
comment SQL Server 2005 Replication Subscription Expiring Warning
You can set a threshold to allow the event to fire ahead of time. "When you enable a warning by using Replication Monitor or sp_replmonitorchangepublicationthreshold, you specify a threshold that determines when a warning is triggered. When that threshold is met or exceeded, a warning is displayed in Replication Monitor, and an event is written to the Windows event log. Reaching a threshold can also trigger a SQL Server Agent alert" There's a link to show you how to do that.
Jun
4
answered SQL Server 2005 Replication Subscription Expiring Warning
Jun
4
answered How to access SQL files from a BKS file?
May
10
answered Problem with regsvr32 on Windows Server 2008
May
4
answered Installing a new SQL Server instance fails
May
4
answered How to schedule daily backup in MSSQL Server 2008 Web Edition
Apr
2
comment SQL Server Replication Agent priority
Are you using a separate distribution server? Or is the publisher serving as its own distributor?
Mar
17
answered Will this force a reinitialize in Merge Replication Topology?
Mar
15
answered Can't add service account to domain group during SQL cluster install
Mar
15
answered What ports does Management Studio use to connect to SQL Server (2005)
Mar
12
answered SQL Cluster on Hyper V Failover Cluster
Mar
11
answered SQL Server: how to check securables