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.
2022-08-10
Articles
Business Analytics from Application Logs and SQL Server Database using Splunk
Learn how Splunk can be used to get information from application logs or a SQL Server database.
2022-08-08
1,472 reads
Building a Database with Flyway
Flyway, especially Flyway Teams edition, can be used in several different ways to accommodate a database development that was originally based on builds rather than migrations. This article explores four different ways to use Flyway to build a particular version of a database, from the ground up, using a single migration script. It should help teams select the best way to incorporate Flyway into an existing database build system, during development, while benefitting from use of Flyway's versioned migration system for deployments and releases.
2022-08-08
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
2022-08-08
How to setup multi-subnets Azure SQL VM AG group based WSFC (Windows Server 2019)
In this article, we will learn how to set up Azure SQL VM AOAG based on Windows Server 2019 Failover Cluster step-by-step, it is a detailed supplement to the Microsoft official articles and it is a beginner's guide for people who have no experience to do that, please read this article closely with Mircosoft's guide: […]
2022-08-06 (first published: 2022-07-27)
1,600 reads
How to Format Dates in SQL Server (Hint: Don’t Use FORMAT!)
Here's why you should NEVER use the FORMAT() function in SQL Server.
2022-08-05
19,956 reads
[From the archives] 5 things to look for in a 3rd party database monitoring tool
Are you evaluating the effectiveness of your homegrown database monitoring tool or looking at investing in a 3rd party one? This helpful blog post suggests 5 things to look for in your evaluations.
2022-08-05
Generate Random Dates in T-SQL
In this article we look at how to generate random dates in SQL Server to build a sample dataset along with code and examples
2022-08-05
Tracking Configuration Changes Against a Baseline
One of the great things about SQL Server is that the platform has grown to include a number of configuration options and switches that allow a DBA to get the most performance from their instance that is possible. One of the downsides of the platform, however, is that any sysadmin can make changes (or db_owner […]
2022-08-03
3,036 reads
Identify and Correct a Large SQL Server Error Log
Learn how to find and remove a large SQL Server Error Log file when it consumes a lot of space on your drive
2022-08-03
Blogs
The pros and cons of self-service BI: What every industry leader should know
The post The pros and cons of self-service BI: What every industry leader should...
Off to the PASS Data Community Summit 2024
By Steve Jones
As this publishes, I’ll get taxiing down the runway at DIA (fingers crossed) and...
Implement a RAG Solution Using Azure SQL Database
By John
AI and ChatGPT are all the rage these days. Seems like around every corner...
Forums
What Services Does Web Artistary Offer as a Video Animation Company in New York?
Web Artistary, a top video animation company in New York, offers a wide range...
How to change font size in Query window
I am running SQL Server 20.2. When I copy a query into the query...
is the ssrs auto refresh without its faults
Hi, i considered power bi with embedded for this. Not a big fan...
Question of the Day
Cloud Sources for the Data Migration Assistant
Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)
See possible answers