Latest Blog Posts
For those not aware there are 2 cool local and national events coming to both Melbourne and Gold Coast…
- SQL Saturday 582 (Sat 11 Feb 2017). Melbourne. For those looking for some great free local SQL (and related!) learning, you simply cannot go past a SQL Saturday anywhere in…
Grant Fritchey will be presenting Faster Provisioning with SQL Clone and Denny Cherry is presenting Optimizing SQL Server Performance in a Virtual Environment. The event is being held at Nova Southeastern in Orlando. Register (Free) at https://www.eventbrite.com/e/sql-sons-of-beaches-tour-tickets-30043366518. Hope to see you there!
I was an early adopter of Microsoft’s OneNote and started using it in February of 2004 and have never stopped. I love it for the simplicity of use and ease of collaborating with a team. Team collaboration with Microsoft OneNote is a huge productivity gain and one of the main… Read more
Newly added to the Power BI Service is a much awaited feature called Power BI Subscriptions. If you’ve worked in Microsoft BI in the past this idea is likely familiar to you. This new feature shares some similarities to Subscriptions in Microsoft Reporting Services.
The idea of subscriptions is to… Read more
Well, in v7.3, this is in there, and I didn’t realize it. You can clearly see this in the formatting… Read more
In this module you will learn how to use the Sankey with Labels Power BI Custom Visual. The Sankey with Labels is a type of diagram that visualizes the flow of data between a source and destination columns. This is visual is similar to the visual we showed in Module… Read more
I’ll be teaching my popular day-long course, Building Better SSIS Packages, on Thursday, June 1 in Pensacola, Florida. This class is being delivered in conjunction with SQL Saturday Pensacola. Registration is open to the public, and early-bird pricing is in effect until early May. Let me know if you have… Read more
Last week I published this post about something a colleague noticed when playing around with a SQL Server instance running on Linux. Fairly innocuous and I was chuffed when I saw that the guys over at BrentOzar.com had linked to it in their weekly newsletter.
As the day wore on,… Read more
I’m hosting a new webinar on the DLM tools from Redgate Software and database DevOps. Tomorrow, Tues, Jan 17, at noon EST, Arneh Eskandari, a great sales engineer, will be demoing the tools and techniques to deploy changes.
It’s Monday and time, finally, for a weekly blog and twitter round-up for last week. It’s been a while since I’ve published this summary post, but hey that’s what life is for, getting in the way of things that you sometimes want to be doing. If you haven’t already, follow… Read more
Redgate produces some great software, and I’m glad that I get to use all of them as a developer and DBA. I use many of the tools each week, some daily, but I constantly find that there are plenty of features, tips, and tricks that I don’t know about.
At… Read more
UPDATE: The SQL Saturday in Chicago this year has hit peak capacity two months before the event! However, if you enroll in one of the precons, and hopefully my “The Complete Primer to SQL Server Infrastructure and Cloud” session, email the SQL Saturday coordinators with your EventBrite receipt… Read more
You’ll frequently hear that you should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up the backup chain. Just in case you haven’t: You should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up the backup chain.
But you may… Read more
I’ve been a scribbler for as long as I can remember, in fact I’m not sure that I write everything down because I have a bad memory or if I have a bad memory because I write everything down.
About a year ago I stopped using notepads and tried to… Read more
1) As MS is kept increasing number of option while installation. To reduce no. of click, if setup pass Rules it will automatically moves to Next window.
2) On Server Configuration page, MS specifically ask to GRANT PERFORM VOLUME MAINTENANCE TASK permission to service account. SQL Services needs this access… Read more
This week we started our Centino Systems weekly newsletter. Check out the first edition here!
The newsletter is going to include the latest in SQL Server and other things in technology that I think are important or interesting…and maybe you will too!
So if you’d like to subscribe to… Read more
There are many ways to reap benefits from being a member of the PASS Global Community. Today, as I write this blog, I glance over at twitter for hash tag #SQLSatNash and see all the speakers, volunteers and attendees express their love of this free event. You really never see… Read more