SQLSaturday Oslo 2016 Pre-Conference Workshops

SQLSaturday Oslo 2016 Pre-Conference WorkshopsSQLSaturday Oslo is back for the third time in 2016, and this year we are offering four amazing pre-conference workshops! We are very happy to welcome Microsoft Data Platform MVPs Grant Fritchey, Dejan Sarka, André Kamman and Mladen Prajdic to Norway :)

Early Bird Tickets

Early Bird tickets are available until July 1st. For as little as 1200 NOK you can attend a full day of high-quality training with some of the best experts in the world. (That’s less than 1/3 of what you usually pay for high-quality courses like these!) After July 1st the price goes up to 1600 NOK, so make sure you register soon – and bring your coworkers :)

SQLSaturday Oslo 2016 Pre-Conference Workshops

These four pre-conference workshops will be held on Friday, September 2nd in Oslo:

Grant FritcheyQuery Tuning with Execution Plans
by Grant Fritchey (@GFritchey)
Level 200 – Intermediate
At least 80% of all database performance problems can be related directly to your T-SQL code and your data structures. This full-day workshop gets right to the heart of that issue and shows you how to identify common performance problems using the tools available to you within SQL Server.
(…read more and register)

Dejan SarkaData Mining Algorithms in SSAS, Excel, R, and Azure ML
by Dejan Sarka (@DejanSarka)
Level 400 – Expert
Data mining as the most advanced data analysis technique is gaining popularity. With modern data mining engines, products and packages, like SQL Server Analysis Services (SSAS), Excel, R, and Azure ML, data mining has become a black box. This course explains how the most popular data mining algorithms work, when to use which algorithm, and advantages and drawbacks of each algorithm.
(…read more and register)

Andre KammanPowerShell for DBAs
by André Kamman (@AndreKamman)
Level 300 – Advanced – Half-day
DBAs will learn all they need to know today to start using Powershell as their main tool to deploy, manage and monitor their whole environment. We will talk about error handling, creating modules, building in pipeline support, whatif support, logging, parameters and more general Powershell concepts.
(…read more and register)

Mladen PrajdicSecurity Best Practices for SQL Server and Application Developers
by Mladen Prajdic (@MladenPrajdic)
Level 300 – Advanced – Half-day
In this precon we’ll look at how to implement security conscious patterns and practices for SQL and .Net application development like multilayer security architecture and the pessimistic approach. Demo attacks will include SQL Injection (SQLi), Cross Site Scripting (XSS), Cross-Site Request Forgery (CSRF), Distributed Denial of Service (DDOS), Social Engineering (SE) and respective protective measures. We’ll try to blow your mind with what malicious attackers can do to your organization and how to protect against it.
(…read more and register)

Spread the word

We hope you want to help us make SQLSaturday Oslo 2016 a great event for everyone, so tell your friends and coworkers about these pre-conference workshops! If you’re on Twitter, follow @SQLSatOslo and use the hashtag #SQLSatOslo. The SQLSaturday Oslo team and Microsoft Data Platform User Group Norway look forward to seeing you in September! :)

Get started with BimlExpress

BimlExpressSay welcome to BimlExpress – the newest, shiniest and completely free Biml toy! :) I first mentioned BimlExpress at SQLSaturday Vienna and have been waiting for the official release since then. I’m very happy that I can now send you all over to Varigence’s website to download the Visual Studio Add-in!

What is BimlExpress?

BimlExpress is a free Visual Studio add-in for working with Biml in your SSIS projects. It allows you to add and edit Biml files, generate SSIS packages from Biml, and the code editor is fully featured with syntax coloring, error highlighting and intellisense.

If you are already using BIDS Helper, you will see that BimlExpress works the same way and includes all the same Biml features as in BIDS Helper – just with a new and improved code editor. No more squiggly red lines, yay!

Should I use BimlExpress or BIDS Helper?

Both! :) BIDS Helper is a fantastic, free add-in with a ton of useful features for your Business Intelligence projects. The release of BimlExpress simply means that Varigence can update the add-in and the Biml engine with new features more frequently and separately from BIDS Helper. When BIDS Helper is updated it will include the latest Biml engine. Keep using BIDS Helper, and install BimlExpress as well for the latest Biml features.

And all of you Biml fans agree with me that the new code editor is worth it, right? Right!? :)

Continue reading →

SQLHangout #36 – Why Design Matters with Koen Verbeeck and Boris Hristov

SQLHangout #36 - Why Design Matters with Koen Verbeeck and Boris HristovThe recording of SQLHangout #36 is now available! :) In this episode, Koen Verbeeck (@Ko_Ver), Boris Hristov (@BorisHristov) and I chatted about presentation design, why design matters in your SSIS projects, about new features in SQL Server 2016, and why it is a fun time to be working with Microsoft technologies. It is also a special episode, since it is my first and Boris’ last episode as a host.

SQLHangout #36 – Why Design Matters with Koen Verbeeck and Boris Hristov

 

Check out Koen’s blog Under the Kover of Business Intelligence, take a look at all the great articles he has written for MSSQLTips and make sure you follow him on Twitter @Ko_Ver :)

Past SQLHangouts

All the recorded videos are available in the YouTube playlist and on the SQLHangouts Facebook page. You can find all of Boris’ previous blog posts in his SQLHangout archive, including his latest blog post about SQLHangout #36.

Upcoming SQLHangouts

Do you want to participate in a SQLHangout some day? Let me know! :) If you don’t want to participate in a SQLHangout yourself, but you have an idea for a topic or speaker, use this form or tweet and use the #SQLHangout hashtag.

I also want to say a huge thank you to Boris for everything he has done so far, and for trusting me to take over the SQLHangouts! I’m going to miss you as a host and promise to do my best to keep the SQLHangouts interesting :)

SQLHangouts – The Next Generation

SQLHangoutsI have some bad news and some good news. The bad news is that Boris Hristov (@BorisHristov) will no longer be hosting SQLHangouts. He came up with the idea back in 2013 and have recorded 35 interesting videos, but he will now be focusing on his design agency 356labs.com.

The good news is that SQLHangouts are not dead! Boris has decided to hand it over to me. I must admit that it is a little intimidating to take over a project like this, but I am also really excited and looking forward to chatting with a bunch of wonderful and interesting people in the #SQLFamily :)

SQLHangouts – The Next Generation

The concept is simple – short 30-minute video chats with Microsoft Data Platform and SQL Server experts from all around the world. The videos are streamed live on YouTube and are also recorded and saved for later viewing. Fun!

All the recorded videos are available on the Facebook page and in my YouTube playlist. I have added the first 35 videos to the playlist already, and will add all new videos to it as soon as they are recorded and published.

(You can also find the first 35 videos in Boris’ YouTube playlist, and read all about them on his blog.)

What happens next?

The next SQLHangout is already scheduled for March 30th! In this episode, Koen Verbeeck (@Ko_Ver) and I will chat about why design matters in your Business Intelligence projects. We all know that report design is important, but do we need to care about the layout of our SSIS packages? We will also be joined by Boris, the special guest of the day. We can’t have a SQLHangout about why design matters without chatting about presentation design!

Watch the live stream on YouTube on March 30th at 22:00 CEST (UTC+2), and join the conversation on Twitter by using the hashtag #SQLHangout :)

Notepad++ Word Count

Notepad++ Word CountNotepad++ has some great features for working with text, like macros and column editing. But what about finding information about your text, such as document length and word count? There are several ways to do this in Notepad++.

Notepad++ Word Count

If you have no plugins installed, you can use the built-in Summary function. If you are using the TextFX plugin you can use the Word Count function:

  • Double-click on Status Bar (shortcut to View → Summary)
  • View → Summary
  • TextFX Tools → Word Count

Differences between Notepad++ and TextFX
The Notepad++ Summary only shows the total word count. If you have text selected it shows you how many characters you have selected, but not how many words are in your selection.

TextFX only works when you have text selected, and shows you how many words and characters are in your selection.

More importantly, Notepad++ and TextFX counts words differently. Notepad++ counts hyphenated words as two words, while TextFX counts hyphenated words as one word. (TextFX and Microsoft Word counts the same way.)

Continue reading →

Page 1 of 20 1 2 3 4 5 ...10 20 ...Last »