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.

Find out how the new SQL Clone enables self-service easy automation of database copies, near-instant at the time of need, using a fraction of the disk space, and allowing quick reversion to a baseline.

In this purely demo-based session, I will show several real-life attacks, from mere reading up to disrupting service availability via various types of manual and automated SQL Injection, including a broadly unknown elevation of privileges attack.

This session covers all aspects of what you need to do, to enable the storage of card details in SQL Server and achieve PCI certification.
We will deep dive into the solutions for storing the data securely using SQL Servers encryption functionality

Everyone knew how to keep data safe and secure, right up until Edward Snowden revealed this error. Learn how to keep the data secure, by identifying and quantifying the risks. Take away practical tips and advice to apply immediately.

This session targets SSAS developers that are already dealing with complex security solutions on a regular basis and want to get more insights on what actually happens inside SSAS when the different kinds of security are applied to their model.

PowerPivot is a breakthrough for self-serve BI but is not easily deployed in the enterprise. Join us for this fast-paced, technical demonstration on how to upgrade PowerPivot into secure and scalable Analysis Services tabular cubes

SQL Server Code Name Denali Reporting Services will include Project Crescent for visualizing, interacting with and presenting data. Project Crescent. Come to this session to see how to make the most of this new tool.

This talk looks at MDX and DAX, examining their similarities and differences. It won’t turn you into an expert in either but it will help you to decide, given your particular career plans, if either or both are worth learning.

This session will investigate using Stream Insight, SQL Server and Analysis Services to provide an example framework to monitor cube usage as well as suggest a mechanism for highlighting areas for performance and security enhancements.

In this talk we will contrast and compare developing WebForm applications using Visual Studio 2008 with different types of datasources. We will be looking at design issues relating to concurrency control and updateability when using key Visual Studio controls such as the FormView and ListView controls. So if you don’t know where to start in choosing between SQL, LINQ and Entity datasources then you will by the end of this talk. We will also take a look at techniques for the seamless integration of ASP.net security with SQL Server Login security for web applications using LINQ.

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.

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.