(Harishkumar Baburao Pathangay) Difference between Authentication Id and Authorization Id Happy Learning & Sharing
Author: SSWUG Research
The 7 Types of Database Design Reviews
(Craig S. Mullins) A little more than two years ago I wrote about The Importance of Database Design Reviews here on this blog. The general idea of that post is that reviewing the scope and content of a database implementation before it moves to production is an important aspect of database systems a
What SQL is running in MySQL
(Ronald Bradford) Using the MySQL 5.6 Performance Schema it is very easy to see what is actually running on your MySQL instance. No more sampling or installing software or worrying about disk I/O performance with techniques like SHOW PROCESSLIST, enabling the general query log or sniffing the TCP/IP
SQL Server Database Engine Performance Tuning Basics
(Indrajit Ghosh) As the market share of SQL Server grows over time, there has been a increasing demand for SQL Server performance tuning. There has been various approaches taken by different teams and individuals for improving the performance of the SQL Server, and I think it might be beneficial to
Configuring SQL Server Agent for SQL Server 2012
(Mike Chapple) SQL Server Agent allows you to automate a variety of administrative tasks. In this tutorial, we walk through the process of using SQL Server Agent to create and schedule a job that automates database administration.
Migrating SQL Server Database to Windows Azure – Deploying SQL Database
(Marcin Policht) In our articles published on this forum, we have been discussing challenges associated with deployments of data services in Windows Azure, focusing in particular on SQL Database.
What’s New in SQL Server 2012
(Ray Rankins, Paul T. Bertucci, Chris Gallelli and Alex T. Silverstein) With SQL Server currently on a 2-year release cycle, each release is more of an evolutionary change from the previous release than a revolutionary change. Therefore, Microsoft SQL Server 2012 is not a quantum leap forward from S
Welcome to the Family, One ASP.NET
(Rion Williams) Prior to the introduction of ASP.NET MVC into the .NET Framework in 2009, a .NET developer that needed to create a site or web application had one choice : Web Forms. When MVC came along however, the water became a bit muddled and developers had a major choice to make when starting u
ASP.NET Identity System in Visual Studio 2013 – New Feature
(Abhimanyu Kumar Vatsa) In this post you will learn about a very new enhancement in ASP.NET Framework technologies (MVC, Web Forms, Web Pages, Web API and SignalR) known as ‘ASP.NET Identity System’ with the release of Visual Studio 2013. This enhancement well defines the meaning of ‘One ASP.NET’, b
Introducing ASP.NET Web API Throttling handler
(Stefan Prodan) ASP.NET Web API Throttling handler is designed to control the rate of requests that clients can make to a Web API based on IP address, client API key and request route.