You can use arithmetic operators in date/time calculations in SQL Server, but sometimes the date/time functions provided by Microsoft are the better option. Follow a few scenarios that demonstrate when arithmetic operators are safe and when they are risky.
2007-05-28
7,463 reads
If you would like to learn how to build and customize your very own Windows service to retrieve posts from multiple RSS feeds, and then store those posts in a SQL Server database, let John Papa guide you through his tutorial.
2007-05-25
2,081 reads
This tip explores a DMX extension introduced in SQL Server 2005 SP2 that can be used to render lift reports directly in Reporting Services.
2007-05-24
3,491 reads
Working in the corporate world can be a challenge and most of us muddle through our careers without really having any formal training. Andy Warren has spent time proactively working on his career and learned a great many tips and tricks for succeeeding as an employee and a manager. He brings us a few book reviews that might help you cope with the strange corporate world in which so many of us work.
2007-05-23
2,560 reads
2007-05-23
3,520 reads
Support conditional formatting for enterprise reports from the Analysis Services layer of the integrated Microsoft business intelligence solution.
2007-05-23
1,891 reads
Francis Norton shows how to use regular expressions to fulfil some real world data validation requirements, demonstrating techniques ranging from simple number format checks, to complex string validation that requires use of regex's powerful "lookahead" feature.
2007-05-22
3,865 reads
Chess makes a fantastic game for programming examples. You will find hundreds of examples on the internet. Some dedicated to OO patterns, others to algorithms and so forth. Unfortunately, most of these examples do not use a database or if they do, treat the database as nothing more than a storage repository. In this series of articles we will use SQL Server and T-SQL to implement the game of chess with an emphasis on thinking in sets.
2007-05-21
5,228 reads
Robyn Page and Phil Factor take on GROUP BY queries in SQL server, starting on the nursery slopes but finishing with a wild ride off-piste.
2007-05-18
2,426 reads
Maintenance Plan Designer gives you access to 11 tasks, which allow you to perform a variety of database management activities. This article provides a brief overview of each of them, focusing on their recent improvements.
2007-05-17
2,903 reads
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
By James Serra
Starting last week is a rollout of the public preview of a new and...
Let's get one thing straight: database administration isn't the most glamorous tech job out...
I am working on a data warehouse project for a bakery. For the most...
I am working on a data warehouse project for a bakery. For the most...
Hi I want to create a copy of a DB on the same server....
How can I restore a version of the Resource Database in SQL Server 2022?
See possible answers