InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 14:42:49 GMT20http://www.sqlservercentral.com/Forums/Topic1428948-2889-1.aspxThis was recently published, and might help anyone looking for help with their abstracts - [url=http://sqlblog.com/blogs/adam_machanic/archive/2013/02/22/capturing-attention-writing-great-session-descriptions.aspx]Capturing Attention: Writing Great Session Descriptions[/url]Sat, 09 Mar 2013 20:15:04 GMTRick Kruegerhttp://www.sqlservercentral.com/Forums/Topic1362597-2889-1.aspxMy session got selected for October 6th's [url=http://www.jaxdug.net/CodeCamp/Home]Jacksonville Code Camp[/url], hosted by the Jacksonville Development Users Group. Yay, I get to speak in front of a bunch of developers.Crap, I have to speak in front of a bunch of developers.This feels different than speaking at a SQL Saturday... I'm hoping the fact that my session is on SQL Server Database Basics means I'll be able to survive the session feeling like I do have a clue. Here's my summary:[quote]You've developed the greatest thing since sliced bread, but the Database Administration team won't let you hook it up to their database. From schema to security to space and performance issues, this is a high-level overview of what DBAs see as their most important challenges when integrating other people's code into their system. A fascinating look at how the other half works.[/quote]As I'm developing my content, I'd like to ask all you SQL developers out there, what items do you wish you knew back in the day before you started butting heads with the DBA team?Fri, 21 Sep 2012 06:18:09 GMTBrandie Tarvinhttp://www.sqlservercentral.com/Forums/Topic1334835-2889-1.aspxI'm putting together a Service Broker presentation for the local users group and hoping to submit it to a SQL Saturday as well. I would appreciate any feedback on content, phrasing, or whatever else you see that might make it better. Thanks!SQL Server Service Broker is a messaging framework built into the SQL Server engine. It enables SQL Server to handle messaging between servers and applications with light setup and overhead. The flexibility of the framework enables Service Broker to queue event notifications, task execution requests or other messages while leveraging the strength of SQL Server transaction management, reliability and recoverability. In this session we will see how Service Broker can be used to:--Interact with an external 3rd party application asynchronously--Implement a low-impact audit log solution--Scale out a task to multiple servers--Throttle large batch processesThanks,ChadEdited, incorporated suggested changesTue, 24 Jul 2012 16:55:42 GMT Chad Crawfordhttp://www.sqlservercentral.com/Forums/Topic1298324-2889-1.aspxHi folks, we are ScaleGrid and we are currently working on a product called SQLDirector. SQLDirector is a MS SQL as a service for private cloud/virtualization platforms. SQLDirector allows you to provision, migrate and consolidate databases with a single click. Our goal is to help bring the benefits of public cloud to enterprises. SQLDirector supports SQL Server 2008, R2 and 2012. We are currently in a closed beta and are looking for feedback on our feature set from DBAs and IT Admins. As part of our gratitude we will buy you a beer or provide you a amazon gift card. Thank you!Ankithttp://www.scalegrid.netThu, 10 May 2012 21:31:24 GMTankitbhttp://www.sqlservercentral.com/Forums/Topic1052561-2889-1.aspx"Design Patterns" is more than a trendy buzz phrase; design patterns are a way of breaking down complex development projects into manageable tasks. They lend themselves to several development methodologies and apply to SSIS development. Chances are you're using your own design patterns now! At the PASS Summit 2009, Andy Leonard demonstrated ways to use some less-documented features of SSIS. At the PASS Summit 2010 Andy shares more SSIS Design Patterns. This session is for experienced SSIS developers. Attend and learn the Parent-Child SSIS design pattern, how to leverage less-than-well-documented characteristics of SSIS to centralize logging, and how to pass variable values between parent and child packages (in both directions).Mon, 24 Jan 2011 10:47:32 GMTAndy Leonardhttp://www.sqlservercentral.com/Forums/Topic1150670-2889-1.aspxI'm looking at a topic for SQL Saturday. It's going to be held in conjunction with a .net Code Camp, so there will be a mix of both DB and .net developers wandering around and I thought a basic indexing presentation might be interesting:What makes an index tick and why do they make your queries faster? To answer that question, this session will look at how SQL Server stores index data and how statistics help the optimizer determine when to use an index. We'll look at a few cases where the optimizer either doesn't use an index or uses it inconsistently, and explain how to address them. Finally we tie everything together with some recommendations on how to identify and implement a good index.Thu, 28 Jul 2011 23:26:20 GMT Chad Crawfordhttp://www.sqlservercentral.com/Forums/Topic1052563-2889-1.aspx"Design Patterns" is more than a trendy buzz phrase; design patterns are a way of breaking down complex development projects into manageable tasks. They lend themselves to several development methodologies and apply to SSIS development. Chances are you're using your own design patterns now! At the PASS Summit 2009, Andy Leonard demonstrated ways to use some less-documented features of SSIS. At the PASS Summit 2010 Andy shares more SSIS Design Patterns. This session includes SSIS Design Patterns to: - migrate SSIS packages through your enterprise without editing connection managers; - dynamically access externalized SSIS package values; - extend the functionality of the parent-child pattern to create SSIS execution groups. The session is designed for those with little or no exposure to design patterns or application development methodologies; but with good experience in SSIS. The goal is to introduce the science, terminology, and philosophy of design patterns to those wishing to learn more.Mon, 24 Jan 2011 10:48:37 GMTAndy Leonardhttp://www.sqlservercentral.com/Forums/Topic1095306-2889-1.aspx[quote]SSIS Custom ComponentsDesigning custom components for SSIS is a complex task. Much of the available documentation is not very intuitive, and although technically correct, can be simply unfathomable.There is a step learning curve , with many trips and false starts upon the way. Once understood though, the benefits in code reuse and overall performance can be well worth the effort. Once you have understood the data flow functionality, then the hurdle of creating a UI will then have to be crossed. Starting with a blank project , the end to end process will be demonstrated to allow you to get all the benefits. [/quote][quote]"Just make it go faster” That’s a standard command that gets filtered down through the management on an all too frequent basis. How can that best be achieved? Sure you could throw hardware at the problem, but how do you know that that will solve the problem and at what financial cost. Alternatively you could partition tables, use created clustered views or any manor of tweaks. But are you just papering over the cracks? Without addressing the underlying problems then you are not going to achieve real performance, scalability and create a system that performs in a predictable fashion. By re-engineering some cursor ridden code, we'll see how that can be achieved[/quote]Opinions ?Mon, 18 Apr 2011 14:41:45 GMTDave Ballantynehttp://www.sqlservercentral.com/Forums/Topic1052489-2889-1.aspxAbstract:We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don't always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.Does it make you want to attend?Mon, 24 Jan 2011 09:36:08 GMTAllenMWhitehttp://www.sqlservercentral.com/Forums/Topic1088931-2889-1.aspxThis was the abstract as selected for SQL Sat 63. Going to submit to PASS for the fall. Thoughts please?Ever wonder what's in your SQL Plan cache? Wonder why or how it got so big? This session will cover what it is, how it's used, how it can affect performance and how poor application and query design can make it worse. Rather than put participants to sleep with a slide deck we will get down and dirty with lots of demos.Tue, 05 Apr 2011 14:48:57 GMTScalability Doughttp://www.sqlservercentral.com/Forums/Topic1091802-2889-1.aspxYou’ve either volunteered or had the position thrust upon you, but here you are. You’re the DBA. You are being looked to as the person who will protect the companies’ data and you really don’t have a clue where to start. Let me suggest that one of the first things you should do is put together a good plan for backing up your database. This session will focus on the best practices, standards and methods that you can employ to ensure that you have a solid backup process for the databases under your charge. You’ll also learn how to restore these databases, because your backups are only good if you can restore them. At the end of the session, you should be able to go back to your office with confidence that you can begin to protect the data for your organization.Mon, 11 Apr 2011 15:55:16 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic1091092-2889-1.aspxHello,I have noticed that there are not any presentations on SQL Agent at the various SQL Saturday events and thought to fill a gap:[u]SQL Agent for the Beginner DBA[/u] "An Introduction to some basic concepts and tricks to effectively use SQL Agent on one or more production servers. We'll cover job scheduling, alerts, operators, and failure handling. Finally, a review of the capabilities of Agent vs. the Windows task scheduler. "Do you think there is enough material there for an hour presentation ?Thanks, CraigSat, 09 Apr 2011 09:01:22 GMTCraig Purnellhttp://www.sqlservercentral.com/Forums/Topic1052451-2889-1.aspxHere is the abstract I've started submitting for SQL Saturdays and whatnot this year. Thoughts on the abstract? Would this make you want to come see the session?T-SQL Code Sins: The Worst Things We Do to Code and WhyIt's impossible to follow every best practice all the time. Code sins are those things we do to our code that are either so horrendous that they can't be borne, or that have such tremendous consequences that your stored procedures wish they'd never been created. Attendees will hear about the most common code sins that make code difficult to read, support, run and extend, and practical strategies for reversing the trend.Thanks,JenMon, 24 Jan 2011 09:02:00 GMTJenMidnightDBAhttp://www.sqlservercentral.com/Forums/Topic1050943-2889-1.aspxI am wondering what people think of this title and description:Abstract: Learn practical ways in this session that you can use to build your career brand and stand out from the crowd. Steve Jones, editor of SQLServerCentral, shares some of the ways in which he has successfully grown his career over the years. Steve will present tips and tricks for using social networking sites, blogging, volunteering, leadership, and more to your advantage. He also has a few resume hints to help you find a great job that fits you.Thu, 20 Jan 2011 10:05:45 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1050970-2889-1.aspxThis is a presentation that I have been working on and evolving at a few user groups. Is this abstract ok?Abstract: This presentation looks at a number of common mistakes that people make in SQL Server. There are edge cases where these might not apply, but for the most part, these are mistakes that you do not want to repeat as you are building applications on the SQL Server platform.The basic agenda: * SELECT * * Shrinking databases * GUID as a Clustered Key * Functions in the WHERE Clause * IS NULL * Multi-row triggers * Indexing all Columns * Cursors * SA Account UsageThu, 20 Jan 2011 10:24:49 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1052801-2889-1.aspxI submitted this to PASS back when they didn't offer criticism of rejected abstracts, so I'm curious what might be wrong with it.[quote]Understanding Execution PlansDid you ever wonder if there was a way to see what happens inside SQL Server when you submit a query? Did you want to know if your indexes are getting used? Have you been curious about how SQL Server does a join between two tables? Did you just need to understand why your query is running so slow? The answers to all these questions, and more, are contained within SQL Server execution plans. My goal will be to show you how to generate execution plans and how to read them after they’re generated. You’ll learn the difference between an estimated and an actual execution plan and when to use each one. You’ll discover how to read a graphical execution plan and follow your data through the plan as it gets joined to other tables or filtered by WHERE clauses or aggregate functions. After watching this session, you’ll understand how to get detailed information out of execution plans, what operators to watch for, how to tell if the right operator is being used for your data, and all the bits and pieces of different kinds of data that are immediately available inside SQL Server execution plans.[/quote]Mon, 24 Jan 2011 18:28:40 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic1052494-2889-1.aspxAbstract:The Policy-Based Management feature in SQL Server 2008 provides a great way to ensure your systems are configured consistently and correctly, but it can be tedious to implement on each server in your environment. PowerShell scripts allow you to automate the implementation of your policies so you can focus on more important problems. This session will walk you through how PBM works, how to define your policies in PowerShell, and how to set up Agent jobs to evaluate those policies regularly to let you know when you need to take action.This session isn't generally well attended, yet the attendees seem to come away pleased. How could I change the abstract to attract more people?Thanks.AllenMon, 24 Jan 2011 09:38:45 GMTAllenMWhitehttp://www.sqlservercentral.com/Forums/Topic1052555-2889-1.aspxThis highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up.Mon, 24 Jan 2011 10:43:16 GMTAndy Leonardhttp://www.sqlservercentral.com/Forums/Topic1052557-2889-1.aspxThis interactive session is for software developers tasked with database development. Attend and learn about patterns and anti-patterns of database development, one method for building re-executable Transact-SQL deployment scripts, a method for using SqlCmd to deploy re-executable Transact-SQL deployment scripts, and fodder for a lively discussion about NULLs. Bring your database deployment practices and be prepared to participate!Mon, 24 Jan 2011 10:43:51 GMTAndy Leonardhttp://www.sqlservercentral.com/Forums/Topic1052554-2889-1.aspxAre you a member of a team of database professionals? Are you part of a developer team? Do you manage or lead a team? This presentation is for you. Andy Leonard shares experiences, war stories, and lessons learned from years of managing and leading teams.Mon, 24 Jan 2011 10:42:35 GMTAndy Leonardhttp://www.sqlservercentral.com/Forums/Topic1052564-2889-1.aspxIn this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging. Key takeaways: 1) Developers can migrate packages from Development, through their lifecycle, to Production without editing SSIS Connection Managers properties. 2) A metadata-driven approach to SSIS package execution. 3) Demonstration of a centralized logging reporting application.Mon, 24 Jan 2011 10:51:12 GMTAndy Leonardhttp://www.sqlservercentral.com/Forums/Topic1052559-2889-1.aspxThis session is for SSIS developers and DBAs. Attend and learn more about Transact-SQL and SSIS design patterns for loading data incrementally. The session includes two demos: Incremental Loads in Transact-SQL; and Incremental Loads in SSIS.Mon, 24 Jan 2011 10:44:20 GMTAndy Leonard