Small Changes Can Make A World Of Difference
SQL Server 2012 is best known for its bombastic new features: AlwaysOn, Columnstore indexes, Window functions enhancements, Extended...
top of page
Madeira Team
Sep 19, 20121 min
What I Expect From 24 Hours Of Pass
24 Hours of Pass is tomorrow. If you haven’t registered yet, now is a good time. I expect to: Have little to no sleep time See some cool...
Madeira Team
Sep 8, 20122 min
5 Performance Killers When Working With Linked Servers
It’s important to write the right code on the right server, since each mistake can be very expensive in this area. Below are a few common...
Madeira Team
Aug 27, 20122 min
Finding The Needle In The Haystack
Imagine the following scenario: After a very nice weekend, you get up in the morning with a smile on your face, get to work and drink...
Madeira Team
Aug 19, 20123 min
In Case You Really Have To Use Cursors
Cursors (and partially while loops) have a really bad reputation in the SQL Server world. Basically, there are three good reasons that...
Madeira Team
Aug 4, 20124 min
Protect Against SQL Injection Using Triggers
Before I became a SQL Server DBA, I used to be a web developer in ASP3. Since then, I sometimes maintain the websites I still have. Fix...
Madeira Team
Aug 1, 20127 min
Dynamic Search Queries versus SQL Injection
Dynamic Search Queries SQL Injection is a widely known issue with databases that work as back-ends for websites and applications. In the...
Madeira Team
Jul 27, 20123 min
SQL Server 2012 Snippets For Download
SQL Server 2012 introduced a new feature – code snippets inside Management Studio. And even better, you can create your own snippets....
Madeira Team
Jul 27, 20121 min
SQL Azure default isolation level
I came across Bob Beauchemin’s post, stating that the SQL Azure default isolation level is read committed snapshot. This is generally...
Madeira Team
Jul 27, 20121 min
Free TempDB allocation performance booster
One of our main processes was performing badly. During the investigation, we found that most of the time is wasted on creating temporary...
bottom of page