Shorten Audits, Tighten Security with Minion Enterprise
Minion Enterprise can help you with security management in an enterprise.
Automatic UNDO in Oracle
Automatic UNDO Management isn't voodoo or black magic, although it can seem that way when it isn't clearly understood. How does Oracle decide how many UNDO segments to create at startup, and what is the underlying goal of the process? David Fitzjarrell investigates.
What Can You Do?
Security alerts and concerns are serious, but that doesn't mean that everyone will treat them that way.
Write Cleaner T-SQL Using Version Control
If we only use version control as a way to back up our code then it is pure overhead but actually there are real benefits. We can use source control to write better, cleaner, more readable code.
Power Query Formula Language in Power BI Desktop
The Power Query Formula Language (PQFL) is a functional language that drives the Power BI transformations, and allows you to create mashup queries from scratch. In this article, Rob Sheldon demonstrates how to use it in Power BI Desktop to extract data from its source, filter rows, specify the columns, clean the data, and create visualisations.
SQL Server Stored Procedures and SET options
SET options on stored Procedures work a bit different when compared with ad-hoc queries. These differences in behavior are often overlooked when developing the procedures and generating deployment scripts. This mistake can lead to undesired behavior in the application.
How to Avoid Conditional JOINs in T-SQL
Relational databases go out of their way to execute SQL, however bad the crimes against Codd and relational theory within the query might be. The 'conditional join' can be executed, but at great cost. As always, it is much better to sit back and restate the problem in a set-based way - Dwain Camps explains.
Creating Dashboards for Mobile Devices with Datazen
In this fourth installment, Arshad Ali demonstrates creating filters, publishing dashboards to the Datazen server and creating drill-through dashboards.
Install SQL Server Management Studio with Web Installer without Internet Access
One of the new features of SQL Server 2016 is the introduction of a Web Installer for the client tools. In this article, Daniel Farina goes through the entire process of downloading and installing the client tools even on machines without internet access.
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers