What do you do when you need to enforce referential integrity across databases on the same SQL Instance, or maybe on a different instance or server altogether? This kind of eventuality occurs often in data warehousing where sharding I used to increase performance, or sharded OLTP databases separated for performance, often seen in MySQL large scale implementations. Some implementations attempt […]
Other News
SSWUGtv: Keeping up with your cloud provider’s features.
Video Programming for IT Professionals
Microsoft SQL Server security best practices checklist – Part -1
Microsoft SQL Server security best practices checklist – Part -1 Author: Basit A. Farooq Database technologies are an essential component of many information systems because they store a large amount of sensitive corporate data such as customer information and other confidential business data. Because of this, it is not wrong to say that databases such as SQL Server are the...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Gotcha: Entity Framework gets slow in long Iteration Loops
(Rick Strahl) Thought I’d highlight a common problem I’ve run into a few times with a few of my customers using Entity Framework.
Extending Editor Templates for ASP.NET MVC
(Nick Harrison) If you find yourself doing routine work repeatedly in ASP.NET MVC, it is worth exploring the possibilities that come from modifying or creating Editor Templates in Visual Studio.
Azure SQL Server Database
(Derek Wilson) You can create and leverage cloud based SQL Server instances using Microsoft Azure. However, if you have never used the Azure portal it can be a bit challenging to get started. This post will show you how the steps required to create an Azure SQL Server database.
Importance of Statistics and How It Works in SQL Server – Part 1
(Arshad Ali) Statistics refers to the statistical information about the distribution of values in one or more columns of a table or an index. The SQL Server Query Optimizer uses this statistical information to estimate the cardinality, or number of rows, in the query result to be returned, which ena
A First WPF Application for WinForms Developers: (7) Button Content, Validation, Regex, StringBuilder
(Ged Mead) Up to this point I’ve concentrated mainly on the UI for the WPF application I’m building as a demonstration. In this part, I’m going to build a version of the code that’s used to provide the words that are displayed to the user. I say ‘a version’ because initially I’m going to try and k
Polyglot Apps for iOS, Android and Beyond
(Greg Shackles) Did you know you can combine C#, F#, Visual Basic, Razor, HTML and JavaScript within a single app?
Datepicker in jQuery
(ashish) jQuery has many different types of widgets which makes it easy to add different types of functionalists in our applications.One commonly used widget is Datepicker.