Contact Us

In many cases, while we using DBCC commands, we must to run two statements instead of one, in order to receive the wishful result. For example, in order to receive database information, we write: DBCC TRACEON (3604); GO DBCC DBINFO (‘AdventureWorks2012’); GO instead of simple: DBCC DBINFO (‘AdventureWorks2012’); GO So, why we need to use additional statement, why we enable trace flag 3604 before part of the DBCC commands? The answer consists of two parts: 1. Most of the trace

Whether you’re just starting out or already a few years in the game, you’re probably wondering how you can become a better DBA. Here’s what works for me: 1. Learn a Lot…of what you Find Interesting There are no shortcuts – You have to learn. But it’s a lot easier if you focus on things that you find interesting. One of the things I learned over time is that it’s ok not to love something, and trying to force it is just a waste of time. The last brick in the wall of this unders

My friend Boris Hristov (Blog | Twitter) continues his Google Hangouts initiative, and this week he invited me to talk about the best learning resources for SQL Server. We talked about the best Podcast and video sites out there. Due to some technical issues we couldn’t talk about the best blogs, so we will probably have another session about them. Podcasts: SQL Server Radio RunAs Radio .NET Rocks SQL Down Under People Talking Tech Free Video Sites: Channel9 SQLBits PASS Recor

About two weeks ago, I wrote about SQL Server Podcasts and why I love that medium so much. Today, I want to talk about the various video sources for SQL Server (luckily for us, there are lots of them). The video medium is great because you can view sessions from the top speakers in the world without leaving your chair. If you feel you don’t need an eye contact with a specific session, you can upload it to your phone/USB drive/CD and listen in your car or any other place, just