(Ben Richardson) In 2017, SQL Server introduced support for Python language which opened the door for creating machine learning models using SQL Server. The SQL Server machine learning services along with Python support can be used to create a model that is capable of prediction.
Tag: sql server
SQL Convert Date Functions and Formats
(Rajendra Gupta) In this article, we will explore various SQL Convert Date formats to use in writing SQL queries.
STDelete: Deleting vertices in geometry objects
(Simon Greener) SQL Server Spatial, unlike spatial database type systems such as PostGIS, does not provide coordinate editing functions:
SQL SERVER – Difference Between Azure Data Studio and SQL Server Management Studio
(Pinal Dave) Earlier I blogged about SQL SERVER – Getting Started with Azure Data Studio. After reading the blog post, I receive an email from a reader asking about the primary difference between Azure Data Studio (ADS) and SQL Server Management Studio (SSMS).
Scaling SQL Elastic Pools
(blobeater) There are a few ways to scale a SQL elastic pool. For this blog post I show you how to scale up. It can be done via the Azure portal and Azure PowerShell but not T-SQL
Making Databases Personal
(Jason Brimhall) The second Tuesday of the month comes to us a little early this month. That means it is time again for another group blog party called TSQLTuesday.
SQL Server Sysadmin Audit Report Powershell script
(Jack Vamvas) Question: I need a powershell script which reports on SQL Server logins with Sysadmin privileges.
Power BI Scorecard Examples
(Gauri Mahajan) In any business process, analytical reporting plays a vital role to make data-driven decisions based on analytics and evaluation of a business strategy. Reporting and scorecards, with their drill-down abilities, go side-by-side in determining how a business is doing overall.
Table.Buffer() Does Not Buffer Nested Values
(Chris Webb) Here’s yet another entry in the list of useful things I learned from Ehren von Lehe on the Power Query MSDN forum: Table.Buffer() does not buffer nested table, record or list values inside the cells of a table. From this thread:
SQL Restore Database using DBATools
(Rajendra Gupta) This article will cover SQL restore database operations using the open-source PowerShell module, DBAtools, and will cover commands for backup restoration using the command Restore-DBABackup with many various permutations like restoring from file, separate directory, renaming databas