Welcome to Women In Technology week at SQL University! This is a great blog project put together by Jorge Segarra (Twitter | Blog), and contributed to by many SQL professionals. If you aren’t a student yet, head over to the website and get started! This week, you get to meet a fantastic group of women, all of whom work with SQL Server and are involved in the community. These women are smart, talented, driven and amazing.
This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.
Tomorrow I will start a 6 month attempt to document my application. Management has decided that it would be nice that someone could take over when I will be absent for a longer period of time or for when I find another job. I can only agree with their point of view. It would however be easy for me to say that my code is full of automated tests and the code is well layered and thus completely understandable, but that would not be taking into account that someone would need to earn the decisions I took to get what I have now.
Introduction There are several ways you can keep your settings in your application. I can think of several and all have pros and cons. I will try to list the ones I use and why I would use them and why not. Constants Settings XML Table on a database server Resourcemanager Constants This is simple you make a class or module and you add some constants to it.
Some of us work extensively with SSIS and multi-instance SQL clusters. One of the headaches with SSIS in this type of set up, is that SSIS is not cluster aware. This includes where packages are saved when you upload them through SSMS. Now to give you the ability to save and manage SSIS packages on specific MSDB databases for a SQL cluster, we need to edited a file. The file can be found at this path:
Last year, I helped organized SQL Saturday in Chicago with two other people. On many occasions I have received feedback from speakers and attendees saying that SQL Saturday ranked in the top three out of all the SQL Saturday events they had attended. Feedback like that is truly inspiring. This year we’re bringing another SQL Saturday to the Chicago area. The organizer group this year includes a few more people and we’ve spread the duties out a bit to get things done better and more efficiently but everyone helps each other and it is making it much easier.
There are 13 new videos on channel 9 posted about SQL Server. The non-marketing videos (by engineering PMs) give customers peek into the goals and visions why certain SQL Server features were decided and implemented. Below is a list with a little blurb what the video is about. They have the following formats available High Quality WMV (PC, XBox, MCE) MP3 (Audio only) Medium Quality WMV (Lo-band, Mobile) High Quality MP4 (iPad, WP7)
Product Selection: 1: Identifying Needs 2: Requirements and Scoring 3: Evaluation 4: Review It was a long trip from “I want product ABC” to what we really ended up choosing and implementing. No process is perfect, no meeting goes as planned. After the product selection process is complete it’s time to review what went well, what fared poorly, and what we can try to improve the process.
SQL Server Reporting Services 2008 R2 Creating mailing labels is a common business need. From sending marketing postcards to prospects, to the annual Christmas cards for customers, labels are frequently used. Are you currently running a report to get your customers mailing information, then using Mail Merge in Microsoft Word to create the labels? Perhaps you are simply exporting the data out of the database. If so, there is an easier way!
Should I abandon VB.Net? This is a question that crosses my mind from time to time, but lately it is getting stronger. At least it would make my life simpler. Copy paste coding gets even better when you are a C# programmer since there are so much more examples out there. The community is bigger and better for C#. Even Microsoft discourages the use of VB.Net. If you ever go to something like techdays you will find that VB.
I started my journey on Thursday when I tried to automate the task of closing Visual Studio doing the git checkout and then starting Visual studio again. I failed on that account, and I found that my win7 installation was a bit corrupt, but I got some good help and a comment that got me thinking. So I continued on my quest and on Saturday I installed powerconsole and found what I could do with it.