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.
On June 5, 2006 MSSQLTips.com started with just one tip in an effort to offer solutions to real world SQL Server problems. Ten years later, we never expected MSSQLTips.com to grow into a global community of millions of SQL Server Professionals.
Got a cross-platform database environment? Of course, you do. What DBA isn’t expected to manage countless new technologies these days? It’s ridiculous! But it’s easy to keep up with the latest tips and tricks from top industry pros. Check out this free wh
What are some overlooked and best practices with extract, transform and load from development to auditing? In this webcast, we learn a few best practices along with some overlooked practices that help organizations and developers expand...
SQL Server 2005 introduced the APPLY operator, which is very much like a join clause and which allows joining between two table expressions i.e. joining a left/outer table expression with a right/inner table expression. The difference between join and APP
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
One of the benefits of SQL is the ability to write a query and use parameters to dynamically act upon the resultset. Depending on the situation, there can be benefits to parameterizing queries, but it is not always clear when or how to do this. In this t
SQL Server Analysis Services (SSAS) contains features for developing data mining models using various data mining algorithms for predictive analysis. Once these models are deployed on SSAS, they can be queried using Data Mining Extensions. Often there’s a
In a previous tip we discussed 10 items that should be addressed to manage your SQL Server environment. These items included; backups, security, disaster recovery, etc... The first item on the list was to address and implement a sound backup strategy. T
You are a SQL Server DBA and you are new to Linux. You know that Microsoft has decided to expand SQL Server to Linux servers and you need to know how to check for network latency and I/O. In this tip I will show you some tools that will help you.
We have a windows service that runs on several servers and interacts with a remote SQL Server database and during some deployments, we've noticed that the service will continue running after the deployment, but then stop or fail sometime afterwards withou
As a SQL Server DBA, we usually need to collect various performance counter data or other query performance data via Extended Events (XEvent) or Trace. After collecting these data, one common use is to compare the data of troubling time with the data of t
How do you set your nontechnical peers at ease so they’ll be comfortable talking to you? How do you build trust and rapport so they’ll listen to your opinions? How do you not come across as a know-it-all, condescending jerk? There are many verbal and nonv
Join this webinar, hosted by SIOS high availability experts Cassius Rhue and Heath Carroll, for key insights on deploying SQL Server on AWS and building high availability solutions for SQL Server in the cloud.
You may have been in a scenario where you need to quickly generate a script to drop and then subsequently re-create all of the foreign keys in a database. In this tip I provide a script to do this for you.
IDERA just released SQL Doctor version 3.6 and this new version brings the SQL Doctor functionality to cloud platforms. Now you can easily check and monitor your on-premises and cloud SQL Server installations to make sure SQL Server is running without iss