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
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
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,196 reads
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
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
This article shows how you can incorporate Python scripting inside a Power BI report.
2022-08-01
12,571 reads
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
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
1,057 reads
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
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
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers