When the DevOps pipeline does not include the database, the database can become a bottleneck and slow down the delivery of new features. In this article, Robert Sheldon discusses the challenges involved with including the database and how to overcome them.
2019-09-02
Wednesday September 4 14.00-19.00 BST/ 08.00-13.00 Central - Register for our free virtual learning event, to enjoy educational and entertaining sessions from Microsoft MVPs and celebrate 20 years of Redgate.
2019-09-02 (first published: 2019-08-29)
In this tip we look at a script that you can use to get better insight on your database tables to help you make some decisions about the data and also the structure of the table.
2019-08-30
Kathi Kellenberger continues her series on SSRS. In this article you learn hose to use parameters that let your report users control how the reports are filtered.
2019-08-29
Learn how you can gain estate-wide views of disk space usage, backups and other jobs, and application of recent SQL Server updates and patches, with SQL Monitor 9’s Estate pages. Using this feature, teams can review the overall health of all their servers and databases, identify potential issues before they escalate into real problems, and assign priorities, proactively.
2019-08-28
In this tip we look at some scripts you can use to monitor your database activity and usage based on the size of the SQL Server transaction log backups.
2019-08-28
While the most common methods of interacting with Azure Cosmos DB involve programmatic access, there are times when you might want to perform a quick change or take a peek at some of documents in a collection. In such instances, it is typically more convenient to rely on the graphical interface. Fortunately, there are several options you can use to accomplish.
2019-08-27
Five SQL Server experts have brought their collective years of experience working with and maintaining SQL Server data systems to identify the four strategies required for a successful estate-wide SQL Server monitoring solution.
2019-08-26
So far in this series, Andy Brown of Wise Owl Training has shed light on functions like CALCULATE, VALUES and FILTER, but it’s only when you understand the idiosyncrasies of the EARLIER function that you can claim to have genuinely cracked DAX. This article gives four examples of the use of this peculiar function, in the process explaining why it has such a misleading name. Using the EARLIER function properly all boils down (as is so often the case with DAX) to understanding row and filter context. The article also shows how to use the RANKX function to sort data into your required order.
2019-08-26
Poor data quality for any reason is very expensive in terms of man hours and decision making to all organizations. There are a number of ways to address the issue with both SQL Server Reporting Services and Power BI.
2019-08-23
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Giant, Kompleks Ruko Graha Indah, Blok F/1, RT.001/RW.002, Jatiwaringin, Pondok Gede, Bekasi, West Java...
BCA KCP Buaran Raya Hub.0853•5504•2311 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101,...
BCA Finance WTC Mangga Dua Hub.0853•5504•2311 Gedung WTC Jl. Mangga Dua Raya. 8 Lantai...
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers