All Tags » SQL Server (RSS)

Browse Blog Posts by Tags

Welcome to AppDev Edge blogs, where our members have access to the latest insights from the AppDev experts.

As a site visitor, you can stay on top of trends in learning and technology with blogs by the AppDev team, including President Craig Jensen and Vice President of Technology Martin Schaeferle. AppDev Edge members also have access to blogs by our Microsoft MVP and expert instructors including Ken Getz, Robert Green, Don Kiely and Doug Ware.

For complete access to AppDev Edge, learn more about the site and how to become a member.

Showing related tags and posts for the Blogs application. See all tags in the site

  • Fall Conference and User Groups

    It's going to be a busy fall for me, at least for a month or two. I'm really lucky to have been invited to speak at some fabulous conferences and user groups. September 23-24 (Ottawa is the 23rd and Montreal the 24th. I don't have location information yet though.) I'm meeting up with...
    Posted to Don Kiely by DonK on 4 Sep 2009
    Filed under: Filed under: , , , , ,

  • Granular Permissions in SQL Server 2005 and 2008

    I love security. Not necessarily being secure in life--life itself is a risk, after all--but computer security is interesting. One bit of proof of that is that I always push for a dedicated security chapter in any courseware I develop for AppDev. (Although I have to admit that I messed up with the SQL...
    Posted to Don Kiely by DonK on 4 Sep 2009
    Filed under: Filed under: , ,

  • 24 Hours of PASS

    The Professional Association of SQL Server (PASS) is a great organization for SQL Server professionals, both DBAs and developers. Membership is free, and gets you many nice benefits for learning SQL Server and getting involved with the community. And the annual PASS Community Summits are some of the...
    Posted to Don Kiely by DonK on 30 Aug 2009
    Filed under: Filed under: , ,

  • World's Simplest Recursive CTE?

    While preparing for a SQL PASS a year or two ago when I was doing a session about common table expressions, I had endeavored to come up with an extremely simple recursive CTE. Unfortunately, I wasn’t creative enough at the time to come up with anything, so the attendees had to sit through more...
    Posted to Don Kiely by DonK on 18 Aug 2009
    Filed under: Filed under: , ,

  • SQL Server 2008 Books Online Refresh

    One of the things that Microsoft committed to back in the SQL Server 7 to 2005 time frame was to do a much better job of updating the SQL Server documentation. They originally commited to a quarterly update, but for the most part it has been two or three times a year. Far better than just shipping a...
    Posted to Don Kiely by DonK on 17 Jul 2009
    Filed under: Filed under:

  • How do you connect to a remote SQL Server if you have SQL Server 2008 and Windows 7?

    In my previous post, I covered how you configure SQL Server to let you connect to it from a remote computer. I used SQL Server 2005 because that is what I have on my laptop. I have not switched to SQL Server 2008 on that computer because I use it to write courseware and we have been using SQL 2005 in...
    Posted to Robert Green by RobertG on 17 Jul 2009
    Filed under: Filed under:

  • How do you connect to a remote SQL Server?

    Your first thought might be, you gotta write a blog post about this? Isn't it just automatic? No, in fact, it is not. By default, both SQL Server and SQL Server Express disable the ability for clients on other computers to connect to them. To enable enable remote connections, you need to configure...
    Posted to Robert Green by RobertG on 16 Jul 2009
    Filed under: Filed under:

  • Hello, Edge!

    Hello! It's pretty exciting that AppDev has created the Edge to give instructors, courseware authors, and students a chance to exchange ideas and get feedback and learning all the technologies coming out these days. The pace of technological change seems to be getting faster all the time, so it's...
    Posted to Don Kiely by DonK on 10 May 2009
    Filed under: Filed under: , ,
Page 1 of 1 (8 items)
©2010 AppDev Products, LLC. All Rights Reserved.