microsoft sql
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
microsoft sql
SSAS
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
microsoft sql
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
dev
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
microsoft sql
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
transaction
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
microsoft sql
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
Certification
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
SQL102
SQL 201 – Contstraints
Constraints... helpful in making sure you get the data you want out of your database! Constraints allow you to define rules that the data must follow in order
SQL301
Extract, Transform, and Load
What is ETL? ETL stands for Extract, Transform and Load, a process used to collect data from various sources, transform the data depending on business rules and
t-sql
Triggers
Triggers are one of the most misunderstood features in Microsoft SQL server. Most of that misunderstanding comes from people implementing triggers with little
examples
Exception Handling
Learning to handle errors better can be one of the skills that will really set you apart from other SQL Developers. You can do constant unit testing after each