(Simon Greener) SQL Server Spatial, unlike spatial database type systems such as PostGIS, does not provide coordinate editing functions:
Tag: sql server
SQL Server Monitoring Week – SQL Monitor
(Pinal Dave) Today I am starting a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary aim is to help people with my consulting workshop Comprehensive Database Performance Health Check. While I help customers with their various SQL Server performance issues, I
Join Multiple SharePoint Lists to build SQL Server Reporting Services SSRS Report
(Svetlana Golovko) We have a couple of SharePoint lists that have SQL Server inventory related information. We would like to join these SharePoint lists to visualize memory distribution on our SQL Server hosts in a SQL Server Reporting Services (SSRS) report.
SQL Server Monitoring Week – SQL Diagnostic Manager
(Pinal Dave) Today I am starting a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary aim is to help people with my consulting workshop Comprehensive Database Performance Health Check. While I help customers with their various SQL Server performance issues, I
Introduction to the Cosmos DB Emulator
(Marcin Policht) Cosmos DB constitutes one of the Azure foundational services, which ensures its availability in every existing and newly provisioned Azure region.
Database Recovery Monitoring with XE
(Jason Brimhall) On of the greatest benefits of Extended Events (xe) is how the tool simplifies some of the otherwise more difficult tasks.
SSIS Expressions for Email Addresses, Random Numbers, File Names, Round, OR and XOR Logic and More Examples using SQL Server Integration Services
(Daniel Calbimonte) I read the previous article about SQL Server Integration Services (SSIS) Expressions and was wondering what other things can be done with SSIS Expressions?
Video – Creating Azure SQL Database
(blobeater) A quick 2 minute upload (with sound, my voice) showing you how easy it is to create an Azure SQL Database using the Azure portal and then using SSMS (SQL Server Management Studio) to connect to it.
Changing the Time Zone of Azure VMs
(Denny Cherry) When you create a VM in Azure it’s always set to the UTC timezone. There are some times when that doesn’t work and it needs to be set for a specific time zone.
Methods to Insert Data into SQL Server
(Ed Pollack) There are a variety of ways of managing data to insert into SQL Server. How we generate and insert data into tables can have a profound impact on performance and maintainability!