Point in time restore to a new DB from files of a Full Recovery Model
Script generator to restore to a new DB. Designed on Ola Hallengren's backup solution.
2011-05-31 (first published: 2011-05-20)
938 reads
Script Generator
Generate INSERT for table with IDENTITY column
Generate a "INSERT INTO...SELECT FROM" script for a table with an identity column.
2012-03-09 (first published: 2008-01-07)
3,943 reads
RE: MCDBA free Stuff
quote: If microsoft wants to make things a bit easier by giving away some of their questions, and others volunteer info on the exams, then I don't see why I should handicap myself by not looking at them. Microsoft does NOT give away some of their questions. The test even says that by taking it […]
2003-08-11
RE: MCDBA free Stuff
I'm not sure what Dumps and Transcenders are, but according to another post [MCDBA tests topic] MS Press "Readiness Review" books have questions identical to those on the tests. I've successfully worked now for a couple years with sql server. However, I know there are large chunks of sql server functionality I've never touched. It's […]
2003-08-08
RE: asp.net sql server security
howdy, i simply want to be the only one who has access to EM. the users should only have datbase access thru the asp.net pages, which in turn will call stored procs. maybe this will help: http://www.microsoft.com/usa/webcasts/ondemand/1765.asp unfortunately, I can't get the required software to work..:-(] has anyone else got any ideas? cheers, yogi
2003-08-08
RE: Remote Server vs Linked Server
That's fixed it. I had to recreate the stored procedure on server #1 in QA rather than in EM. Thanks. Jeremy
2003-08-06
RE: Simple Log Shipper
Holy LogShippers Thomas! Is your boss going EE just for native log shipping? Has he ever seen how unhelpful it is when it breaks? Does he know that he has to pay EE licensing on the standby server too? EE has its advantages, but it takes much more than log shipping to justify it. But, […]
2003-08-06
RE: MCDBA free Stuff
I recommend avoiding Dumps. They'll just make you a cheat, not a DBA. Cheers, - Mark
2003-08-05
RE: How to retrieve view script
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-05-19
RE: permissions to start sql server agent
I don't believe it requires the SQL Server Agent account to be a member of the local Administrators group. I do believe you can utilize a non-administrator account with specific privileges granted. What all those privileges are, I do not know offhand. I'd guess ones like (in User Rights Assignments) "Act as part of the […]
2003-05-15
Blogs
The Future of the Social Web Is in Good Hands
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
Monday Monitor Tip: Compliance Checking for Old Versions
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
Making Legend Order Match Segment Order in a Power BI Stacked Column Chart
A reader of one of my previous posts pointed out that the legend order...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers