SQLCruise – Learn. Network. Relax. Grow… Just add water.
I recently attended my first SQLCruise, and trying to summarize a week full of experiences is difficult. Let me skip straight to the important part:
Did I learn anything?
Was it worth it?
Would I attend again?
Continue reading →
Copenhagen is one of my favorite cities and I’m so happy that I get to visit it again for SQLSaturday #413 Denmark on September 19th! This is the third SQLSaturday in Denmark and it is bigger than ever with two days of pre-conference workshops and one day with regular sessions. I will present one of my newest sessions: Upgrading from SSIS Package Deployment to Project Deployment.
Thursday, September 17th
Self-Service BI – Power BI by Dandy Weyn (@ilikesql)
From 0 to DAX by Alberto Ferrari (@FerrariAlberto)
Friday, September 18th
Analyze and document your SQL Server like a professional / consultant by Uwe Ricken (@dbBerater)
Inside SQL Server Plan caching and parameterization by Margarita Naumova
Data Mining Algorithms in SQL Server, Excel, R and Azure ML by Dejan Sarka (@DejanSarka)
New Index technologies: Clustered ColumnStore and In-Memory OLTP: the good and the bad by Andreas Wolter (@AndreasWolter)
Saturday, September 19th
A whole day of great 1-hour sessions, including a SharePoint track, an academic track and hands-on sessions. And don’t forget to visit the Ask the Experts corner for personal help from the speakers!
See you in Copenhagen in September! :)
Hello, my name is Cathrine, and I am a tab hoarder :) I always have lots of tabs open in SQL Server Management Studio (SSMS) connected to different environments. I have written about how Redgate SQL Prompt Tab Coloring makes it easy to find the right tab(s) based on the tab color, but that is not the only tab feature that saves me a lot of time.
Redgate SQL Prompt Tab History is amazing! It allows you to view and reopen closed tabs, even those unnamed and unsaved tabs with ad-hoc queries that you thought you would never need again. It also allows you to quickly navigate and search through closed and open tabs.
Continue reading →
24 Hours of PASS (@pass24hop) is back! From June 24th 12:00 GMT to June 25th 12:00 GMT you can watch 24 free webinars back-to-back. Check out the great schedule and register today!
I’m super happy and excited to have been selected as a speaker at this edition of 24 Hours of PASS. The theme for this event is Growing Our Community. They only accepted abstracts from speakers who have not yet spoken at PASS Summit to give us the opportunity to gain experience and share our knowledge outside our local communities. I love this idea, and I’m so happy to see good friends and talented up-and-coming speakers selected :D
My session is called Don’t Repeat Yourself – An Introduction to Agile SSIS Development. It is based on my introduction to Biml session and I will reuse a lot of that content, but I have tweaked and expanded and changed a few things so it’s no longer just about the Biml language. Hopefully it can inspire those who are still developing SSIS in the traditional way to try a new approach to automating their development and work more efficiently :)
One of my goals is to become a Microsoft Certified Solutions Expert: Business Intelligence. I decided to start from scratch and take the three exams required for Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 to learn as much as possible. I passed exam 70-461 (Querying Microsoft SQL Server 2012) in January and I passed exam 70-463 (Implementing a Data Warehouse with Microsoft SQL Server 2012) in April. I decided to take exam 70-462 (Administering Microsoft SQL Server 2012 Databases) last. I passed in May :)
Preparing for the exam
Studying for the 70-461 (Querying) and 70-463 (Data Warehouse) exams was mainly about learning new 2012/2014 features and learning features I had not used as much in real projects. Studying for the 70-462 (Administering) exam was a completely different experience because I had to learn most of it from scratch.
Continue reading →