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
Articles
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,169 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
Increasing the Visibility of Database Changes in Flyway Development
If you save a metadata 'model' for every new version of a database created by Flyway, you can compare the current model to the previous one to see what changed. In turn, you can then generate a database E-R diagram that highlights the changed objects, instantly making those changes visible to other team members
2022-08-03
How to Get Data Using Python in Power BI
This article shows how you can incorporate Python scripting inside a Power BI report.
2022-08-01
12,492 reads
Security in MySQL: Part Two
There’s more to security in MySQL than user account privileges. In this article, Lukas Vileikis explains the other components of MySQL security
2022-08-01
Training: Maximize the power of SQL Prompt with SQL Toolbelt Essentials
Watch this 30-minute training session to discover how you can use SQL Prompt in combination with other tools in SQL Toolbelt Essentials to boost productivity, simplify collaboration, and deliver accurate database changes faster.
2022-08-01 (first published: 2022-06-04)
2022-07-29
980 reads
A day in the life of a DBA using SQL Monitor: in a 90 second video!
We created a new, short video to show how a DBA can use SQL Monitor in their day to day work, including sharing reports with senior leaders. Watch it now.
2022-07-29
Running a Python Application as a Windows Service
In this article, we look at how to build a Python application that runs as a Windows Service to handle ongoing routine tasks.
2022-07-29
Blogs
Audit – Security Compliance Frameworks (Part 1)
By Vinay Thakur
This blog series on Audit/Compliance/Security, this is first blog where we would discuss about...
Restore SQL Server Database to an OrbStack Container
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
Day of Data Baton Rouge Slides and Code
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Forums
Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happened
Comments posted to this topic are about the item Can You Really Downgrade from...
What is CPU Usage?
Comments posted to this topic are about the item What is CPU Usage?
Limiting Checkpoints
Comments posted to this topic are about the item Limiting Checkpoints
Question of the Day
Limiting Checkpoints
If I use the -k parameter with a number after it, what does this change in SQL Server?
See possible answers