If you are using Azure SQL Databases (PaaS), over time, your database may need to be tuned to account for how your application accesses data. Azure has a feature called SQL Database Advisor, which will make suggestions on changes that can be applied to help your database perform better. Azure SQL Database Advisor provides guidance […]
Tomorrow, November 20th, I will be speaking at Azure Cloud DevCamp event at the Microsoft Tampa office. This is a fantastic event. I presented at the Fort Lauderdale stop a few weeks ago and had a blast doing so. My session will cover Data (SQL, Blob, Big Data w/ HD Insight). Come and learn how […]
I use SQL Server Database Projects to manage my project’s DB schema changes and keep them version controlled. I recently got a new laptop and installed SQL Server 2014 on it. When I started a new project and tried to import the new schema into Visual Studio 2013, I ran into this error: “Could not […]
This Saturday, September 27th, SQL Saturday is coming to town again. This is a yearly event hosted at Seminole State College – the same place where we host Code Camp. This is Orlando’s 8th SQLSaturday and this year will be better than ever with more than 50 different speakers giving over 50 presentations – all […]
When TFS 2010 was released, the TFS database structure was changed to accommodate the new concept of Collections. They also changed the warehouse database – the place where data from project collections is gathered (and optimized for reporting). That database houses the data the will later be processed into the Analysis Services cube. If you […]
I’ll preface this by saying that up until the point that I needed to do this, i knew very little about the database structure that supports SharePoint. I intentionally deleted the SharePoint portal used by one of my Team Projects. The reason for it was that I wanted to implement a brand new structure, along […]
Virtual Brown Bag – October 7th We are hosting Entity Framework super-expert Julie Lerman tomorrow Thursday at noon via LiveMeeting. Register: https://www.livemeeting.com/lrs/8000181573/Registration.aspx?pageName=b8fb1wkwg0h6dfmx. NerdDinner – October 7th Join us at Milennia Mall at 7 pm on Thursday to talk about the Virtual Brown Bag. Also, if you have any Windows Phone 7 apps that you are […]
In less than 2 weeks, our friends at Orlando PASS will be hosting SQL Saturday#49. This super successful series has been around for 3 years and it actually got started right here in Orlando. This is not just for DBA’s, if you are involved with SQL Server in any capacity, there is something for you! […]