Compares and contrasts tracing using Profiler with server-side tracing, illustrating important performance differences so that one can choose the right tool for the task at hand.  Read more...

My organization is looking at SQL Server 2012 and I know that the ability to create roles at the server level is a new feature. Since this is new and impacts security, how do I handle them and how do I audit them?  Read more...

Quite often, the database developer or tester is faced with having to load data into a newly created database. What could be simpler? Quite a lot of things, it seems.  Read more...

Splitting strings based on patterns supported by LIKE and PATINDEX can be an interesting way to address a wide variety of problems.  Read more...

Get a free ebook that discusses how you can better manage your team development.  Read more...

I have a busy SQL Server and notice that several queries are running in parallel. I know I can set the max degree of parallelism setting, but what MAXDOP should I use?  Read more...

The tenth article of this series starts to look at more advanced events and how we can use those events to better control and enhance our packages.  Read more...

SQL Server 2012 introduced an unified BI Semantic Model (BISM) which is based on some of the existing as well as some new technologies. This model is intended to serve as one model for all end user experiences for reporting, analytics, scorecards, dashboards, etc. In this tip, I will talk in detail about the new BISM, how it differs from earlier the earlier Unified Dimensional Model (UDM) and how BISM lays down a foundation for future.   Read more...

SQL Saturday at the gateway between Europe and Asia. If you are nearby, come join in a free day of SQL Server training and presentations.  Read more...

If you have not been capturing baselines on your production servers, then today is the day you can start. This article provides scripts, valid for SQL Server 2005 and higher, which anyone can use to capture basic information about a SQL Server instance.  Read more...

The backup and restore system in SQL Server hasn't changed a great deal over the years despite a huge growth in the typical size of databases. When disaster strikes, and an important service is taken offline while a restore is performed, there is often time to reflect on whether it might be possible to design databases for a more rapid recovery of the most critical parts of a database application.  Read more...

A free day of training, SQL Saturday comes to Tokyo, Japan. Come have a SQL Server day with fellow data professionals if you can.  Read more...

This level will examine the most common problems and forms of mismanagement that lead to excessive growth of the transaction log.  Read more...