149 reputation
214
bio website twitter.com/wescrock
location Fresno, CA
age 28
visits member for 1 year, 9 months
seen Jul 31 at 22:11

I hold my MCITP in Database Development. Currently, I am working on learning as much about replication as possible... specifically, troubleshooting it when things go wrong. I work for a software firm that provides a solution for city and county health inspection agencies and I fill a role that is a hybrid of development and client services.


Jul
10
awarded  Notable Question
Jul
2
awarded  Curious
Jun
5
awarded  Notable Question
Feb
6
awarded  Popular Question
Jul
17
awarded  Popular Question
Jun
3
comment Create database role to allow read access to all tables; write access to some
Easy enough. Glad we have a community like this.
Jun
3
accepted Create database role to allow read access to all tables; write access to some
Jun
3
comment Create database role to allow read access to all tables; write access to some
That actually might be the simplest way... Is there a way to script that? I need to keep a set of scripts for whenever we refresh one of these databases, I can get all setting back instantly.
Jun
3
asked Create database role to allow read access to all tables; write access to some
Apr
17
comment Querying number of subscription to each publication
Yes, it was....
Apr
17
answered Querying number of subscription to each publication
Apr
17
asked Querying number of subscription to each publication
Apr
12
comment How database administrators can see my requests to SQL Server?
Someones trying to get himself fired...
Feb
4
comment é being converted from database to site
I'm assuming that I need to set it to UTF8 then... would this have any implications to other areas of the database?
Feb
4
comment é being converted from database to site
the result: CREATE DATABASE DBNAME /*!40100 DEFAULT CHARACTER SET latin1 */
Feb
4
asked é being converted from database to site
Jan
25
comment sp_startpublication_snapshot Parameter(s)
I am using EXEC sp_executesql to execute under the other database.
Jan
25
comment sp_startpublication_snapshot Parameter(s)
This might work... I'll give it a go.
Jan
25
asked sp_startpublication_snapshot Parameter(s)
Jan
24
revised SP for Restoring Database and performing other tasks on it
added 120 characters in body