Creating Custom Calendars in SQL Server Analysis Services
Businesses often have custom financial calendars - adapting these for use in SSAS can often be challenging - this article shows you how to do it.
Businesses often have custom financial calendars - adapting these for use in SSAS can often be challenging - this article shows you how to do it.
What are the hot skills for 2011? Steve Jones talks about one that you might not have thought about.
SQL Server's own list of functions is limited as far as what is available for database developers to use in their applications. Starting with SQL Server 2000, database developers were given the ability to create their own routines that accept parameters, perform custom actions and return results.
This editorial was originally published on Jun 23, 2005. It is being reprinted today as Steve is on vacation. It talks about the impact of long hours on families.
Phil factor compares SQL Server 2008's implementation of Window Functions to PostgreSQL and finds SQL Server frustratingly lacking in some of the essentials.
Most business applications you write probably utilize some kind of relational database. And, as a .NET developer, the chances are that database is Microsoft SQL Server. This article walks you through migrating your SQL Server database applications to the cloud with SQL Azure.
today we have a guest editorial from Andy Warren that talks about how attitude can influence the impression you make can have a huge impact on how your service is viewed.
Learn why ALTER DATABASE should be preferred over Detach/Attach for moving database files on the same SQL Server from MVP Jonathan Kehayias.
You're faced with the task of doing a SQL Server Upgrade? Do you know all the steps, and the right order to do them? You do? Even with interruptions and distractions? Maybe, but it is wise to be able to refer to the Mission-Critical Task checklist.
If you need to test new software, configurations, patches or operating systems, a virtual machine saves time, risk and hardware. You can set up a virtual test environment for free with some products such as VMware Server 2. All you need is a simple set of instructions about how to set it up; and here it is, thanks to Sean Duffy.
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
By Steve Jones
This was one of the original values: The facing page has this text: No...
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
Comments posted to this topic are about the item Create an HTML Report on...
My wife apparently ask her phone a question and below is what she sent...
Comments posted to this topic are about the item I Love Editorials
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers