Get short, timely messages from Zach M.

Twitter is a rich source of instantly updated information. It's easy to stay updated on an incredibly wide variety of topics. Join today and follow @WIDBA.

Get updates via SMS by texting follow WIDBA to 40404 in the United States
Codes for other countries

Country	Code	For customers of
Two-way (sending and receiving) short codes:
Australia	0198089488 Telstra
Canada	21212 (any)
United Kingdom	86444 Vodafone, Orange, 3, O2
Indonesia	89887 AXIS, 3, Telkomsel
Ireland	51210 O2
India	53000 Bharti Airtel, Videocon
Jordan	90903 Zain
New Zealand	8987 Vodafone, Telecom NZ
United States	40404 (any)

WIDBA

Reading: Implementing Message Queues in Relational Databases wp.me/p1h9Yd-8S via @thomaskejser 12:54 PM May 25th via Tweet Button
@DBArgenis Yeah, its quite a bit of one off custom programming to get it to a common format. -> Thanks for talking it through 10:12 AM May 22nd via TweetDeck in reply to DBArgenis
@DBArgenis I have several custom feeds and some may/may not contain the sensitive info.The DB is entirely made up of these ETL tables. 10:04 AM May 22nd via TweetDeck in reply to DBArgenis
@SQLSoldier Thanks for the info - helps with planning 10:03 AM May 22nd via TweetDeck in reply to SQLSoldier
@SQLSoldier There is not, I did not see the DB would be online during the process. Figured I would have to send an outage notification,etc 10:01 AM May 22nd via TweetDeck in reply to SQLSoldier
@DBArgenis I brought that up, but I think the nature of the ETL processes being custom, there is not a common set of tables to encrypt 10:00 AM May 22nd via TweetDeck in reply to DBArgenis
@SQLSoldier @programmersedge Thanks I will just give it a weekend. For once, if its not operational on a Monday, its no big deal :) 9:59 AM May 22nd via TweetDeck in reply to SQLSoldier
@DBArgenis how would you handle data that is supposed to be encrypted then? at least as I am told by compliance. 9:57 AM May 22nd via TweetDeck in reply to DBArgenis
@DBArgenis Sure, HIPAA data is going to start coming in 9:56 AM May 22nd via TweetDeck in reply to DBArgenis
@SQLSoldier @programmersedge Just looking for someones experience as a guide , can I expect it to complete in 48 hrs, etc ? 9:55 AM May 22nd via TweetDeck in reply to SQLSoldier
@SQLSoldier I would have tested if feasible.Its an ETL system, so I can have pretty much everything off for the encryption #sqlhelp 9:54 AM May 22nd via TweetDeck in reply to SQLSoldier
@programmersedge #sqlhelp I understand. Has anyone done this on 15k RPM disk for a 1TB DB? How long did it take ballpark? 9:42 AM May 22nd via TweetDeck in reply to programmersedge
I have to turn TDE on for a 3 TB DB. Does anyone have a general idea of how long it will take? I realize there are many factors. #sqlhelp 9:37 AM May 22nd via TweetDeck
And the 3 year old, while toad hunting, procures another 2 giant morels. I have thus paid the bounty. This parenting thing has an upside. 4:19 PM May 20th via TweetDeck
@TheSQLGuru The biz key is internally assigned by src sys.Lots of analysis uses that key to return to src system.Might help to chg #sqlhelp 6:46 AM May 18th via TweetDeck in reply to TheSQLGuru
@TheSQLGuru The Biz key is a BigInt and could probably be PK.Fact table has a PK on NClust surrogate col BigInt. #sqlhelp 6:41 AM May 18th via TweetDeck in reply to TheSQLGuru
@TheSQLGuru Thanks again. That gives me a good idea to consider with a business key we create and use frequently in queries #sqlhelp 6:32 AM May 18th via TweetDeck in reply to TheSQLGuru
@TheSQLGuru Thanks. So used to OLTP that its hard to leave tables as heaps. 6:26 AM May 18th via TweetDeck in reply to TheSQLGuru
Is there any good reasons to have FACT table in a DW that is stored as a heap? Its only 1/2 billion rows? Wanting to cluster it. #sqlhelp 6:07 AM May 18th via TweetDeck
@mnDBA haha. The upside is the Twins will see our # 6 or 7 starter so they might be able to drive in a run or two. Have fun. 7:41 PM May 17th via TweetDeck in reply to mnDBA