Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««4,0524,0534,0544,0554,056»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Sunday, July 14, 2013 12:41 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 6:48 PM
Points: 20,734, Visits: 32,499
Have a question for Redgate Backup users. I have looked on the Redgate site without luck.

How would I directly query Redgate Backup data tables to extract information for my own reporting?



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1473348
Posted Sunday, July 14, 2013 12:52 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, October 18, 2014 5:21 PM
Points: 5,877, Visits: 13,005
Lynn, I would presume (and hope) the standard backup history related tables in msdb are still updated.

---------------------------------------------------------------------

Post #1473378
Posted Monday, July 15, 2013 1:12 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:55 PM
Points: 13,253, Visits: 11,033
Sean Lange (7/12/2013)
Koen Verbeeck (7/12/2013)
Brandie Tarvin (7/12/2013)
Koen Verbeeck (7/12/2013)
Is there a difference in the US between passport and ID?


Yes, there is. Passport allows us to cross borders with other countries. ID could be anything from a driver's license to a state ID card (similar in size to a driver's license without the driving priviledges) to a student / military ID card, etc.

There are lots of definitions of what "ID" means in the States. Passport is just one of them.

EDIT: And there is no law (federal at least) that requires us to have our ID on us all the time. Most states I've lived in don't have that law either. It's just darned inconvienent to not have ID at hand when someone requests it in order to do business (mortgage, credit card use, drinking, etc.).


Ah, that explains why they ask "can I see some ID?" in the movies.


It is actually kind of funny in the US. For things like travel or other more official things you hear "some ID". When making a credit card purchase or age verification at a bar you generally hear "your ID", which I suspect is probably more common in Europe.


We don't need an ID for credit card purchases in Europe, we have a pin code. You know, technology advancements and all




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1473492
Posted Monday, July 15, 2013 1:16 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 10:53 PM
Points: 3,421, Visits: 5,359
Koen Verbeeck (7/15/2013)
Sean Lange (7/12/2013)
Koen Verbeeck (7/12/2013)
Brandie Tarvin (7/12/2013)
Koen Verbeeck (7/12/2013)
Is there a difference in the US between passport and ID?


Yes, there is. Passport allows us to cross borders with other countries. ID could be anything from a driver's license to a state ID card (similar in size to a driver's license without the driving priviledges) to a student / military ID card, etc.

There are lots of definitions of what "ID" means in the States. Passport is just one of them.

EDIT: And there is no law (federal at least) that requires us to have our ID on us all the time. Most states I've lived in don't have that law either. It's just darned inconvienent to not have ID at hand when someone requests it in order to do business (mortgage, credit card use, drinking, etc.).


Ah, that explains why they ask "can I see some ID?" in the movies.


It is actually kind of funny in the US. For things like travel or other more official things you hear "some ID". When making a credit card purchase or age verification at a bar you generally hear "your ID", which I suspect is probably more common in Europe.


We don't need an ID for credit card purchases in Europe, we have a pin code. You know, technology advancements and all


Australia uses a PIN code too but thankfully still accept signatures.



My mantra: No loops! No CURSORs! No RBAR! Hoo-uh!

My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.


Need to UNPIVOT? Why not CROSS APPLY VALUES instead?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
Post #1473496
Posted Monday, July 15, 2013 1:22 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:08 PM
Points: 40,177, Visits: 36,580
One of the worries I have when travelling is that I have my passport, ID book and driver's licence with me all at the same time. It's one of the very few times I will have all three on me (ID book and passport are usually locked away at home)

Getting a new passport will be problem enough, getting a new driver's licence requires an ID book and getting a new ID book can take months...



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1473500
Posted Monday, July 15, 2013 1:37 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 16, 2013 6:41 AM
Points: 25, Visits: 167
Hi Gail,

it is rather intimidating renewing Driver's License is a process and a half, either you need to be first in line or you will spend the whole day waiting for officials.
The alternative is to pay for special services over weekends then it only takes 15 minutes total but it does cost abit more and no bribes it is amazing and worth it. The service is available in the Tshwane area.


As for the other documents if they get lost forms part of nightmares that are reoccuring to me

Regards

Andries
Post #1473507
Posted Monday, July 15, 2013 4:23 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:28 AM
Points: 5,584, Visits: 6,380
GilaMonster (7/15/2013)
One of the worries I have when travelling is that I have my passport, ID book and driver's licence with me all at the same time. It's one of the very few times I will have all three on me (ID book and passport are usually locked away at home)

Getting a new passport will be problem enough, getting a new driver's licence requires an ID book and getting a new ID book can take months...


All right. I'll bite. What is an ID book? (ID I understand, but they made a whole book out of it?)


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1473557
Posted Monday, July 15, 2013 4:33 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 16, 2013 6:41 AM
Points: 25, Visits: 167
Brandie Tarvin (7/15/2013)
GilaMonster (7/15/2013)
One of the worries I have when travelling is that I have my passport, ID book and driver's licence with me all at the same time. It's one of the very few times I will have all three on me (ID book and passport are usually locked away at home)

Getting a new passport will be problem enough, getting a new driver's licence requires an ID book and getting a new ID book can take months...


All right. I'll bite. What is an ID book? (ID I understand, but they made a whole book out of it?)


HI Brandie,

It is a scaled down version of a passport. It use to contain drivers and gun licenses. Marriage certificates etc but ID Books are falling away and are going to be replaced by a chip card much like the american social security cards

regards
Post #1473559
Posted Monday, July 15, 2013 4:36 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:28 AM
Points: 5,584, Visits: 6,380
hvermaak (7/15/2013)
Brandie Tarvin (7/15/2013)
GilaMonster (7/15/2013)
One of the worries I have when travelling is that I have my passport, ID book and driver's licence with me all at the same time. It's one of the very few times I will have all three on me (ID book and passport are usually locked away at home)

Getting a new passport will be problem enough, getting a new driver's licence requires an ID book and getting a new ID book can take months...


All right. I'll bite. What is an ID book? (ID I understand, but they made a whole book out of it?)


HI Brandie,

It is a scaled down version of a passport. It use to contain drivers and gun licenses. Marriage certificates etc but ID Books are falling away and are going to be replaced by a chip card much like the american social security cards


Thanks for the explanation.

Though American social security cards don't have chips. They're just little paper cards.


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1473562
Posted Monday, July 15, 2013 4:49 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 16, 2013 6:41 AM
Points: 25, Visits: 167
Our government guys are trying to get rid of identity theft but i'm sure that some corrupt official will need be selling the information long before the cards are issued to the public.

Post #1473567
« Prev Topic | Next Topic »

Add to briefcase «««4,0524,0534,0544,0554,056»»»

Permissions Expand / Collapse