All Tags » sql (RSS)

Browse Blog Posts by Tags

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

  • Things You Know Now

    This blog meme is doing the rounds… I’ve been tagged at least twice now ( Jason Strate and Greg Linwood ), so I suppose subconsciously I’ve been thinking about this stuff for a few weeks already. Since I do a lot of training, I tend to explain these things to my students anyway. I...
    Posted to Rob Farley by Rob Farley on Mon, Mar 16 2009
    Filed under: Filed under: , , , ,

  • Enumerar las tablas de una BD (SQL)

    Imports System.Data.SqlClient Public Class Form1 Private MiConexion As New SqlConnection( _ "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\MisBDs\NORTHWND.MDF" + _ ";Integrated Security=True;Connect Timeout=30;User Instance=True" ) Private Sub Form1_Load( ByVal sender As System.Object...
    Posted to PepLluis by peplluis on Mon, Feb 23 2009
    Filed under: Filed under: ,

  • A reason to visit Manchester

    I shouldn’t knock Manchester – I’m sure it’s a great place. Being from the London area though, I’ve always had to find reasons to consider visiting Manchester. Now that I’m living in Australia, finding reasons to go is even harder. Manchester’s stock has risen recently, joining the ranks of Reading,...
    Posted to Rob Farley by Rob Farley on Sun, Feb 15 2009
    Filed under: Filed under: ,

  • SQL 2008 Books Online update

    I’ve just installed the January 2009 refresh for SQL Server 2008’s Books Online. I’ve only glanced at what’s different ( http://msdn.microsoft.com/en-us/library/dd408738.aspx ), but I just love the fact that SQL Books Online is a work in progress. Books Online lets you provide feedback on any page, and...
    Posted to Rob Farley by Rob Farley on Mon, Feb 2 2009
    Filed under: Filed under:

  • Jamie’s SQLMesh

    Jamie Thomson is a useful guy. He’s a SQL MVP, generally considered one of the world’s authorities in Integration Services (SSIS), but also very keen on the Live space . So it makes sense that he’s now combining the two – he’s gone and created a Code Repository on Live Mesh. Seems very useful, and I...
    Posted to Rob Farley by Rob Farley on Fri, Jan 30 2009
    Filed under: Filed under: , ,

  • EDM can save your hair :-)

    I am doing a training this week and one of my student told me that his DB can be used with EF. Indeed, his base isn't great for EF: a table Bases with 4 columns: Id, int, Identity (PK) Key, int, not null Value, int, not null Text, nvarchar He explained me that Value is an int between 1 and 9 which...
    Posted to Matthieu MEZIL by Matthieu MEZIL on Thu, Jan 29 2009
    Filed under: Filed under: , , ,

  • Powered By Cloud

    Interesting session is happening in UK on 2nd and 3rd of Feb 09 about Cloud Computing. Dont miss your chance to attend the sessions delivered by industry experts on Cloud Computing. You can find more details about this session on below link. http://www...
    Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Jan 20 2009
    Filed under: Filed under: , ,

  • Octobre 2008 - SQL

    Téléchargement Microsoft SQL Server 2008 Feature Pack, Août 2008 Téléchargez le Feature Pack 2008 pour Microsoft SQL Server 2008, une collection de packages séparés http://www.microsoft.com/downloads/info.aspx?na=22&p=1&srcdisplaylang=en&srccategoryid...
    Posted to TechNewsFrance by TechnewsFrance on Thu, Jan 8 2009
    Filed under: Filed under: , ,

  • 70-113, the Virtual Lab exam, gives Microsoft Certification new hope

    We all know what's wrong with Microsoft certifications. The multiple-choice format means that people can cheat too easily, and over the years, the questions have often felt too specific, asking the kinds of questions that proper IT professionals just look up in Help systems like SQL Books Online...
    Posted to Rob Farley by Rob Farley on Tue, Dec 16 2008
    Filed under: Filed under: , ,

  • Microsoft Clustering Resources

    This has to be the mother of all resource collections on Microsoft clustering and high availability.  I’ve copied over the links directly from the MS Cluster blog so that I have quick access to them in the future. General Resources Cluster Team Site: Clustering Technical Resources Guide: Failover...
    Posted to The Life of Brian by BrianM on Tue, Dec 16 2008
    Filed under: Filed under: , , , , ,

  • GO - repeating batches

    GO is very cool. More so than you might think, and in a couple of interesting ways. This is the 6th tip from my TechEd Australia talk, from which you can see my slides and scripts in other posts. In SQL Server, GO is the traditional batch separator. But what many people don't know (but has been mentioned...
    Posted to Rob Farley by Rob Farley on Fri, Dec 5 2008
    Filed under: Filed under: ,

  • The problem with America - spatial data

    Ok, it's not really a problem with America, just a problem with the perception of straight lines like the USA-Canada border. It's roughly the latitude line 49 degrees north. A line that goes East-West, on a straight line. Except that latitude lines aren't straight - except the equator. Just...
    Posted to Rob Farley by Rob Farley on Sun, Nov 16 2008
    Filed under: Filed under: , ,

  • Ordered data requires ORDER BY

    When you select data out of a database table, it might seem as if the system will give you data in the order of the clustered index that is on that table (assuming it has one), but this isn't quite right. I showed this in the fifth of my T-SQL tips at TechEd Australia this year. If you don't...
    Posted to Rob Farley by Rob Farley on Sun, Nov 16 2008
    Filed under: Filed under: , ,

  • Unique Indexes with GROUP BY

    Indexes are great, but if you don't understand the significance of unique indexes, then you're potentially missing out on some decent performance gains. I've been meaning to write this blog post for a long time. This is material that I've been teaching and presenting about all year, but...
    Posted to Rob Farley by Rob Farley on Sun, Nov 9 2008
    Filed under: Filed under: ,

  • JOIN simplification in SQL Server

    This is another of my tips/techniques that I demonstrated recently. It is not a new SQL Server 2008 feature - it works just fine in older versions - I demonstrated it running on SQL Server 2005 but using SQL Server 2008 Management Studio. [Note: It's ended up appearing earlier than another post that...
    Posted to Rob Farley by Rob Farley on Sat, Nov 8 2008
    Filed under: Filed under: ,

  • Length too important, SP truncates instead of returning an error

    Imagine that we have a stored procedure with a varchar(3) parameter. If we call it with "AZERTY" as parameter, the SP is executed as with "AZE" as parameter. I find it really bad! I think we should have a sql error and then if a .NET adapter calls it, an exception in its call.
    Posted to Matthieu MEZIL by Matthieu MEZIL on Wed, Oct 22 2008
    Filed under: Filed under: ,

  • System Views in SQL Server Compact Edition

    All developers, who works with “big” SQL Server know about system views. For example, this views can be used to get list all tables or columns in database. For example, to view columns list in “big” SQL Server you may use following T-SQL script: select * from sys.columns Situation with SQL Server Compact...
    Posted to Sergey Zwezdin by Sergey Zwezdin on Tue, Oct 14 2008
    Filed under: Filed under: , ,

  • Missing Index in SQL Server 2008 - should try harder!

    Ok, maybe I'm being a little harsh, but I just feel like it should be better. Let me show you the niceness of the way that missing indexes are handled in SQL Server 2008. Using AdventureWorks (not AdventureWorks2008) on a SQL Server 2008 install, if I show the Execution Plan from this simple query...
    Posted to Rob Farley by Rob Farley on Sat, Oct 11 2008
    Filed under: Filed under: , ,

  • Doing the maths to understand SQL optimiser choices

    The second of my tips from my talk ( slides and scripts available) was about doing the maths to understand why the SQL Server optimiser behaves in the way that it does - particularly in relation to choosing whether to scan an index/heap, or whether to seek a less-suitable index for some of the data and...
    Posted to Rob Farley by Rob Farley on Sat, Oct 11 2008
    Filed under: Filed under: ,

  • Upcoming book: Microsoft SQL Server 2008

    I recently wrapped up another authoring opportunity: I've contributed a chapter on the new PowerShell features in SQL Server 2008 for an upcoming book from SAMs: Microsoft SQL Server 2008 Management and Administration . It's cool to start seeing PowerShell showing up just about everywhere in...
    Posted to get-powershellblog by on Mon, Oct 6 2008
    Filed under: Filed under: , ,
Page 5 of 11 (211 items) « First ... < Previous 3 4 5 6 7 Next > ... Last »