Visual Studio 2010 includes Entity Framework (EF) 4. Knowing what EF 4 is about and having an idea of how to use it can help you decide whether you want to add EF 4 to you SQL Server development toolkit.
Entity Framework—and Object/Relational Mapper (O/RM) frameworks in general—are fundamental tools for today’s applications design and implementation....More
Entity Framework takes a neutral approach to persistence of models in SQL Server. Learn about the Code-First model, as well as some tips for effective persistence....More
Although the ADO.NET Entity Framework makes application developers' jobs easier, the code it generates can lead to poorly performing applications. Here is what you need to know....More
Find out which decisions you need to make regarding the coding language, data access layer, and development tools before you can begin developing new SQL Server applications....More
LINQ is still a powerful tool for working with SQL Server data and includes new features such as Parallel LINQ (PLINQ) and SharePoint integration....More
At TechEd 2010 I had the opportunity to talk with several of the development tools vendors. So many vendors mentioned that database design should be in the hands of developers rather than DBAs that it’s looking like a trend. An ominous trend based on the supposition that DBAs don’t really understand coding and the development process....More
Visual Studio 2010 includes Entity Framework (EF) 4. Knowing what EF 4 is about and having an idea of how to use it can help you decide whether you want to add EF 4 to you SQL Server development toolkit....More
As summer nears, the Power BI Preview is making bigger waves with every weekly release. Popular data sources and a plethora of Power BI Designer enhancements are being released at light speed pace. Check out the highlights on what has been released and what we might see next....More
Over the past few years we did not hear anything from Microsoft about SQL Server on-premises business intelligence enhancements. The extended cricket-chirping silence left us speculating about the future of Reporting Services, Analysis Services and other key technologies that are being used today to power critical decision making solutions. Good news, the waiting and wondering is over. Microsoft recently announced significant SQL Server on-premises upgrades for business intelligence in numerous presentations at both //build and Ignite conferences....More
In the last few posts (posts 19 – 24) I’ve covered some high-level concerns and reviewed some details about how to implement and manage database backups against AlwaysOn Availability Group databases. Most of the information I’ve provided was pretty basic or elementary – along with some additional guidelines for things to watch out for when managing backups. Which is to say that backups are never something you can simply take for granted and they’re never something you just take lightly....More