Sparse Columns
One of the basic rules when creating or altering a table is to configure and adjust the right columns properties such as data types and...
top of page
Madeira Team
- Feb 22, 2012
- 2 min
A Journey into SQL Server 2012
On February 20th I attended the Microsoft event – A Journey into SQL Server 2012. The event was very interesting, and included many great...
Madeira Team
- Feb 17, 2012
- 6 min
Foreign keys and how they help the optimizer
I love foreign keys. In my opinion they just make perfect sense. They keep my data “clean” and consistent. Whenever two tables need to...
Madeira Team
- Feb 12, 2012
- 3 min
Central Management Servers
At first, let’s start with a cool relaxation exercise. Close your eyes and imagine that your DBA work environment includes only one...
Madeira Team
- Feb 8, 2012
- 6 min
Using Reporting Services as your Software Frontend
Microsoft SQL Server Reporting Services is an excellent and easy-to-use platform for creating, viewing, managing, and subscribing to...
Madeira Team
- Feb 2, 2012
- 3 min
Log Shipping – As easy as 1, 2, 3
Today I want to talk about Log Shipping. Log Shipping is an easy way to implement a high availability solution. It uses SQL Server’s...
bottom of page