Distributed Computing Principles and SQL-on-Hadoop Systems
A look at SQL-On-Hadoop systems like PolyBase, Hive, Spark SQL in the context Distributed Computing Principles and new Big Data system design approach like the Lambda Architecture.
Turn Out the Lights
Today we have a guest editorial from Andy Warren that looks at the costs associated with our behavior.
How to Stop a SSIS Package Execution from Code
In this tip we look at a way to stop the execution of a SSIS data flow task that is running by executing an outside process to stop the data flow immediately.
Managing Data Masking Rules in Larger Teams using Source Control
What if you have several people in the team who are responsible for data security across your databases, and they need to work together to develop and maintain the data masking configurations, which must then be applied consistently as part of an automated provisioning process? How should they do it? The solution turns out to be simple: source control.
The Ongoing Costs of Building Software
There are lots of costs to building your own software, which Steve Jones notes might not be what you want to spend over time.
Create, Alter, Drop and Execute SQL Server Stored Procedures
In this tip we look at some examples of how to get started with creating, modifying and deleting SQL Server stored procedures.
Why you Should Avoid Using the @@IDENTITY Function
Phil Factor demonstrates why SQL Prompt has a 'Best Practice' rule (BP010) that checks for use of the @@IDENTITY function, and suggests less error-prone ways to get the latest identity values used in a table.
20 Years of Compare
When we started SQLServerCentral, there were originally 7 of us. We all decided to "invest" $50 to get the site going. With this seed money, we paid for a VM that hosted both SQL Server and IIS. This was enough money to run the site for 6+ months, and we set about building an online […]
Database Build Blockers: Mutually Dependent Databases
Phil Factor demonstrates a clever way to create 's...
Hiding What You Shouldn’t See
In this week's SImple Talk editorial Kathi Kellenberger looks at data that should be hidden and how to get security right within your organization.
Blogs
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Future-Proofing: How to Stay Ahead in FinOps
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers