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
Historically SSDT had no backwards compatibility meaning that with a newer version of SSDT, you couldn't create SSIS packages for an older version. This has changed with SQL Server 2016.
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
MSSQLTips is giving away $50 USD that you can use to take your team to lunch. We know you work hard as an IT Professional, so here's a little token to show our appreciation for what you do.
MSSQLTips is giving away a 5-day conference pass and a $2500 USD travel allowance to the "SQL Server LIVE - Orlando, FL - November 12-17, 2017" to one lucky database professional. Enter now!
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.
