United Technologies & Information Services LLC

02/03/2022

All new Azure Synapse Link - Case Study - Click the link below

https://www.linkedin.com/pulse/azure-synapse-link-case-study-arun-albert

Azure Synapse Link ...

01/26/2022

Let's catch up on SQL Server 2022

https://www.linkedin.com/feed/update/urn:li:ugcPost:6891835090792517632?updateEntityUrn=urn%3Ali%3Afs_updateV2%3A%28urn%3Ali%3AugcPost%3A6891835090792517632%2CFEED_DETAIL%2CEMPTY%2CDEFAULT%2Cfalse%29

...

10/01/2016

Parallel processing for multiple table partitions in tabular models – MS SQL 2016

We are aware the concepts of table partitioning in SQL. It is widely used to deal with high volume data. Broadly partitions are done on two ways; horizontally and vertically.

Vertical partitioning suited in a case we have table a few columns stores bigger size compared to others (likes bytes of image). Then partition the table in to two vertically and get better performance while dealing the data.

Horizontal partition suited for high volume of horizontal data (table rows). Partition based on date (month/year), region gives better performance.

Now with MS SQL 2016; Microsoft introduced parallel processing for multiple table partition. With this we can set the parallel processing can be set the parallel “MaxParallel” in the schema configuration changes.
Advantages: Each defined partition is processed in parallel and results an improvement in performance. Each time we refresh the table, all the partition is refreshed as well.

09/24/2016

Task Based Asynchronous Pattern

09/03/2016

https://youtu.be/mFnN8eLs3c8

This video demonstrates how to deploy a SQL Server database using DbUp and Octopus Deploy. Want to learn more about Octopus Deploy? Check out our getting sta...

09/03/2016

Take a quick tour around the Release Management capabilities in Visual Studio Team Services and Team Foundation Server. See how you can deliver your software...

03/21/2015

SQL Trivia:

You develop a Microsoft SQL Server 2012 database. You create a view from the Orders and OrderDetails tables by using the following definition.(see the photo for the view sql script)

You need to improve the performance of the view by persisting data to disk. What should you do?

A. Create an INSTEAD OF trigger on the view.
B. Create an AFTER trigger on the view.
C. Modify the view to use the WITH VIEW_METADATA clause.
D. Create a clustered index on the view.

03/20/2015

SQL Trivia:

You have a Microsoft SQL Server 2012 database that contains tables named Customers and Orders. The tables are related by a column named CustomerID. You need to create a query that meets the following requirements: -

1. Returns the CustomerName for all customers and the OrderDate for any orders that they have placed.
2. Results must include customers who have not placed any orders.

Which Transact-SQL query should you use?
--------------------------------------------------------------------------------------------
A. SELECT CustomerName, OrderDate FROM Customers RIGHT OUTER JOIN Orders ON Customers. CustomerID = Orders.CustomerID

B. SELECT CustomerName, CrderDate FROM Customers JOIN Orders ON Customers.CustomerID = Orders.CustomerID

C. SELECT CustomerName, OrderDate FROM Customers CROSS JOIN Orders ON Customers.CustomerID = Orders.CustomerID

D. SELECT CustomerName, OrderDate FROM Customers LEFT OUTER JOIN Orders ON Customers. CustomerID = Orders.CustomerID

03/13/2015

http://www.utisllc.com/blog