Do you want to build a hybrid SQL Server environment? Check how to configure a site-to-site VPN to Azure step-by-step on this new article – Integrate On-Premises and Azure using a site-to-site VPN with RRAS (step-by-step)
Setting run dates on the fly and Setting run dates on the fly – The sequel
Do you want to install a SQL Server 2014 clustered instance? Not sure how to proceed? What are the requisites? These articles will show this, step-by-step:
SQL Server 2014 – Install a clustered instance – step-by-step (1/3)
SQL Server 2014 – Install a clustered instance – step-by-step (2/3)
SQL Server 2014 – Install a clustered instance – step-by-step (3/3)
Check out how to create SQL Server Log Shipping – How to create SQL Server Log Shipping
Check out how to create Database Mirroring for high availability – How to create a Database Mirroring
This article explains the main difference between the internal structures of the disk-based tables against the memory-optimized tables. You will understand why this new capability brings more speed in the SQL Server 2014 and what the table and index types allowed in this feature – In-Memory OLTP Series – Table Creation & Types
This post shows you a unique way to pivot your data and to mold it into a format that may be utilized by report graphics – OOPs my report real estate is too small
You know those reports that somehow start off as prototypes and somehow never make it off of the report server. How about those tables that have a gazillion fields which are more than likely not being utilized (based upon current reporting)? The “uglies” normally rear their head when you are performing “house cleaning” exercises or possibly wish to deploy your databases to the cloud and want to keep costs as low as possible by pulling only the minimal amount of data into your warehouses – Which fields do my reports ACTUALLY use!!
Performance tuning is not just a topic for DBAs or database developers. Business Intelligence developers also need to consider performance. And with the increasing popularity of in-memory technology such as SSAS Tabular mode – or even PowerPivot, it’s important to take into account that this is a completely different beast than the traditional SSAS Multi-Dimensional mode – Performance tuning an SSAS Tabular model
Take a deeper dive into XPATH queries and two possible scenarios to judge the effectiveness of our reports when it comes to database migration and what to carry forward – A deep dive into XPath
In a recent client project we decide to pull copies of the nightly backups of the databases to the warehouse servers and from there, restore the databases and complete the daily warehouse updates (relational and mdx). To achieve this required developing the necessary code to restore the backup on the warehouse server – Automating your database restores
In this new article, we will talk about the Azure Virtual Machines and we will learn how to connect to them using our local SSMS. You will require unblocking ports, add endpoints and other tasks that I will explain later. We will also learn how to export a local database to an Azure Virtual Machine with SQL Server installed – How to migrate your database to an Azure Virtual Machine
April 2, 2015
