SQL Server Connections Sept. 30-Oct. 4 in Las Vegas

View on Mobile Phone | View as Web page

T-SQL Querying and Query Tuning Full-Day Seminar at IT/Dev Connections, Sept. 30 By Itzik Ben-Gan, itzikl@solidq.com I love T-SQL, and I love Vegas, so it's no surprise that I'm happy to take part in the upcoming IT/Dev Connections conference in Las Vegas, September 30 - October 4. Covering Mix of Different SQL Server Versions I'm going to deliver a full-day workshop on Monday, Sept 30. I'll be talking about T-SQL querying and query tuning improvements in the last major releases of SQL Server (2012, 2008 and 2005). There's sometimes a tendency in conferences to focus more on the newest features. It's nice to hear about the newest products, but most environments have a mix of different versions of SQL Server. Therefore, I decided that there'd be more value for people to hear about T-SQL features introduced in the different versions of the product. More . . .   ADVERTISEMENT Compare DBMOTO to SSIS! Read more. Sponsored by HiT Software, Inc., a BackOffice Associates LLC Company Sharing or merging data across SQL Server databases? Need data from unlike databases to support reporting or data warehousing? Compare DBMoto to "SSIS plus Merge Replication" – no lost data, very easy to set up and manage! READ COMPARISON, "WHY DBMOTO for SQL SERVER?"   SQL Server Pro Instant Poll What database encryption technology do you use? Go to the SQL Server Pro poll page and submit your vote for: Column-level encryption .NET application level encryption Transparent database encryption Third-party database encryption All of the above Some of the above We don't use database encryption Intervals and Counts, Part 2 By Itzik Ben-Gan In "Intervals and Counts, Part 1," I started a series about temporal intervals and computing all sorts of counts related to them. For sample data I provided a table called Sessions holding information about sessions that connect to applications. Use the code in Listing 1 to create the Sessions table and fill it with a small set of sample data to check the correctness of your solutions. Use the code in Listing 2 to create a helper function called GetNums, and use it to fill the Sessions table with a large set of sample data for performance testing purposes. More . . .   ADVERTISEMENT Get SQL Server Skills Now – Including 2012! Sponsored by  LearnDevNow Get the most comprehensive learning library for SQL Server developers! Practical tutorial videos for Development, Administration, T-SQL, SSAS, SSIS, SSRS and more – plus tutorials for SharePoint, Visual Studio, SQL Server, ASP.NET and more. Learn more   Sending SQL Server Database Mail Alerts via Amazon's SES By Michael K. Campbell This post is selfishly done—in the sense that I'm mostly documenting a tiny bit of detail that I recently 'solved' in terms of figuring out how to get SQL Server's Database Mail functionality to work with Amazon's excellent (as in highly available and absurdly affordably) Simple Email Service (SES). More . . . Events and Resources A Roadmap to SharePoint Join us for this free web seminar that covers everything you need to know before upgrading to SharePoint 2013. Also learn the various ways in which this new version will benefit your needs. Free Tool! On-Demand Identity & Access Management for Cloud/SaaS A simple wizard driven process enables AD integration that allows access to your Domain Controller.  It takes less than 20 minutes to deliver.	ADVERTISEMENT   This issue is sponsored by HiT Software, Inc., a BackOffice Associates LLC Company and LearnDevNow   Want free, real-time SQL performance monitoring? Monitor 20 key performance metrics, see throughput varying types, see "heartbeat" statistics at different intervals and more! Expanding Your Information Governance Reach The proliferation of storing content has been a dream for users, but a headache for those concerned with information governance. Download this white paper to find out how to best extend your information governance reach. MORE RESOURCES   Managing a Multi-Farm, Multi-Location SharePoint Environment It isn't easy getting the RIGHT content to the RIGHT users at the RIGHT time… Adding locations and mobile devices to the mix escalates this challenge. With users accessing SharePoint content anywhere, anytime, and on any device, providing a secure and reliable SharePoint environment is vital. Join Dan Holme and Ron Charity, September 24th, 2013 at 11am ET, to get best practices and solutions. HPC-as-a-Service: Clouds of Speed Join us Wednesday, August 28th, 2013 @ 12:00pm ET.  Datacenter expert, Mel Beckman, explains the speeds and feeds of modern HPC and what you need to create or consume HPCaaS offerings. You'll also hear about the experiences of actual HPCaaS implementation and the most common issues overlooked when creating an HPC cloud service. MORE EVENTS

Contact Us
About the commentary -- articles@sqlmag.com
About technical questions -- www.sqlmag.com/forums
About product news -- products@sqlmag.com

Make sure your copy of SQL Server UPDATE doesn't get mistakenly blocked by antispam software! Be sure to add SQL Server UPDATE to your list of allowed senders and contacts.

You are subscribed as: buzzhairs.tech@blogger.com. To unsubscribe, click here.

SQL Server Pro | Penton | 1166 Avenue of the Americas | New York, NY 10036 | Privacy Statement