Last time I gave you a short introduction into XML. I covered the very beginning of what it is, what you use it for, and I even showed you an example file. This time, I’d like to show you how to work with your XML in a web browser, Then I’d like to show you…
Category: Microsoft SQL
XML, in as Few Posts as Possible
Ok, I know I have a few groups of posts started, so you won’t mind me starting another one, right? Right, so this collection of posts will be all about XML. If you’re not using it already, or completely familiar with what you can do with XML, check out this collection. I’m hoping to cover…
New DATETIME Data Types in 2008
We all know that in previous versions of SQL Server 2008 we have just one data type for storing date and time data, DATETIME. The problem is sometimes we only needed date, or we only needed time. Now you have some new options! TIME DECLARE@myTime TIME SET @myTime = GETDATE() SELECT@myTime as myTime By default,…
Business Intelligence Concepts
The phrase business intelligence is pretty old, 1958. In the early 90’s the term came to refer to the “concepts and methods to improve business decision making by using fact based systems.” So business intelligence is the means for taking all of the data in your organization and pull out the relationships. By finding these…
Killer Feature Reporting Services 2008
Reporting Services in SQL server 2005 does amazing things. But it has one drawback. To make it fly you have to be using Visual Studio. That’s fine for us, the IT Professionals, but what about the rest of your staff, the non-IT Professionals? They get report builder which is very easy to use but is…
sql server 2000 + How to display date time
Over on Experts Exchange I saw a question that I get all the time, “How do I format this DATETIME like x?” If they’re asking to learn, I point them over to the CAST and CONVERT article on msdn. If you wish to change a Microsoft SQL DATETIME column from the standard format 2008-01-28 12:43:13.210…
sql db record number
Over on Experts Exchange someone asked, once I insert a record into the table, how can I retrieve the primary key that was just inserted. This is a topic I covered back in 2005 in my post SQL 101 – System Functions. In this post I introduced you to @@IDENTITY. If you are unfamiliar with…
Return a Success/Failure to a Job based on a SQL query?
Over on Experts Exchange, someone posted a question I felt I could answer. The user posted a question on how to return a failure and not run a job. I originally took the approach of putting a query at the top of the queries run by the job that would query the table of failure…
Advice regarding on-line storage versus terabyte drives
Over at Experts Exchange, a user asked for some advice on using online (or off-site storage) for a collection of video files. This is something I have been discussing with my friends and co-workers for some time. I thought I’d try to help out. Looking at the amount of storage, 2 terabytes, I had to…
70-432: So…What’s Going to Break When We Upgrade?
So you’re in a shiny new position and you’re building plans for your migration from SQL 2005 to 2008 when the question hits you. What features are we currently using in our code that will break when we move to the new server? Ohh, tough one right? Not really. Hopefully you’ve used the profiler before. …