Many people get confused, thinking that SQL Server Profiler is the actual tracing feature of SQL Server, while in fact it is only an...

Last Sunday I presented a session by the name “30 Things You didn’t Know about SQL Server” together with Noam Brezis. We presented this...

Microsoft is working hard on pushing a SharePoint server and integrating every reporting aspect in it, from the new PivotTable to...

Our presentation booth at the Data Platform conference included an SQL Server challenge.  Many people participated in trying to solve the...

Recently I have made my self aware to the old fact that when I tune a query, I always use the same 3 procedures over and over again:...

Database fixed roles are predefined roles with specific permissions that allow their members to take actual roles in the organization....

Working as an operation manager and DBA often requires me to examine and produce statistical reports and devise actions based on them. I...

SQL Server Magazine is a great resource for SQL Server DBAs. It offers professional articles, white papers, code samples, blogs, and...

If you ask any SQL Server DBAs about cursors, they will tell you it’s a big no-no. If you search for T-SQL best practices on the web, in...

Recently I was asked by one of our customers about querying XML in a relational format. “Sure”, I answered, “you can use OPENXML to...