Latest Blog Posts
Major expectation raised by user for SharePoint other then Search ,is to have Good User Experience and Faster in it operation.
In Order to improve SharePoint User experience, Microsoft added a new feature called Distributed Cache service, it cache frequently requested information and made it available quickly to… Read more
In my previous post in the series, I provided a short explanation on how to register your very first Azure DocumentDB account and play around in the Azure Portal.
If you haven’t read it yet, please read it first here: http://www.madeirasql.com/my-first-azure-documentdb-account
In this post, I’ll help you get started with… Read more
The PASS Summit 2015 Speaker list has been released and I wanted to congratulate everyone that was accepted. It’s a great honor and I’m proud to be on the list once again.
I also apologize to everyone that submitted and wasn’t accepted. I hadn’t planned on submitted, but part of… Read more
All good things must come to an end and, after logging almost 1400 miles on the road, the #SQLVacation road trip returns to its home city – Nashville, TN, the “Music City”. Eight SQL Server users groups, eight matching blog posts, two hundred t-shirts, and many hundreds of… Read more
I have an exciting training session announcement! On Friday, July 10th, I will be presenting a full-day training class ahead of the SQL Saturday event in Columbus, OH entitled “SQL Server Virtualization for VM Admins“. (DBAs are very welcomed too!)
Abstract: This full-day course is an introduction… Read more
Today should be such an exciting day, the day the speakers are announced for the 2015 PASS Summit. But as someone who has been involved with the process for the last 6 Summits, it’s a day that I usually turn my Twitter feed off because there’s always those one or… Read more
I was thinking today about why I submit sessions to speak at the PASS Summit.
Kicking off the SQLSaturday#410 event down in Chattanooga, Tennessee, is the Pre-Con event Tune Like a Guru, by SQLGuru Kevin Boles, covering a wide array of topics that form the backbone of my SQL Server performance analysis and tuning work. As a long-time relational engine consultant Kevin has repeatedly found… Read more
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.
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