Speaking at SQLSaturday #413 Denmark

Speaking at SQLSaturday Copenhagen, DenmarkCopenhagen 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! :)

Redgate SQL Prompt 6.5 Tab History

Redgate SQL PromptHello, 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 →

Speaking at 24 Hours of PASS: Growing Our Community

I'm speaking at 24 Hours of PASS: Growing Our Community24 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 :)

Preparing for and taking exam 70-462 (Administering Microsoft SQL Server 2012 Databases)

Microsoft Certified Solutions Associate (MCSA): SQL ServerOne 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 →

Roundup of T-SQL Tuesday #66: Monitoring

T-SQL TuesdayT-SQL Tuesday #66 was hosted by me on May 12th. The topic of the month was Monitoring. We all monitor something while working with SQL Server, and this month’s blog posts covers all kinds of topics by DBAs, developers and BI professionals.

T-SQL Tuesday #66 blog posts:
• Aaron Bertrand (@AaronBertrand) shows how you can use trace flags to babysit slow backups or restores.

• Andy Yun (@SQLBek) reminds us that monitoring in development is important too! Deal with problems before they reach your production environment.

• Angela Henry (@SQLSwimmer) tells how she became a better DBA by creating her own monitoring solution, and how having a monitoring solution in your toolbox can save you from having to look for a new job!

• Ben Miller (@DBAduck) shares his PowerShell script for monitoring tables to watch trends of growth and activity in a database.

• Boris Hristov (@BorisHristov) encourages IT managers and decision makers to ensure that teams also show how to monitor solutions, and not just implement the latest cutting-edge technologies and expect it to work immediately.

• Cathrine Wilhelmsen (@cathrinew) shows an example of a Real Time Monitoring solution developed in her company.

• Chris Sommer (@cjsommer) points out some of the most important things a DBA must monitor, and also links to his recent post about Monitoring SQL Server Agent Jobs by using PowerShell.

• Daniel Mellor ‏(@sqlsanctum) shows you step-by-step how to use the Utility Explorer to create a dashboard for monitoring and baselining SQL Server CPU and storage resources.

• Ed Leighton-Dick ‏(@eleightondick) explains how to use tables in the msdb database to monitor your backups.

• Jason Brimhall (@sqlrnnr) discusses different monitoring approaches and methodologies.

• Jason Hall (@SQLSaurus) reminds us to monitor the monitoring systems, they are also important parts of your environment.

• Jeffrey Verheul (@DevJef) writes about different solutions you can use to monitor your environments.

• Kenneth Fisher (@sqlstudent144) writes about a three tiered approach to monitoring when your company is unable to invest in monitoring solution licenses for hundreds of instances.

• Lori Edwards (@loriedwards) reminds us that effective monitoring is more than just a high number of alerts.

• Malathi Mahadevan (@sqlmal) uses a combination of third-party tools, out-of-the-box tools and custom tools to monitor environments.

• Michael Bourgon ‏(@Mbourgon) shares a PowerShell script for capturing multiple servers’ Event Logs to a database.

• Mickey Stuewe (@SQLMickey) created a custom solution to monitor all reports and shares the scripts used.

• Nicky van Vroenhoven (@NickyvV) joins the T-SQL Tuesday blog party for the first time and shares what is important for him to monitor as a SQL / BI developer.

• Richard Douglas (‏@SQLRich) writes about the sneaky Error 825 that disguises itself as just an informational message and why this should be explicitly monitored.

• Rob Farley (@rob_farley) shows how to monitor skew in PDW and how it should be tracked over time when your data changes.

• Robert L Davis (@SQLSoldier) explains how to make sense of errors in the Replication Monitor.

• Robert Pearl (@PearlKnows) writes about how important it is to monitor your systems for a healthy SQL environment.

• Robert Verell ‏(@SQLCowbell) shares how to use WMI and WQL with the native alert system to monitor security.

• Steve Jones (@way0utwest) takes a more philosophical approach to monitoring and talks about why it is important to capture and monitor specific information that is critical to you.

• Steve Thompson (@Steve_TSQL) shows how to identify potential bottlenecks by using Performance Monitor.

• Tim Peters (@tpet1433) uses the Legend of Zelda Triforce to illustrate how solutions can be both easy, helpful and cheap.

• Volker Bachmann (@VolkerBachmann) shares his step-by-step approach to implementing base monitoring.

• And finally Björn Peters (@SQL_aus_HH) joined T-SQL Tuesday with a German post: Self-Repairing-Monitoring Solution oder was einem noch so versprochen wird.

Key takeaways
Monitoring is a very wide, but also very important topic for all of us. Be proactive and monitor your databases, servers and environments (even test and development), and make it a goal to discover issues before your end users alert you. Invest in vendor solutions, use the tools available in SQL Server or write your own custom solutions, just make sure you monitor what is critical in your company. Capture data to see trends over time and use PowerShell to automate tasks. Also don’t forget to monitor the monitoring solutions!

Want to participate or read more?
Monitor the #tsql2sday hastag on Twitter the first week each month for the invitations. Steve Jones (@way0utwest) keeps an updated list of all previous T-SQL Tuesday Topics. If you ever need inspiration to write a blog post, just pick a topic and write away.

Thank you again to everyone who participated in T-SQL Tuesday #66! :)

Page 10 of 23 « First...8 9 10 11 12 ...20 ...Last »