(Simon Greener) I have just written a useful function for my new package of TSQL functions for SQL Server Spatial called STLine2Cogo which converts (exports) a (Multi)LineString into a set of instructions (bearing, distances etc) that can be shared with other COGO functions.
Tag: sql server
Import Excel Data into SQL
(Hannes du Preez) In order to read from an Excel Spreadsheet through SQL you need to install the Office 2010 Database Engine.
SQL SERVER – Install Error: Microsoft Cluster Service (MSCS) Cluster Verification Errors – Part 3
(Pinal Dave) In recent past, I was assisting a client in installing SQL Server clustered instance in a Windows Cluster. There were many errors encountered and I learned a lot from this experience. In this blog, we would learn about Microsoft Cluster Service (MSCS) cluster verification errors which m
Using SQL Server’s Default Trace to Identify Autogrow Events in tempdb
(Greg Larsen) We all know that you should try to size tempdb appropriately, so it doesn’t need to autogrow shortly after starting up SQL Server. It isn’t always easy to do this.
Deploy Azure SQL Managed Instance network environment using ARM
(Jovan Popovic) Azure SQL Managed Instance is fully managed SQL Server instance hosted in Azure cloud. You would need to prepare Azure environment where SQL Managed Instance will be hosted before you create your Managed Instances. In this post you will see how to deploy configured Azure environment
Migrate a database from SQL Server 2008 to 2016 and use new features
(Pablo Echeverria) We have a database that requires trace flag 4136 due to performance issues with parameter sniffing, so it had to be put on its own instance to disable the parameter sniffing because most of the queries are created dynamically.
Line Breaks And Auto-Indent In The Power BI DAX Formula Bar
(Chris Webb) The other day I discovered something new (at least to me) while writing the DAX for a measure in Power BI Desktop: when you insert a new line in your DAX expression using SHIFT-ENTER it also auto-indents the code.
Agent no longer terminates on error
(Tibor Karaszi) It is funny how you keep going, assuming things are as they used to be. Sometimes.
SQL SERVER – How to Know Transaction Isolation Level for Each Session?
(Pinal Dave) During recent, Comprehensive Database Performance Health Check, I had a very interesting scenario. I was hired by a customer to identify their system’s unexpected performance bottlenecks. I do these for a living so I am usually pretty comfortable.
Benefits of using SQL Server Temporal Tables – Part 1
(Ameena Lalani) You probably know what SQL Server temporal tables are by now, but do you know all of the benefits of using them? In this tip we cover some aspects to help you make an informed decision when building your next application about why and how to use SQL Server temporal tables.