I’ve been making changes to this blog lately including a new theme, plug-ins, and tons of new content. One of my unofficial mentors, Brent Ozar, who was recently made a Microsoft MVP, has been on a tear as of late. This has inspired me to take my blog to the next level as well. [...]
|
||||||
|
|
This past Saturday I attended the first of four days of SQL Server Development Training. The instructor, Mike Hotek literally wrote the book on SQL 2008 Database Development. A fellow M2M Administrator asked me why I bothered because we are not yet on SQL 2008 and I thought it would make a good blog post. [...] First, let me get this out of the way, I have great respect for sales people. It’s a dirty job and someone has to do it; it certainly won’t be me. My father was a salesperson of one type or another his entire life. I can only imagine how difficult this job is considering the [...] This article is day five in a week of reporting articles. Create and follow standard procedures for report deployment. The actual procedure depends greatly on the report method. Since I often use Crystal Reports Server and SQL Reporting Services (SSRS) for my report presentation, I have a Testing folder where all finished reports go prior to [...] This article is day four in a week of reporting articles. Most users want to export reports to Excel so they can manipulate the data. If possible, set up the report for the cleanest exporting possible. This process starts when writing T-SQL. For example, one can extract only the date instead of a datetime value when [...] This article is day three in a week of reporting articles. This seems like a no-brainer, but it is not as easy as you would think. Often your users will not know what they want and certainly not where to get it. Don’t take direction from this guy. Let’s say Milton, a purchasing agent, [...] This article is day two in a week of reporting articles. Create standard layouts for both landscape and portrait reports and have them approved by management. Many larger companies have Corporate Identity Guidelines created by marketing experts with standards already defined for marketing and sales documents. Adhere to the standards religiously. If creating your [...] This article is day one in a week of reporting articles. If you are going to become a business intelligence ninja, start at the beginning. You need to develop standard procedures for report creation. They include: Who can request reports? A good percentage of my day is spent writing reports. The report formats could be SQL Server Reporting Services (SSRS), Crystal Reports, M2M VFP reports, or ODBC Excel Spreadsheets. The latter three methods usually involve T-SQL, which I write by hand using TOAD for SQL Server or the SQL Server Management Studio (SSMS). In the [...] The other night I was working on the blog and my girlfriend was watching TV, specifically NCIS. One of the characters, who happens to be a ridiculously attractive medical examiner assistant, is looking up data on her computer. Anyway, her computer “gets hacked” by a super hacker and the screen goes nuts. [...] |
|||||
|
Copyright © 2010 Made2Mentor - All Rights Reserved |
||||||
Popular Articles