It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

Using a predictive technology inside something that moves your data around really makes sense sometimes although not a lot of people are taking advantage of it. Let me show you how to use the two together

Many DBAs take routine database maintenance for granted. What they don’t understand is that the cumulative effect of poor database maintenance can significantly hurt performance. In this session, you will learn the key things all DBAs need to know in order to maintain their databases at peak performance.

Although test-driven development is now considered common sense in the OO world, it is very rare in database development. This session looks at the reasons behind this and presents solutions and best practices for test-driven database development. Database TDD and testing is analysed from two aspects: unit-testing in the database (stored procedures,views) and integration testing from the object service/web layer down to the database. I also present DbFit, an extension to FIT/FitNesse that makes database TDD easy
This session is aimed at database developers, technical architects and Java/.NET developers working on enterprise applications.

Database availability is important to every DBA and selecting the right solution to satisfy availability requirements can be a difficult choice. Attendees will be presented with an overview of each technology and complementary technologies enabling them to make better choices of availability solution.

Come to this session to see how you can create a logging, monitoring and profiling solution for your existing or new SSIS packages overcoming all usual problems that a typical solution brings: increasing package complexity, longer development times and so on. The session will propose a standard, out-of-the-box solution for all of these challenges.

SQL Server is regularly targeted by hackers as it is a repository of sensitive data for organizations. If breached, hackers can gain access to confidential information including, but not limited to credit card numbers, social security numbers, and marketing information. This presentation covers topics pertaining to best practices and tips on how to secure and harden a SQL Server 2008 & 2005 implementation. Some of the security and hardening topics covered include: minimize surface area with policy based management, encryption, advanced auditing, configuring a Windows Server 2008 firewall, applying security templates with Active Directory, and consolidating SQL Server logs.

In this session I will be bringing together all the components of SQL Server to illustrate what happens when you issue a query from a client. From the TDS packet, through ODS, the optimizer and the buffer manager to returning the result. I'll walk you through when the transaction log is used, what happens when a checkpoint occurs and what the lazy writer does.
I've illustrated the process in a way that's easy to consume and helpful to put SQL Server's architecture into context.

What does it mean that my index is fragmented? Why do I get a warning about index record sizes? How should I store images in SQL Server? Knowing how SQL Server stores data and what options there are to control this can help you to build more efficient applications. In this session we will look at how table and index data is stored on disk. We will look at the various data types available, from bits to filestreams, how indexes can be used to optimize read or write performance, and how row and page compression work.

Discover how to build a real world SSIS package. Learn how to set up a package configuration, Manipulate package variables. Process multiple files and capture errors. Learn some workarounds for SSIS limitations (bugs).

I've been in more than one situation where I was asked to tune a system where they had thrown a years salary in hardware at the problem already. Only to find out that the app would run just 3% faster or even 10% slower !
I'll bring some examples and will show you what I did and why. This is not just for DBA's, DEV's should also get at least one usefull thing out of this session.

Among many of its functions, MDX language has one special set function - Axis() function. That function allows creation of calculated measures that are context aware and, if wanted, don't need to refer to any dimension or hierarchy in the cube. In other words, such measures are universal or independant, which means they can be used in any MDX query.
In this session we will present such measures and explain how they work. We'll also show the way how to design them for various scenarios and discuss their potentials and weaknesses.
Previous experience in writing MDX queries is recommended.

SQL Server upgrade is no easy job, as DBA must go through upgrade methodology with options and considerations. Take help of freely available Upgrade tools from Microsoft and plan your database upgrade with a coverage of
Pre-upgrade tasks, during upgrade and Post upgrade tasks.

About

SQL Bits was started by a group of individuals that are passionate about the SQL Server product suite.
There is a breadth of knowledge in the SQL Community that will benefit everyone in the community.
We want to spread that knowledge.

We all work with the SQL community, some of us for many years. We have a range of skills and experiences from being given the MVP award by Microsoft, organising user groups and speaking at events around the world.