1,007 reputation
517
bio website linkedin.com/in/briandknight
location Glen Allen, VA
age 37
visits member for 4 years, 6 months
seen Aug 20 at 14:23

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.


Nov
5
comment SSL problems on Android (Intermediate Certificate)
GO to your certificate provider and ask for a new one.
Nov
5
comment SSL problems on Android (Intermediate Certificate)
Are your certs in PEM format? nczonline.net/blog/2012/08/15/…
Nov
5
comment SSL problems on Android (Intermediate Certificate)
Does your file look like the update I added above for site cert + intermediate cert?
Nov
5
comment SSL problems on Android (Intermediate Certificate)
If you don't have the root, just concatenate the intermediate cert to the site cert and then upload.
Oct
24
comment How do I force a restore over an existing database?
Can you share the script for the backup? (by clicking on that script button at the top of the backup window). It's difficult to understand all of the settings from the screenshot.
Aug
27
comment Outbound Azure VM Internet Connectivity
Yes - it is the same as the domain controller. Also, please see edit above.
Mar
1
comment failed to fetch volume file
I'm currently having the same issue on Ubuntu 12.04 LTS. If I find a solution, I'll post it here.
Mar
10
comment SQL Server stops regularly on every windows restart
Looking at your last error log - it says that NetworkService is unable to open a specified database. Your service account should have master set as it's default database. I am wondering if it is set to a different database that has not yet gone through startup recovery some of the time. Ensure the default database is master.
Mar
9
comment Domain Change, Lost Access to SQLEXPRESS
@ColdT sure - that would work also. Either way, the change in the domain of his account is the culprit. More than one way to skin the cat.
Jan
14
comment mongod autostart
Are you running MongoDB on Linux or Windows? Both can be setup to start on reboot, but the process is different.
Oct
20
comment How large can the undo file grow to?
It's a little tricky to get it to go into STANDBY only at certain times. You could stop the log shipping restores for a period, run a script to restore WITH STANDBY, crunch numbers, and then rollback the UNDO file. If that's too much trouble, I'd just recommend restoring with STANDBY as part of the log shipping restore.
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
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
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.
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
2
comment Some rows giving “String or binary data would be truncated” error when editing in Management Studio
Hmmm - It’s possible to ignore the 'String or binary data would be truncated' message by setting ANSI_WARNINGS to OFF. This will truncate fields where they don’t fit. ANSI_WARNINGS OFF has drawbacks and it is better to correct a problem rather than ignore it. Another thing to check is whether the table update is firing any triggers that insert or update another table.
Mar
1
comment SharePoint / SQL Server “out of memory” error
Not if you are running 64-bit.
Feb
26
comment SharePoint / SQL Server “out of memory” error
Is your server 64-bit or 32-bit. Is AWE enabled?
Feb
26
comment SharePoint / SQL Server “out of memory” error
Not so much - the limitation is a top amount for SQL Server. SQL will begin to flush buffer pages to disk in order to free up memory when this threshold is approached. Like Charles said, it will not be great performance, but it will save your server from crashing due to lack of memory.
Feb
25
comment A username changed in ActiveDirectory, but the old UserName is still showing in SQL Profiler
Not 100% sure then. I'd try running xp_logininfo 'DOMAIN\GROUP', 'members' and see if there is a disparity between that user's name and his mapped login name. The mapped login name is what SQL Server is using.