Many reports you will generate in SSRS will need to report within date ranges, and most of those will need a date range parameter. Here's an way to make an easy-to-use date range parameter.
When you begin to work with containers, you will notice many similarities between a container and a virtual machine; but, in fact, these are two quite different concepts. Containers are going to change the way that we do Windows-based development work in the coming year, and they already underpin much of the devops work of speeding the delivery process. Nicolas Prigent explains how to use the Windows Containers feature.
Age Calculation gets implemented as an Inline table Valued function with a parameter defining which date parts must be counted.
SQL Server 2016 introduced many new features and improvements for all its products, and Master Data Services (MDS) is no exception. In this post, Koen Verbeeck gives a comprehensive overview of all the new MDS features.
Steve Jones notes that not just the small, startup, agile companies use DevOps. Nor is it just technology companies.
This article will show why there is a need for remote access with a Biztalk server that uses log shipping.
Many practical database problems can be tackled more simply and intuitively by graphs or networks, which in this sense are graphs in which attributes can be associated with the nodes and edges. It is a natural way to study relationships within the data. SQL databases aren't the easiest way of doing it, but it makes sense where the scale permits it. Because of the range of graphs and techniques, some Graph theory is unavoidable before you get stuck into the code, and who better to introduce graph databases than Joe Celko?
Getting hacked is no fun. Today Steve Jones notes he's been hacked, in more ways than one and wants you to think about this at your workplace.
Age calculation based on the right method used in real life.
Have you ever wanted to know who made a schema change to your database? If so, that information is tracked in the default trace - Greg Larsen shows how to view it.
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
By Zikato
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
hi a peer of mine who ive never known to be wrong says a...
Comments posted to this topic are about the item Displaying Money
Comments posted to this topic are about the item The Slow Growing Problems
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers