Power BI Report Builder Parameters Tutorial
Learn how you can adjust the way users interact with reports and change font sizes as well as add parameters for filtering.
2022-07-11
16,298 reads
Learn how you can adjust the way users interact with reports and change font sizes as well as add parameters for filtering.
2022-07-11
16,298 reads
During Build 2022, Microsoft announced a new feature, Datamarts for Power BI. MVP Dennes Torres explains this new feature and provides and example.
2022-07-11
Frequent deployments can give you greater flexibility in meeting changing business requirements, but if code quality is poor this may cause major headaches for your customers and your whole organization. Join Microsoft Data Platform MVP, and AWS Community Builder Grant Fritchey to discover the benefits of, and best practices for frequent deployments.
2022-07-11
Learn about how you can monitor your Azure Storage account and set alerts to let you know when to take action.
2022-07-08
2,900 reads
In this article we cover different ways to convert a SQL Server numeric value into a string value.
2022-07-08
IDC have reported that ‘the shortage of full-time developers will increase from 1.4 million in 2021 to 4.0 million in 2025’. So how do teams keep pace with business demands, without relying on recruiting extra staff? Discover 4 ways that teams can elevate efficiency and code quality to speed up delivery of accurate database changes.
2022-07-08
Microsoft announced Azure Synapse Link for SQL. In this article, MVP Dennes Torres explains the new feature.
2022-07-06
Headquartered in Louisville, Kentucky, Republic Bank is one of the most innovative and forward-looking banks in the US, with 42 full-service banking centers across five states and assets of $6.2 billion. Find out why they chose Redgate SQL Monitor.
2022-07-06
Learn a little basic graph theory in this article that replaces a GROUP BY clause.
2022-07-04 (first published: 2019-10-17)
12,076 reads
SQL Server Central Editor, Steve Jones is joined by a panel of industry experts from around the globe to discuss their experiences with digital transformation, and the impact it had on themselves, their teams and the wider organization.
2022-07-04
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