Join this webinar to get up to speed on SQL Server Columnstore Indexes for Data Warehousing. You'll learn which types of columnstore indexes there are, how you can integrate them into your data warehouse and what performance gains you can expect.
Some of our SQL Servers contain tables with summarized data (summarized on a weekly / monthly / quarterly basis). Previously this data was emailed as a flat file attachment to the recipients. I was asked to convert this in such a way that the email itself
I need to produce mailing labels from my SQL Server database so I am using the + sign for concatenation the first, middle, and last names together. The issue I see is I get NULL for a lot of rows. This makes me unable to produce the full names. What are
SQL Server Analysis Services (SSAS) is the technology from the Microsoft Business Intelligence stack to develop Online Analytical Processing (OLAP) solutions. Over the years SSAS has evolved and has emerged as a leader in the area of analytical solutions.
Many new employees and contractors will start looking for another job shortly after starting because the job is not aligning with what they were expecting. Learn the questions to ask to make sure the job is the right fit.
Sqlcmd is not just a script execution tool. It gives us access to internal variables and commands that we can use to automate code execution. In this tip I will show you how you can use the scripting variables.