#youmightbeaDBA

By -

Your two main enemies are developers and SAN admins #youmightbeaDBA

When your girlfriend has to lean around the laptop to kiss you goodnight #youmightbeadba

You always plan an exit strategy, even when entering a McDonald's #youmightbeaDBA 

You can't explain to your family what you really do for a living #youmightbeaDBA 

You have at least one set of scripts you won't share #youmightbeaDBA 

You and the Oracle DBA would happily fight off a developer together #youmightbeaDBA 

You've sent a vendor suggestions on improving their database design or code (and been ignored) #youmightbeaDBA 

You've sent a vendor suggestions on improving their database design or code (and been ignored) #youmightbeaDBA 

You refer to clothes as "Data Abstractions" #youmightbeaDBA 

Your girlfriend knows what "ETL" means #youmightbeaDBA 

You check your server logs before you check your e-mail in the morning so you can reply "Yeah, I already fixed that." #youmightbeaDBA 

You can convince a boss that you need 16GB of RAM in your laptop #youmightbeaDBA 

You call cigarettes "work vitamins" #youmightbeaDBA 

You've tried to convince someone else to become a DBA #youmightbeaDBA 

You call texting a "queuing system" #youmightbeaDBA 

You have an e-mail rule for backup notifications #youmightbeaDBA 

You would pay money for a license plate that has the letters S-Q-L together #youmightbeaDBA 

You have actually considered making a RAID array from thumb drives #youmightbeaDBA 

You've written blog posts on technology you've never actually implemented in production #youmightbeaDBA 

Your blog would make a "best practices" or "worst practices" book #youmightbeaDBA 

The first thing you install on your netbook is SSMS #youmightbeaDBA 

You tell people that you made a database query go faster, and expect them to be happy for you #youmightbeaDBA 

You take the word "NoSQL" as a personal attack #youmightbeaDBA 

You think that something OTHER than the database might be the performance bottleneck #youmightbeaDBA 

You refer to time as a "Clustered Index" #youmightbeaDBA 

You think a millisecond is a really long time #youmightbeaDBA 

You think "Set theory" is not an verb but a noun #youmightbeaDBA

You don't like Oracle, and not just because of what she did to Neo #youmightbeaDBA 

You know when to say "sequel" and "s-q-l" #youmightbeaDBA 

Holiday == "Maintenance Window" #youmightbeaDBA

You cringe in public when the word "upgrade" is used in a sentence #youmightbeaDBA 

When someone tells you they are going to take a dump and you wonder of which database then #youmightbeaDBA 

When it's 11pm on a holiday weekend and you are working #youmightbeaDBA 

When getting milk from the fridge you check the expiry date is > getdate() #youmightbeaDBA 

Your friends don't understand why you think there's a difference between single and double quotes #youmightbeaDBA 

The thought of disrupting 500 people's work so you can do something doesn't phase you #youmightbeaDBA

Your home computer is backed up in 2 different places #youmightbeaDBA 

If you have ever set up a SQLAgent job to email your mobile phone to serve as an alarm clock #youmightbeaDBA 

The late-night security guard knows the names of your town. #youmightbeaDBA 

You have edited a data file by hand, just to see what would happen. #youmightbeaDBA 

You've built programs that access data just to keep other developers from asking you to run queries all the time. #youmightbeaDBA 

You have memorized the names of several of the AdventureWorks employees. #youmightbeaDBA 

When the waiter says he'll be your server today, you ask how many terabytes he is #youmightbeaDBA 

hmmm... #youmightbeaDBA if your recipe for dinner is "SELECT * FROM Refrigerator" 

If you're up at midnight commenting about SQL #youmightbeaDBA 

I'd noticed that. :) #youmightbeaDBA 

when people talk about "their type" you're thinking varchar, bigint, binary, etc #youmightbeadba 

Someone asks you to throw another log on the fire and you tell them not to worry about it because Autogrowth is turned on #youmightbeaDBA 

you google to trouble shoot a problem and end up at your own blog (and it fixes it) #youmightbeaDBA

You list TSQL as your native language on the 2010 census. #youmightbeaDBA 

You're sitting and typing #youmightbeaDBA when you could be outside #youmightbeaDBA 

Comments

Post a Comment

Popular posts from this blog

Index Clean-Up Scripts

By -
dropping un-used ones, adding missing ones, and fine-tuning the ones I already have. I thought I’d share some of the scripts I’ve been using to accomplish this. Un-Used Indexes Script Declare @dbid int     , @dbName varchar(100);   Select @dbid = DB_ID()     , @dbName = DB_Name();   With partitionCTE (object_id, index_id, row_count, partition_count)  As (     Select [object_id]         , index_id         , Sum([rows]) As 'row_count'         , Count(partition_id) As 'partition_count'     From sys.partitions     Group By [object_id]         , index_id )    Select Object_Name(i.[object_id]) as objectName         , i.name         , Case              When i.is_unique = 1          ...
Read more

forgot sa password and no logins are added

By -
Image
Stop the SQL services Edit the properties of the SQL Service Change the startup parameters of the SQL service by adding a  –m;  in front of the existing parameters Start the SQL services. These are now running in Single User Mode. Start CMD on tthe SQL server Start the SQLCMD command. Now we create a new user. Enter following commands CREATE LOGIN recovery WITH PASSWORD = ‘TopSecret 1′ (Remember SQL server has default strong password policy Go Now this user is created Now we grant the user a SYSADMIN roles using the same SQLCMD window. sp_addsrvrolemember ‘recovery’, ‘sysadmin’ go
Read more

The SQL Server DBA’s Guide to Teradata

By -
Being a long-time devotee of all things Microsoft SQL Server, I had quite a bit of learning to do to get up to speed on our new Teradata appliance. This guide attempts to distill some of what I have learned. I will primarily focus on what I have found most lacking: examples of how to convert SQL Server T-SQL to Teradata SQL. This guide will use the vendor-supplied sample databases:  SQL Server’s AdventureWorksDW2012 , and the  Teradata’s Express 14.0 Retail database . Also, while this is probably self explanatory, the “mufford” object referenced in the Teradata examples is simply my own personal sandbox. You’ll need to replace any “mufford” reference to whatever your development sandbox may be named. Release History: 2012-08-17 – Added UPDATE examples; reformatted 2012-08-12 – Added date examples 2012-08-08 – Initial Release SELECT Statements Simple SELECT SQL Server: Best practice is to qualify the table schema; qualifying the database is optional unless ...
Read more