I was an Accidental DBA at the start, intentional DBA now and forever, and I have to say that the SQL Server community is like none other. The day after I started my job as a Java developer in 2003, the DBA put in her 2 week notice. My boss took a big risk when he asked me “want to be a DBA?”, and that changed everything. I did both for quite some time and eventually transitioned into straight-up full time DBA. My first boss was excellent. He told me about SQLServerCentral, and I was hooked. Daily questions, forums for help, and just a wealth of great articles gave me a great kick start on becoming a halfway decent DBA.
PASS, what is this thing? Users groups? Seriously you must be joking. Fortunately I live close enough to a city that had a great users group. Attending a few of these monthly meetings introduced me to great speakers like Randy Dyess and Brent Ozar. About five years ago a local team put together this new thing called “SQL Saturday” that was free for anyone that wanted to come. I was sure I hit the jackpot. Brent Ozar introduced a great new tool he had created called “sp_blitz”. I was in awe. Shortly after this came Triage Tuesdays, a free weekly ½ hour training event from Brent Ozar UnlimitedRed Gate did a free event, SQL in the City, where I got to meet some heroes like Steve Jones, Allen White and Grant Fritchey. Granted I didn’t ever talk to them personally, but hearing them speak so passionately about SQL Server was good enough for me. Over the years I have signed up for every newsletter possible, SQLServerCentral, SQL Skills, and the Brent Ozar Unlimited Weekly Links. There are so many opportunities for training you could probably watch a free webinar every day.
I just recently attended a SQL Saturday and learned a bunch of cool new things that I can’t wait to implement. I sat in on a few “packed house” sessions with icons like Brent Ozar and Adam Mechanic. While eavesdropping on passing conversations, I was shocked to hear people say, “Oh, I haven’t heard of him before”. I thought to myself, where do you live under a rock? There were even people talking about flying in for this event.
Now is the time to invest in you. I guess I just consider myself lucky to have had a great boss that pushed training into our laps. He always said you should be spending at least a couple of hours a week reading articles, learning something new. His philosophy was that if you learn something new it will help the company, maybe not today, but eventually. Just this week, I used something that I learned from this last SQL Saturday to fix a critical production performance issue. Thank you “Clash of the Row Goals” session.
Most of my career I have been the lone DBA in the company. Without all these people I might still be using maintenance plans for index maintenance, shrinking transaction logs, using select distinct just in case, or who knows what other things I am sure I did on day one. Maybe someday I will have icon status, but until then I owe a great thanks to all the mentors, MVPs, SQL bloggers, and other contributors to the SQL community. There are too many names out there to call them all out individually. I am so glad that there are people out there smarter than me that take the time to put information out there for me to read, watch and implement. Because of you most anyone can be a successful accidental turned intentional DBA.
Get a head start evaluating SQL Server 2014 - guided by two experts who have worked with the technology from the earliest beta. Based on Community Technology Preview 2 (CTP2) software, this guide introduces new features and capabilities, with practical insights on how SQL Server 2014 can meet the needs of your business. Get the early, high-level overview you need to begin preparing your deployment now.
CREATE TABLE #Data
INSERT INTO #Data
INSERT INTO #Data
INSERT INTO #Data
INSERT INTO #Data
DECLARE @CurrencyId INT
DECLARE @GLAccountId INT
DECLARE @ItemAmt DECIMAL
SET @CurrencyId = 0
SET @GLAccountId = 0
SET @ItemAMt = 0
CurrencyId = ISNULL(NULLIF(@CurrencyId,0), CurrencyId)
AND GLAccountId = ISNULL(NULLIF(@GLAccountId,0), GLAccountId)
AND ItemAmt = ISNULL(NULLIF(@ItemAmt,0), ItemAmt)
How many records are returned?
1 1 3.00
Since the Variable @ItemAmt is defined as Decimal, the default is decimal(18,0). Since @ItemAmt is also the first variable in the NullIf and the ISNull the second parameter ItemAmt gets converted implicily to decimal(18,0), even if NULL is returned for the first. So the query only returns those records in whole numbers.
How to repair backup of .mdf file database?
- Hi folks,
One of our clients gets the following error when trying to backup a database:
System.Data.SqlClient.SqlException: SQL Server detected a logical...
- I have huge table around 5 million rows in source table (i.e Sybase server) .Need to copy 5 million rows...
Bulk insert statement cannto open file on the share
- I am trying to execute a bulk insert statement in SQL management studio.
FIELDTERMINATOR = ',',
ROWTERMINATOR = ''
Cannot bulk load because...
CONVERTING PLSQL TO TSQL
- converT this PLSQL TO TSQL
CUSTOMER# - DECODE(Transaction Type Code,'FULL RETIREMENT',3,'PARTIAL RETIREMENT',DECODE(SAME_YEAR,'Y',3),'ADDITION',DECODE(SAME_YEAR,'Y',( DECODE(TO_NUMBER(SUBSTR(Date Entered,-2))-( TO_NUMBER(SUBSTR(Date Placed In Service,-2)) ),0,1,4) )),'ADJUSTMENT',DECODE(SAME_YEAR,'Y',( DECODE(( TO_NUMBER(SUBSTR(Date...
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.