ILIKESQL - Dandy Weyn's Blog

A query walked into a bar ...saw 2 tables and asked .. "Can I join you?"

ILIKESQL - Dandy Weyn's Blog

  • SQL Server Special Ops Tour

    CALLING ALL SQL Server PROFESSIONALS: SQL Server 2012 is the most important release ever of SQL Server with its’ mission critical, breakthrough insight and cloud on your terms features. Do your part to bring the SQL Server 2012 roadshows to your...
  • happy upgrade to a brand new Samsung Focus S - migrating your applications

    As today ATT released the new Samsung Focus S Windows Phone, a huge lineup was seen at many stores. Unfortunately, I realised it too late to get to the closest store - so I had to drive a bit further and get my hands on a brand new phone. But hey....
  • by popular demand - SQL BareMetal scripts

    If you ever attended any of our SQL BareMetal Hands-on-Labs or Workshop, pretty sure you were excited about some of the scripting. On popular demand I have looked at an easy way to distribute some of that scripting, and in the future we will continue...
  • SQL Server 2012 BareMetal Workshop - Are you an MCT?

    Are you a Microsoft Certified Trainer that teaches SQL Server 2012? Based on the succes of our BareMetal Hands-on-Labs and Instructor Led Labs we are building a 2 Day Workshop for Business Intelligence and Mission Critical. Are you interested in...
  • Just Announced - SQL Server 2012 - coming to you in 2012

    SQL Server 2012 is coming! Today at SQL PASS SUMMIT 2011 , our CVP Ted Kummert revealed the product name of the next version of SQL Server code name "Denali". As it might not come to any surprise we are proud to announce SQL Server 2012 , releasing...
  • Firewall Configurations for SQL Server

    I've been asked the question many times, and you probably have seen it before ... The "warning" message that displays during a SQL Server installation and warns you about "Firewall" configurations. To optimize for a minimal footprint and maximum security...
  • SQL Server Security Vulnerabilities

    SQL Server is the most secure of any of the major database platforms. In 2010, SQL Serer recorded zero security vulnerabilities compared with 34 for Oracle and 21 for IBM. Take that! For more information about SQL Server 2008 R2 security and...
  • SQL Server Code Name "Denali" CTP 3 - Product Guide

    Our team is pleased to announce the release of the SQL Server Code Name “Denali” Community Technology Preview 3 (CTP3) Product Guide v1. It is available for download at http://go.microsoft.com/fwlink/?LinkID=225814 . The SQL Server Code...
  • Today is yet another milestone for SQL Server Parallel Data Warehouse! -- Please welcome Dell PDW Appliance and Hadoop connectors

    Today we announced at TDWI another giant leap in Microsoft's datawarehousing offering.: Today, businesses are increasingly facing a “data deluge,” as the complexity and volume of data grows steadily. Meanwhile, IT continues to grapple...
  • Available now - SQL Server codename "Denali" CTP

    Introducing SQL Server Code-Named "Denali" - Today we released our latest CTP release of SQL Server Code-Named "Denali" Download here A key component of the cloud-ready information platform, SQL Server Code Name “Denali” will help organizations...
  • Released - SQL Server 2008 R2 Service Pack 1

    Today we released SQL Server 2008 R2 -SP1 The following features are new in Service Pack 1 (SP1). Dynamic Management Views for increased supportability. sys.dm_query_stats DMV is extended with additional columns to improve supportabilities...
  • SQL Server Code name "Denali" features

    While everyone is anxiously waiting for the next CTP release of SQL Server Code Name "Denali", - SIGN UP HERE TO BE NOTIFIED a couple of insights on Denali Features have recently been posted on CHANNEL9 by my fellow Technical Product Manager Darmadi Komo...
  • BareMetal Hands-on-Labs and workshop - current and futures

    Anyone who attended TechED, SQL PASS Summit, any internal Microsoft events or the MVP Summit on SQL must have heard about BareMetal hands-on-labs. Based on the interest, feedback and request to add the script files and manuals I am attaching the current...
  • Does your organization have Oracle, Sybase, MySQL or Access? Migrations done right!

    Do you know that Microsoft offers a free tool to automate database migration? In this demo-heavy session,we examine how SQL Server Migration Assistant (SSMA) migrates other databases to SQL Server. Discover how the tool perform assessment to analyze complexity...
  • Microsoft Data Warehousing Offerings

    Microsoft Data Warehousing Offerings Summary When implementing a database solution, a “one shoe fits all” approach assumes that all database workloads are largely similar. Microsoft recognizes the different, sometimes conflicting...
  • Channel 9 videos posted

    Our team hast posted a couple of new videos on SQL Server through Channel 9, available for web based viewing, or download to your favorite playbac device Upgrade Your Database Data Programmability Tools SQL Server appliance Parallel Data Warehouse...
  • Setting up Alwayson Availability Groups in SQL Server codename "Denali"

    SQL Server AlwaysOn is the new comprehensive high availability and disaster recovery solution in SQL Server Code-Named "Denali". Using AlwaysOn, you can increase application availability and get a better return on your hardware investments through a simplified...
  • One of Lynn Langit's books on daily sale through OReilly -Ebook Deal of the day

    Get Lynn Langit's BI BI book 50% off TODAY ONLY - Best of 2010 #Ebook Deal of the Day on the Top 25 w/Code DDM25 http://oreil.ly/top25-ebooks Microsoft Press Top 25 of 2010 - Ebook Deal of the Day oreil.ly When you buy ebooks thru oreilly...
  • it's like having a 4x4, but the manufacturer and sales person does not allow you to take it offroad...

    I just got off the phone with my ISP - QWEST, since that is about the only ISP we can get in the building I live. Fortunately I also have a Clear internet connection that I use when I travel, giving me a better deal than the internet connections we get...
  • SQL PASS - Hands-on-Labs goodness ...

    To follow up on a general request by the attendees at SQLPASS, I promised to post a link to our existing SQL Server 2008 R2 and SQL Azure Hands-on-Labs. Some of these labs are hosted as part of the Technet Virtual Labs or MSDN Virtual labs, which makes...
  • SQL Server Hands-on-Labs at PASS

    A lot of the attendees are asking if the SQL Labs that we are running at the conference are available and where they can find demos / recordings. The majority of our labs and training materials on SQL 2008 R2 are covered here
  • SQL Momentum at SQLPASS - Key Announcements

    Today at SQLPASS - Ted Kummert made some great announcements, bringing great momentum in the information platform industry. Microsoft SQL Server "Denali" Microsoft is announcing plans for the next release of SQL Server, SQL Server Code-Named "Denali...
  • SQL Momentum at SQLPASS

    With great announcements on what to come next the SQL PASS keynote will be interesting to follow. If you are not attending you can follow the keynote live right here - http://www.sqlpass.org/summit/na2010/LiveKeynotes/Tuesday.aspx .
  • Windows Live Essentials released!

    We are pleased to announce that Windows Live Essentials 2011 for Windows 7 and Windows Vista is now available for download! Windows Live Essentials 2011 was designed and built to connect your PC to the services you use every day. Designed for Windows...
  • joining the Parallel Data Warehouse community...

    Many years ago, as a DBA I got involved with huge amounts of data, handling millions of records at the time, a time where these databases that had gigabytes and even a couple of TB of storage. Now what happened since then? .. Numerous data collection...