Latest Blog Posts
We, the SQL Saturday Orlando Team, are hard at work getting ready for the event. Our Call for Speakers ends…
Thanks to everyone who attended my 24 Hours of PASS session, The Data Loading Performance Presentation.
It was a lot of fun taking part in such a special event.
The slide deck and scripts I used in the session can be downloaded here.
Object-Oriented programming taught us that generalizing is a good thing and, whenever possible, we should do it. Complex class hierarchies are a good way of reusing code, hitting the specialized classes only when a special implementation is needed.
In the database world, the concept doesn’t play exactly well.
The next oPASS meeting is tomorrow night (June 25, 2015):
DBAs do not always have time to work with some of the amazing visual data tools that are becoming common place now for analysts. In this presentation I will show how in just a few very easy steps you can…
We’re planning to run one or two (or maybe even three) seminars (aka pre-cons) in conjunction with SQLSaturday Orlando 2015. What are we looking for?
- An interesting topic. I know that’s vague, so let’s say we want a topic that will be of interest to 15+ people willing to…
It isn't a Pre compare script
When you use SSDT to deploy your dacpac, a pre deployment script lets you run some T-SQL scripts before the script which brings your database up to date with your dacpac.
The important thing to note is that the process is:
- sqlpackage compares the…
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
I had the need recently to get put an extended property on a table in a database. I could easily have done this in SSMS, and have used… Read more
SQL Server has the concept of fill factor for leaving extra space in pages to reduce the number of page splits. If you picture library shelves, it’s like leaving space for a couple new books on each shelf. It’s a trade-off though, putting in that space may reduce page splits… Read more
Our long #SQLVacation is nearly at an end because our stop in Evansville, IN is our last roadtrip location for the family and the penultimate (i.e., second to last) technical session of the journey. It’s a bittersweet, fersher.
Evansville is such a beautiful place that it was name La Belle… Read more
This is a post that is looooong overdue. I have intended to write some of this at least since the first SQL Cruise I attended back in 2013 (in the Caribbean). Now with three Cruises under the belt and plenty of awesome experiences, it is high time to follow through… Read more
Earlier this week I was scripting out a table with some legacy columns (InsertDate and InsertBy for example). If you have created these type of columns before you have probably put a default on each. InsertDate is pretty easy, probably something like GETDATE() or GETUTCDATE(). But what do you… Read more
Few minor fixes
Leveraging SQL Server Database Schema
Thank you all for attending my MSSQLTips webinar today with Sumeet Bansal from Tegile Systems! In the presentation, I made reference to a disk stall collector that you can use to help collect and store database file-level latency statistics into a database for future reference, as well as an… Read more
Last week, Redgate Software had a large company meeting and our annual Day Out, with myself and a few dozen of our US employees in the UK for meetings and the event. It was fun, and a good time. I haven’t been to a company meeting live in 6 or… Read more