Calculate SQL Server Page Counts, Correlate Stock Performance, Delta Tables Data Integrity and Date Conversions (MSSQLTips 12/9/2022)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [Database Monitoring: The ROI of Build vs. Buy]( [Calculate SQL Server Page Counts for Tables, Indexes and Objects]( [Calculate SQL Server Page Counts for Tables, Indexes and Objects]( Learn about how SQL Server stores data on a data page and the amount of space that is used to store data with this in-depth example.... [Correlating Stock Index Performance to Economic Indicators with SQL and Excel]( [Correlating Stock Index Performance to Economic Indicators with SQL and Excel]( This tip illustrates how to correlate nominal and real Gross Domestic Product (GDP) with business indicators using T-SQL and Excel. ... [Webinar - Database Monitoring: The ROI of Build vs. Buy]( [Webinar - Database Monitoring: The ROI of Build vs. Buy]( In this webinar, Microsoft Data Platform MVP, Grant Fritchey, is joined by an expert panel to share the pros and cons to building a monitoring system versus purchasing one: in other words, the ROI of Build vs. Buy...... [Enforce data integrity rules on your Delta tables using Synapse Mapping Data Flow]( [Enforce data integrity rules on your Delta tables using Synapse Mapping Data Flow]( In this article, we look at ways to enforce data integrity when working with Delta Lake tables when using Azure Synapse Analytics. ...... [Easy and Cost Effective way to Encrypt Every SQL Server Database]( [Easy and Cost Effective way to Encrypt Every SQL Server Database]( Learn why Becton Dickinson has selected DBDefence to protect their SQL Server data across numerous medical devices in a cost effective manner....... [SQL Convert Date to YYYYMMDD]( [SQL Convert Date to YYYYMMDD]( In this article we look at different ways to use the date format YYYYMMDD in SQL Server....... [Build a Secure SQL Server REST API in Minutes]( [Build a Secure SQL Server REST API in Minutes]( Learn how to build a secure SQL Server REST API in minutes with DreamFactory which is middleware that connects all of your applications across the enterprise in a secure manner....... [How to find a specific text string in a SQL Server Stored Procedure, Function, View or Tri]( [How to find a specific text string in a SQL Server Stored Procedure, Function, View or Tri]( In this article we look at a PowerShell script that is more accurate in finding strings within T-SQL code such as stored procedures, views, triggers, etc....... [SQL Server Best Practices for Data Quality]( [SQL Server Best Practices for Data Quality]( Data Quality | SSIS Integration - Accurate data is imperative for an organization to conduct cost effective decision making. Like everything else, change is constant for your data. There is a need to cleanse and validate data when received and on a ...... [By Douglas P. Castilho - ]( [Changing SQL Server Collation After Installation]( In this tip we look at different approaches to changing the SQL Server collation for the instance, database and table columns.... [By Aaron Bertrand - ]( [Creating a date dimension or calendar table in SQL Server]( A calendar table can be immensely useful, particularly for reporting purposes, and for determining things like business days between two dates. I often see people struggling with manually populating a calendar or date dimension table; usually there are lo... [By Daniel Calbimonte - ]( [Study material for exam AZ-400 Microsoft Azure DevOps Solutions]( If you are preparing for Microsoft AZ-400 Exam Microsoft Azure DevOps Solutions take a look at these list of resources to get you prepared.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}