Peter revisits an earlier tip on how to use stored procedures to speed up your code. This version makes your stored procedures simpler … though you may have to write a little more code to make the call.
In the real world, you'll often need to display constant and repeating data, a.k.a. Master/Detail pages. Custom templates are the cleanest, simplest way for you to manage them.
Peter reviews some of the more spectacularly incorrect things he's told other people and then draws some conclusions.
Microsoft said a new Always Encrypted security feature highlights its upcoming SQL Server 2016 -- "the biggest leap forward in Microsoft's data platform history" -- shipping this summer in a public preview.
Microsoft believes Windows 10 will be big for consumers, and an even bigger opportunity for developers. The company trotted out nine more solutions that should keep developers busy.
- By Tony Champion
- 05/01/2015
The company packed quite a bit into a three-hour keynote that spanned the spectrum of Microsoft technologies and hardware. For developers, the emphasis was on cross-platform app building, with new tools built right into the next Visual Studio 2015.
- By Michael Domingo
- 04/29/2015
Microsoft pulled its SQL Server 2014 Service Pack 1 after numerous reports of installation errors.
Stored procedures can speed up your code by reducing trips to your database -- even if you only have one SQL statement to execute. Here's how to speed up your application (and how to simplify your stored procedure code).
Microsoft announced general availability of its NoSQL service for developers and IT pros.
As Microsoft continues to offer newer, more innovative data platforms in the cloud, the SQL Server flagship is languishing. Here's what Microsoft needs to do to ensure it moves forward.
- By Andrew Brust
- 04/07/2015
The .NET Framework has two collections that will guarantee your items are always sorted whenever you process the collection. Here's how to choose between the two and how to control the sort order (including supporting duplicate entries).
If you think Bert is all talk when it comes to his decade of C# experience, you're wrong. He delivers…15 times.
You don't have to give up on creating dynamic queries just because you're using Entity Framework. Entity SQL and ObjectQuery will let you generate queries at runtime and still let you update your data through Entity Framework.
If there's one life lesson to be learned here, it's that just because a manager knows how to write code, it doesn't mean that they should be allowed to write code.
There once was an invoicing system that, when it worked, it worked very well, indeed. But when it was broken, it was horrid.
Now that you know how to work with multi-swarm optimization, it's time to take it up a level and see how to train your network to use it.
- By James McCaffrey
- 02/04/2015
You don't have to give up using dynamic SQL just because you're using Entity Framework. The Entity Framework SqlQuery method will give you back the flexibility of dynamic SQL and still let you work with your data in an object-oriented way.
Make Visual Studio do the hard work to simplify the creation of external lists that can be used to connect outside data to your SharePoint projects.
- By Malin De Silva
- 01/12/2015
Peter shows how a Visual Studio database project can make you more productive when making changes to your database. But a database project also gives you a variety of tools to let you keep track of what those changes are -- which will make moving those changes to your production environment considerably safer.
Peter learns something by listening to readers: Visual Studio database projects provide a great environment for making changes to your databases. Here's a brief introduction about how they'll make life easier for you and all the steps for setting one up.