Want to learn some stuff about SSIS? Want to do it from the couch and not have to get up for the whole morning? If so or if the two opening questions intrigued you enough to get this far – then I have the answer for you. SSWUG is offering a half day virtual conference … Continue reading SSWUG Free SSIS Expo
Tag: SQL Server
SQLRally Session Submissions
Go SQL! Go SQL! Since I mentioned the SQLRally Call for Presenters, I figured I should also be one of those people submitting a session. I’m not going to be a pot calling the kettle black. Below are the two sessions that I submitted. Hopefully they will appeal to enough people that I’ll get a … Continue reading SQLRally Session Submissions
Last Call SQLRally Call for Presenters
Go SQL! Go SQL! It’s the last day and the last chance (last dance?) to submit a session for the upcoming SQLRally! Some details if you are on the unawares – SQLRally is a 3-day SQL Server conference that will occur in Orlando, FL. Unlike the PASS Summit, SQLRally will be capped to 500 people. … Continue reading Last Call SQLRally Call for Presenters
MCM Live Blog – Week December 13
If you're reading this, it must be Monday morning. Oh dear, that means I am officially starting my public studying for the Microsoft Certified Master (MCM) exam. I've already failed this exam once and am not really up for failing again. To help prevent this, I figured studying through my blog and noting the things … Continue reading MCM Live Blog – Week December 13
SQLRally Call for Presenters
Go SQL! Go SQL! I haven’t blogged about it until now. If you weren’t aware, there’s a new conference in town. It’s SQLRally! This is a 3-day conference that will occur in Orlando, FL. Instead of the typical unlimited number of seats that accompanies the PASS Summit, SQL Rally will be capped at 500 people. … Continue reading SQLRally Call for Presenters
Do You Protect Your Passwords?
Protect Your Password!As a consultant, I am frequently receiving new passwords at clients and becoming aware of the password practices of others. One of the most shocking things I’ve come to discover is how loose people are with their passwords. At times, I am even included in this group. Over the past two years, I’ve … Continue reading Do You Protect Your Passwords?
XQuery for the Non-Expert – Resources
Learning XQuery can be a pain. There are a lot of different uses for XML and different languages implement it in many different fashions. To help clear the air a bit, I wrote a number of posts on XQuery; which this post is a part of. Now that I’ve posted my initial posts on what … Continue reading XQuery for the Non-Expert – Resources
XQuery for the Non-Expert – Exist
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In the previous post, I discussed the value() method as part of my XQuery for the Non-Expert series. This next post will deal with a topic similar to the exist() method – the determination of whether a element … Continue reading XQuery for the Non-Expert – Exist
XQuery for the Non-Expert – Value
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In the last post, I discussed the query() method in my XQuery for the Non-Expert series. With this next post, we’ll be working on taking data out of the XML fragments and placing them into columns with the … Continue reading XQuery for the Non-Expert – Value
XQuery for the Non-Expert – Query
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In the last post, I discussed the nodes() method in my XQuery for the Non-Expert series. With this next post, we’ll be looking into the query() method. The main use for the query() method is to retrieve child … Continue reading XQuery for the Non-Expert – Query