Python Statistical Functions, SQL Server vs Oracle: Data Masking, Collation Functions and more (MSSQLTips 7/27/2022)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [Are you wasting too much time monitoring and managing your instances?]( [SQL Server vs Oracle: Data Masking]( [SQL Server vs Oracle: Data Masking]( In this article, we look at how to mask/hide data for users using Dynamic Data Masking in SQL Server and Data Redaction in Oracle.... [Python Built-in Statistics Functions using SQL Server Data]( [Python Built-in Statistics Functions using SQL Server Data]( Learn how to use statistical functions in Python with data from a SQL Server database along with several different examples.... [Highly efficient database monitoring and management]( [Highly efficient database monitoring and management]( Redefining database operations to give you full control over your database farm - efficiently.... [SQL Server Collation Properties using the COLLATIONPROPERTY Function]( [SQL Server Collation Properties using the COLLATIONPROPERTY Function]( In this article we look at how to find the SQL Server collation settings at the instance, database, and column level along with functions to get more information about collation settings.... [Solved: SQL Server Management and Performance Complexity]( [Solved: SQL Server Management and Performance Complexity]( We need to transition our team from single instance management and monitoring to managing the overall environment and addressing our most pressing needs to support the organization. How can we move from managing the trees to managing the forest in an... [SQL Server Loop through Table Rows without Cursor]( [SQL Server Loop through Table Rows without Cursor]( In this tip we look at a comparison of a SQL Server cursor and a While Loop to show how to perform the same operations using the two different looping mechanisms.... [T-SQL Best Practices and Tuning for the BI/DWH Developer]( [T-SQL Best Practices and Tuning for the BI/DWH Developer]( In this webinar, we will go over some T-SQL best practices from the viewpoint of the BI developer when working in the Microsoft Data Platform stack.... [My First SQL Server Business Intelligence Project Tutorial]( [My First SQL Server Business Intelligence Project Tutorial]( In a Business Intelligence project, data is the currency and analytics is the merchandise. Without having the right type, amount and shape of data, one cannot get the right kind of analytics.... [Calculating Costs for Microsoft SQL Server]( [Calculating Costs for Microsoft SQL Server]( This white paper looks at how costs can be controlled with sufficient understanding of the Microsoft SQL Server licensing process, and how you can use some of the requirements to your advantage.... [By Ashish Kumar Mehta - ]( [Attach SQL Server Database Without Log File]( In this tip, we will cover how to attach a SQL Server database that does not have its transaction log files.... [By Greg Robidoux - ]( [How to get length of Text, NText and Image columns in SQL Server]( There is sometimes a need to figure out the maximum space that is being used by a particular column in your database. You would initially think that the LEN() function would allow you to do this, but this function does not work on Text, NText or Image da... [By Scott Murray - ]( [SQL Server Reporting Services Rest API]( In this tip we look at how to use the new REST API for accessing certain meta data details concerning SQL Server Reporting Services (SSRS).... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}