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
Digging into an AI Algorithm
One place where Artificial Intelligence systems might shine is the medical field.
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 […]
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
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
How Often Do You Update During Issues?
When a disaster occurs and your staff is working on it, what cadence of updates should your customers expect?
How to Get Data Using Python in Power BI
This article shows how you can incorporate Python scripting inside a Power BI report.
Learning through Puzzles
Different people respond to different types of learning techniques. Maybe a puzzle is the way that you learn.
Looking Back
Today Steve talks about retrospectives and how we learn and grow as software professionals.
Blogs
Working with Neo4j Imports–I HATE CASE SENSITIVITY
By Steve Jones
I’ve been working to better understand graph databases and where they can be useful....
Daily Coping 8 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Azure DevOps: Deploying Power BI reports with a parameterized gateway-based Data Source
By Rayis Imayev
(2022-Aug-08) You have developed your Power BI report, by connecting one or more sourcing datasets,...
Forums
sql server Invalid Views(including ambiguous columns)
Hi, I need to check for invalid views in my DB (including ambiguous columns)...
How to use a Powershell script to track the network latency issue in AOAG
Comments posted to this topic are about the item How to use a Powershell...
Ask SSC