All Tags » sql (RSS)

Browse Blog Posts by Tags

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

  • Recording of my SQLBits Session on Visual Studio 2008

    A webcast recording of SQLBits IV session ‘Making the SQL developer one of the family with Visual Studio Team System’ is now available on the SQLBits site. This discusses the features of the VS2008 Database GDR Edition. Unfortunately I will not be proposing a session for this years SQLBits community...
    Posted to Richard Fennell by on Mon, Aug 31 2009
    Filed under: Filed under: , , ,

  • More SQL Conferences coming up, including SQL Bits and SQL Down Under

    I know I won’t be there, as I’m a million miles away in Australia, but being from the UK myself, I always have an interest in the UK SQL community and in particular, events like SQL Bits. This is the fifth SQL Bits conference , and they keep getting larger and larger. I’ve heard it’s now the largest...
    Posted to Rob Farley by Rob Farley on Thu, Aug 27 2009
    Filed under: Filed under: , , , , ,

  • Still learning… foreign keys don’t need to reference a primary key

    …but you should still have a primary key on every table of course. It’s just that I only recently discovered that you can have a foreign key that references something else, so long as it’s known to be unique through a unique index / constraint. The scripts here demonstrate this in SQL Server 2005 and...
    Posted to Rob Farley by Rob Farley on Tue, Aug 4 2009
    Filed under: Filed under:

  • SSRS: Removing the Navigation link using an Expression

    There are times when you want to have a Navigation property of a textbox (typically providing a link to a URL or other report), but you don’t always want the link to be there. Sometimes you just want it to be an ordinary textbox. This particularly applies when you’re using a Matrix, and you don’t want...
    Posted to Rob Farley by Rob Farley on Tue, Aug 4 2009
    Filed under: Filed under: ,

  • Counting consecutive instances with DENSE_RANK

    It’s hard to think of a practical use for DENSE_RANK(), but here’s one. It’s one of the ranking functions that was introduced in SQL Server 2005, along with RANK(), NTILE(n) and the incredibly useful ROW_NUMBER(). But apart from producing reports, it’s quite hard to find genuine uses for some of them...
    Posted to Rob Farley by Rob Farley on Fri, Jul 24 2009
    Filed under: Filed under:

  • The new brand is Microsoft SQL Azure

    It used to be SQL Server Data Services. Then SQL Data Services. Then we started hearing about SQL Services, and now (I hope finally), we have Microsoft SQL Azure instead of SQL Services, and the Microsoft SQL Azure Database instead of SQL Data Services. http://blogs.technet.com/dataplatforminsider/archive...
    Posted to Rob Farley by Rob Farley on Thu, Jul 9 2009
    Filed under: Filed under: ,

  • Fun with a SQLExpress 2005 upgrade 2008

    On my development PC I had a 2005 instance of SQLExpress that was installed as part of the VS2008 setup. I thought I had upgraded it when I put on the SQL 2008 Management tools and/or VS2010 beta, but it seems I didn’t. I thought I would try the new Microsoft Web Platform Installer , but this also thought...
    Posted to Richard Fennell by on Mon, Jul 6 2009
    Filed under: Filed under: ,

  • Excel dates counted differently and a reliable way of working out the day of the week

    Following my recent post about 40,000 days , I got a couple of emails telling me that Excel disagrees about when the 40,000th day is. And this is true – Excel counts Day 40000 as July 6th 2009, not July 7th. Unfortunately for Excel users, they’re wrong. And it’s down to the fact that Excel thinks that...
    Posted to Rob Farley by Rob Farley on Sun, Jul 5 2009
    Filed under: Filed under: ,

  • 40,000 days since the beginning of ‘time’

    Next Tuesday feels like a significant day. Not only is it 7/7, and the fourth anniversary of the London bombings (in 2005), but it’s 40,000 days since the beginning of time. Well, not proper time, but since the start of the 1900s. SELECT DATEDIFF(day,'19000101','20090707')+1 AS DaysOf1900s...
    Posted to Rob Farley by Rob Farley on Tue, Jun 30 2009
    Filed under: Filed under: ,

  • Access’ DISTINCTROW keyword explained – it means WHERE EXISTS

    Steve Koop spoke recently at the Adelaide SQL Server User Group , talking about things which don’t convert particularly nicely when upsizing from Microsoft Access to SQL Server 2008. I think this is a really important thing for SQL people to know, as there seem to be many Access databases living in even...
    Posted to Rob Farley by Rob Farley on Thu, Jun 11 2009
    Filed under: Filed under: , ,

  • Putting a Calculated Member into a Display Folder

    There are some blog posts that are there to inform other people – this isn’t one of these. This is something I always seem to forget, and I’m hoping that writing it in here will cause me to never forget again. It’s the knot in my handkerchief, or the writing on my hand. I put an SSAS (2005) Calculated...
    Posted to Rob Farley by Rob Farley on Tue, Jun 9 2009
    Filed under: Filed under: ,

  • Seriously cheap exams in Australia

    If you’re an MCP in Australia and you haven’t passed any exams over the past couple of years (since July 1, 2007), then Microsoft has an offer at the moment to let you do an exam for only US$25 (until June 30, 2009). Ok, so that means the price really depends on the value of the Aussie dollar, but either...
    Posted to Rob Farley by Rob Farley on Tue, May 5 2009
    Filed under: Filed under: , , , ,

  • Follow up to my session yesterday at VBug Newcatsle on DataDude GDR

    Thanks to everyone who attended my session at VBug Newcastle last night, hope you enjoyed. As I mentioned in my session, to celebrate my talking at VBug, Microsoft chose to release the Visual Studio Team System 2008 Database Edition GDR R2 yesterday. If you are using DataDude you do need to get this...
    Posted to Richard Fennell by on Thu, Apr 23 2009
    Filed under: Filed under: , , ,

  • Speaking in Newcastle tomorrow

    If you are in Newcastle on the evening of the 22nd I will be speaking at Vbug on Visual Studio 2008 Database Edition . Hope to see you there.
    Posted to Richard Fennell by on Tue, Apr 21 2009
    Filed under: Filed under: , , , , ,

  • SQL Server 2008 SP1 download

    You can get it from http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19 For all those people who have been waiting for SP1 before considering a migration to SQL Server 2008, it has now been released. There’s also a new version of the Feature...
    Posted to Rob Farley by Rob Farley on Tue, Apr 7 2009
    Filed under: Filed under: ,

  • Visual Studio 2008 DBPRO GDR QFE (wow loads of TLAs there)

    At my session at SQLBits IV on Visual Studio 2008 DBPro GDR it was mentioned that there was a major patch just about to be released to address some known issues. Well Brian Harry has provided links to the release of the release candidate of the GDR QFE
    Posted to Richard Fennell by on Tue, Apr 7 2009
    Filed under: Filed under: , ,

  • Time zone limbo

    Australia is currently in an interesting week for time zones. Up until a couple of years ago, Daylight Savings finished on the last Sunday in March. That’s when the clocks got put back to Standard Time, as the Australian summer ended. Last year though, this got extended by a week, until the first Sunday...
    Posted to Rob Farley by Rob Farley on Wed, Apr 1 2009
    Filed under: Filed under: , ,

  • Converting to (and from) Julian Date (YYDDD) format in T-SQL

    I often get asked how to convert a datetime into Julian Date format in T-SQL. People have differing opinions about what Julian means, but the one I got asked about most recently meant YYDDD, as often used by mainframe systems (I think this is Julian Date, as opposed to Julian Day which is the number...
    Posted to Rob Farley by Rob Farley on Wed, Mar 25 2009
    Filed under: Filed under:

  • ADO.NET Data Services и LINQ to SQL: continuation

    Recently I wrote about what actions are necessary, that the LINQ-to-SQL data model could work together with ADO.NET Data Services. I wish to add this information with one important fact. Actually, there is an convention on which ADO.NET Data Services tries to define independently key fields in entity...
    Posted to Sergey Zwezdin by Sergey Zwezdin on Tue, Mar 24 2009
    Filed under: Filed under: , , , ,

  • Como enlazar columnas de una tabla SQL a unos 'TextBox'

    ' En respuesta a la pregunta de como añadir o modificar registros ' a una tabla de SQL con bindings sin DGV y al viejo estilo ADO. ' ' Utilizaremos solo las columnas de Nombre y Telefono de la tabla 'Shippers' ' Despues de insertar un nuevo registro, deberemos utilizar...
    Posted to PepLluis by peplluis on Mon, Mar 23 2009
    Filed under: Filed under: , ,
Page 1 of 8 (151 items) 1 2 3 4 5 Next > ... Last »