Lately I have had the opportunity to work with performance tuning of queries running on the Azure Parallel Data Warehouse (Azure PDW). This has been interesting in that everything you thought you knew about SQL Server DMV’s, writing queries and overall performance tuning is just a little bit different. My goal was to write a query to show me what …
On Wednesday January 25th at 6:00pm we will be hosting the monthly meeting of the Bellingham SQL Server Users Group. January SQL Server Users Group In-Person @ 709 West Orchard Drive #4 Bellingham, Washington 18:00 – 20:00 (UTC-08:00) Pacific Time (US & Canada) Language: English January 25th, 2017 – Bellingham SQL Server Users Group. For the January meeting of the …
Bellingham SQL Server Users Group – January 25th Read more »
This weeks episode we are pleased to host Andy Leonard to discuss his thoughts on the catalog and how this feature provides some really interesting benefits for ETL architecture. Although the SSIS Catalog DB is created with management studio, it does not behave like other databases. Our conversation in this episode revolves around the catalog, SSIS packages, and some of the complexities of migrating …
Podcast Episode 79: SSIS Catalog with Andy Leonard Read more »
One of those services that I offer is on call help for DBA’s who encounter database corruption. Call me anytime 24/7 and as long as you are an existing customer, or we can work out a billing arrangement to turn you into a paying customer, I can help. That’s all a good if you are familiar with what database …
Here is a quick update on the last 3 podcast episodes that we have published, ending up 2016, and starting out 2017 with some great information from Paul Turley, Jimmy May and Argenis Fernandez. Episode 77: New Reporting Options with Paul Turley We invited Paul Turley on the show to chat with us about some of the new features in …
Today I had the opportunity to present on TempDB to the Spokane SQL Server users group (PASS Chapter). The session was titled TempDB – Do This and Don’t Do That”, and it covers a bunch of tips and best practices around what to do and avoid relating to TempDB on your SQL Server. Here is the download of the presentation and …
Today we released the Database Health Monitor January 2017 version. You can download it for free at http://DatabaseHealth.com/Download. This update includes some new branding with new logos, new icons, and a new splash screen, as well as the usual feature enhancements and bug fixes. So far since we started tracking downloads there have been 11,100 downloads of Database Health Monitor worldwide. …
Database Health Monitor – January 2017 Version Released Read more »