Favorites » Her Blog
 -
can not drop user from database - MSDN Forums
-
Apr 23, 3:29am
1 review
databases, security, sql, schema
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=107720&SiteID=1
-
Error: The database principal owns a schema and cannot be dropped.
Excellent answer to resolving this issue.
 -
subscription(s) have been marked inactive and must be reinitialized - dBforums
-
Apr 23, 1:39am
1 review
databases, replication
http://www.dbforums.com/showthread.php?t=657329
-
How to fix the above error in SQL Server Replication:
In a nutshell:
1. Select * from MSsubscriptions
2. update distribution..MSsubscriptions set status=2 where publisher_id='x'
and
publisher_db='x' and publication_id='x' and subscriber_id='x' and
subscriber_db='x'
 -
iGIZMO issue 3 : Page 1
-
Apr 15, 2:53am
2 reviews
science, gadget
http://dennis.cerosmedia.com/1A47f9e62abbeb5989.cde
-
The digital equivalent of a glossy gadget mag, excellent!
 -
no bake chocolate biscuit cake YUM!! - MoneySavingExpert.com Forums
-
Apr 14, 5:08am
1 review
cooking, chocolate, no-bake-cake
http://forums.moneysavingexpert.com/showthread.html?t=203111
-
A recipe for no-bake choccie biccie cakie yummy!
 -
SQL Server PerfMon counters for tracking Windows memory
-
Apr 14, 1:59am
1 review
databases, sql, perfmon
http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1302600,00.html
-
4-part screencasts on PerfMon usage, an extremely useful tool that can be hard to decipher without a guide.
 -
SQL Server tempdb best practices increase performance
-
Apr 14, 1:52am
1 review
databases, sql, tempdb
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1307255,00.html?t...
-
A brief guide to tempdb best practice. This will only whet your appetite, you'll have to do a lot more research to understand the nuances of tempdb tweaking.
 -
How to move SQL Server databases to a new location by using Detach and Attach fu…
-
Apr 14, 1:07am
1 review
databases, sql
http://support.microsoft.com/kb/224071
-
Useful guide to moving the location of several SQL system database files.
 -
DBA Morning Check List - SQL Server Central
-
Apr 14, 12:53am
1 review
databases, sql, dba
http://www.sqlservercentral.com/articles/Database+Administration/62480/
-
A useful list of things DBA's should be doing first thing. Useful to compare this to your own checklist, there might be something missing.
 -
TSQL String Array Workbench
-
Mar 19, 8:59am
1 review
databases, sql
http://www.simple-talk.com/sql/t-sql-programming/tsql-string-array-workbench/
-
An interesting example of string arrays in t-sql using SQL 2005 and above
 -
http://rowena.typepad.com/rostitchery/2006/06/one_seam_conver.html
-
Mar 18, 5:52am
3 reviews
clothing
http://rowena.typepad.com/rostitchery/2006/06/one_seam_conver.html
-
I'll be having a stab at this over the bank holiday weekend. It looks easy enough (says she!) but I'll be rather brave and using an old bed sheet to try my hand out at the measurements first.
|
Add her as a friend >
