tag:blogger.com,1999:blog-273869632024-10-08T20:25:14.891-05:00George WoodsDatabase Admin and Business Intelligence - Focusing on Data - Architect, Manage, Visualize and DistributeGeorge Woodshttp://www.blogger.com/profile/13596326746805389518noreply@blogger.comBlogger15125tag:blogger.com,1999:blog-27386963.post-83337364928020638202018-01-02T09:59:00.001-05:002018-01-02T09:59:12.910-05:00Blog is moving!I've recently switched my blog to http://www.thedataengineer.com George Woodshttp://www.blogger.com/profile/13596326746805389518noreply@blogger.com0tag:blogger.com,1999:blog-27386963.post-18770769444080961152017-12-31T12:56:00.001-05:002017-12-31T13:19:30.654-05:00Reading List - 2018I don't normally do New Year Resolutions, but during the Christmas break I was reading numerous articles on LinkedIn, I've always enjoyed Linkedin, with it's career connections and articles. However, I also realized how much wasted time I spent on Facebook and Twitter, so because it's that time of year, I am calling this my "New Year's Resolution": Spend more time bettering myself and my career
George Woodshttp://www.blogger.com/profile/13596326746805389518noreply@blogger.com0tag:blogger.com,1999:blog-27386963.post-32995490054243355522017-12-20T10:12:00.004-05:002017-12-20T10:14:44.430-05:00Determine what Linux Version4 different commands that you can run to see information about your Linux distro.
[oracle@server ~]$ cat /etc/issue
Oracle Linux Server release 6.8
[oracle@server ~]$ cat /etc/*release
LSB_VERSION=base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch
Oracle Linux Server release 6.8
NAME="Oracle Linux Server"George Woodshttp://www.blogger.com/profile/13596326746805389518noreply@blogger.com0tag:blogger.com,1999:blog-27386963.post-90655951986067763432017-12-20T09:38:00.002-05:002017-12-20T10:16:54.376-05:00Create Data Guard standby using RMAN<!--[if !mso]>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
<![endif]-->
<!--[if gte mso 9]>
<![endif]--><!--[if gte mso 9]>
Normal
0
false
false
false
false
EN-US
X-NONE
X-NONE
George Woodshttp://www.blogger.com/profile/13596326746805389518noreply@blogger.com0tag:blogger.com,1999:blog-27386963.post-19931724229877062642017-12-12T10:35:00.001-05:002017-12-12T10:42:11.531-05:002018's list of goals
Many items peak my interest and that can sometimes make it difficult to choose a few that I would like to gain a deeper learning of, but I think my current role will guide me in 2018.
In no particular order:
SQL Server on Linux: This is a no brainer. As long as I can remember, I have preferred to work with command line over gui based tools. I've always felt like I have more control over what IGeorge Woodshttp://www.blogger.com/profile/13596326746805389518noreply@blogger.com0tag:blogger.com,1999:blog-27386963.post-21026482276914073752017-11-14T13:27:00.002-05:002017-12-13T15:24:53.679-05:00Oracle OEM details in PowerBI<!--[if !mso]>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
<![endif]-->
<!--[if gte mso 9]>
<![endif]--><!--[if gte mso 9]>
Normal
0
false
false
false
false
EN-US
X-NONE
X-NONE
George Woodshttp://www.blogger.com/profile/13596326746805389518noreply@blogger.com0tag:blogger.com,1999:blog-27386963.post-19055333765795500332017-11-02T11:10:00.001-05:002017-11-02T11:11:10.159-05:00Oracle Open World and PASS SummitA little less than a month ago I attended Oracle Open World in San Francisco. It's been a few years since I last attended the conference. Although San Francisco seems to have changed the conference has stayed the same. Numerous days of sessions that are very informative. As I felt the last time I attended, many of the sessions seem like marketing sessions, this isn't a bad thing, just different. George Woodshttp://www.blogger.com/profile/13596326746805389518noreply@blogger.com0tag:blogger.com,1999:blog-27386963.post-24879873327478771732017-11-02T10:54:00.001-05:002017-11-02T10:55:01.163-05:00Combination of Both WorldsI just recently came back to my blog and noticed that my last post stated that I was going back to Oracle. I did, but the fit with that employer was not the best and I moved on to another company at the beginning of 2016. I couldn't be happier with that move in 2016. I get to work with SQL Server and Oracle along with other software packages. Some items that I am working on or researching and George Woodshttp://www.blogger.com/profile/13596326746805389518noreply@blogger.com0tag:blogger.com,1999:blog-27386963.post-79104474212193601352015-06-05T06:28:00.002-05:002015-06-05T06:28:59.082-05:00Going back to OracleI am thrilled to say that after 4 years of working with Microsoft SQL Server and the BI Tool Stack, I am going back to working with Oracle. I enjoyed working with Microsoft and getting to add another tool in my tool belt, but I am very excited about this new opportunity.
Hopefully this opportunity will lend itself to more blog posts.
Stay tuned for more details.George Woodshttp://www.blogger.com/profile/13596326746805389518noreply@blogger.com0tag:blogger.com,1999:blog-27386963.post-18440865830737061202015-05-26T06:46:00.001-05:002015-05-26T06:46:36.027-05:00Remarkable EmployeesI am not the original author of the eight qualities of remarkable employees below and unfortunately, I don't know who wrote it, but it is something I believe that I am. So thank you to whomever the Author is.
Great employees are reliable, dependable, proactive, diligent, great leaders and great followers... they possess a wide range of easily-defined—but hard to find—qualities.
A George Woodshttp://www.blogger.com/profile/13596326746805389518noreply@blogger.com0tag:blogger.com,1999:blog-27386963.post-54335765564296896362015-04-13T06:54:00.003-05:002015-04-13T06:55:20.202-05:00Losing StatisticsIn a world where data is king, why do we as Business Intelligence Developers not capture our own data. For instance, when we send reports out by email, we lose any kind of insight we may have on our reports. Who is looking at them, how often, what are peak times? This can make it very difficult for down times and notifications if there are any issues.
We also make some items available through George Woodshttp://www.blogger.com/profile/13596326746805389518noreply@blogger.com0tag:blogger.com,1999:blog-27386963.post-34572357264527860552015-04-08T20:37:00.003-05:002015-04-09T07:50:19.716-05:00Being lucky enough to go from DBA to Microsoft Business IntelligenceSo far in my career I have been lucky enough to work with some really hot products. I started out of school as an Oracle DBA, while also performing SAP Basis duties. I did this for about 3 years, when I decided it was time to try something new. What I didn't know at the time was that my Director did not want to lose me as a resource.
Our company was also starting to migrate our current Oracle George Woodshttp://www.blogger.com/profile/13596326746805389518noreply@blogger.com0tag:blogger.com,1999:blog-27386963.post-65512679301209210662015-04-08T06:18:00.000-05:002015-04-09T07:50:51.423-05:00Trying LinkedIn Premium for a free monthTrying LinkedIn Premium for a free month. I have been a member and big fan of LinkedIn for quite some time. This is how I actually found my current position or should I say this is how my current position found me. I wasn't really looking for a new opportunity, but one day a recruiter contacted me through my profile view and asked to talk. I was having one of those days at work and I figured whatGeorge Woodshttp://www.blogger.com/profile/13596326746805389518noreply@blogger.com0tag:blogger.com,1999:blog-27386963.post-61706295126350309552015-03-06T07:52:00.001-05:002015-04-09T07:52:10.528-05:00What are those randomly generated SQL Server Agent jobs with the funny character sequence?They some times look like 266102E5-EF3A-4D3B-B2AA-4907MM1DF28C or maybe D087318E-0C24-4895-9ECF-9530AA4D11B3 and they randomly show up in your Sql Server Agent list or do they randomly show up?
Well they are your Reporting Services subscription jobs. The nice thing is that you can dissect the details in the job and then use those details in a master job plan.
We recently did this so that our George Woodshttp://www.blogger.com/profile/13596326746805389518noreply@blogger.com0tag:blogger.com,1999:blog-27386963.post-56377898054035492792014-12-12T09:29:00.001-05:002014-12-12T09:29:28.348-05:00Starting Again!I was recently talking with a co-worker and he was talking about creating a blog, and I had mentioned that I have had a blog since 2007. Which got me thinking that I have not done a blog post in at least a year. So, I decided to try and start the blog back up. Unfortunately, it looks like all of my old posts are gone.
Most of the content of this blog will be about Microsoft Business IntelligenceGeorge Woodshttp://www.blogger.com/profile/13596326746805389518noreply@blogger.com0