https://www.red-gate.com/simple-talk/development/dotnet-development/writing-custom-html-helpers-for-asp-net-mvc/
Switching from developing ASP.NET WebForms to MVC might seem awkward at first, but Ed demonstrates why the change needn't be painful, and how best to build a...
custom htmlasp netsimple talkwritinghelpers
https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/table-value-constructors-in-sql-server-2008/
Table Value Constructors (TVCs) are a useful feature of 2008, allowing you to specify tables of values and expressions. This has all sorts of uses. Users who...
sql serversimple talktablevalueconstructors
https://www.red-gate.com/simple-talk/databases/sql-server/sql-server-security-primer/
Introduction to SQL Server security and basic recommendations. Covers basic features and more advanced, including encryption and RLS.
sql server securitysimple talkprimer
https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/continuous-delivery-and-the-database/
Continuous Delivery is fairly generally understood to be an effective way of tackling the problems of software delivery and deployment by making build,...
continuous deliverysimple talkdatabase
https://www.red-gate.com/simple-talk/blogs/do-i-ask-too-much-of-my-beloved-rdbms/
OK Simple-Talkers I have a interesting situation driving be nuttier than squirrel poo. I have the following 2 steps in a scheduled SQL job I use to
askmuchbelovedrdbmssimple
https://www.red-gate.com/simple-talk/databases/sql-server/bi-sql-server/deploying-securing-updating-power-bi-reports/
Before Excel and other data-linked spreadsheets, business reports needed to be hand-crafted by IT experts, and changes were arbitrated slowly via change...
power bi reportssimple talkdeployingsecuringupdating
https://www.red-gate.com/simple-talk/development/dotnet-development/5-tips-for-understanding-managed-unmanaged-interoperability-in-net/
Interop doesn't have to be taxing. Interoperability between managed and unmanaged code happens under the hood in .NET. When you are doing Interop in your .NET...
tipsunderstandingmanagedinteroperabilitynet
https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/getting-started-testing-databases-with-tsqlt/
There are several frameworks for assisting with the testing of SQL Server databases, but tSQLt is popular because it is written in TSQL and is simple for a...
getting startedsimple talktestingdatabases
https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/on-adopting-the-mindset-of-an-enterprise-dba/
Although many of the important tasks a DBA has to perform should be done 'by hand', keying in commands or using SSMS, the canny DBA with a heavy workload will...
simple talkadoptingmindsetenterprisedba
https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/counting-more-efficiently/
Nearly a decade ago, I wrote a post called "Bad habits : Counting rows the hard way." In that post, I talked about how we can use SQL Server's metadata to
simple talkcounting
https://www.red-gate.com/simple-talk/blogs/database-design-chats-and-where-the-heck-have-i-been/
This is going to be the last time I say it (well, at least on my blog). Last year sucked. Partly due to Covid as my wife was hit hard and still isn't
database designchatsheck
https://www.red-gate.com/simple-talk/sysadmin/general/exchange-server-2010-the-first-public-beta-version/
Jaap takes a first look at the new Beta 1 of Exchange Server 2010, which is now available for download, and likes what he sees, especially with Outlook Live,...
exchange serverfirst publicbeta versionsimple talk
https://www.red-gate.com/simple-talk/development/angular/inline-pdf-viewer-in-an-angular-app-now-you-can/
This article by Aneesh Lal Gopalakrishnan describes the easiest way to integrate an inline pdf viewer into an angular application.
pdf viewerinlineangularapp
https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/sql-graph-objects-sql-server-2017-good-bad/
Graph databases are useful for certain types of database tasks that involve representing and traversing complex relationships between entities. These can be...
sqlgraphobjectsservergood
https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/representing-hierarchical-data-for-mere-mortals/
Why is it that we use XML, but with so little enthusiasm when it does so much, and is so feature-rich? Phil Factor argues that there are better ways of doing...
hierarchical datamere mortalssimple talkrepresenting
https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/sql-server-database-growth-and-autogrowth-settings/
It's easy to create a database nowadays with point-'n-click, but if you've left your database's autogrowth settings at their default, you may hit problems in...
sql server databasesimple talkgrowthsettings
https://www.red-gate.com/simple-talk/business-intelligence/data-science/data-science-laboratory-system-graph-databases/
Graph database are an intriguing alternative to the relational model. They apply graph theory to record the relationships between entries more naturally, and...
data sciencegraph databasessimple talklaboratorysystem
https://www.techmeme.com/110329/p61
The web's technology news site of record, Techmeme spotlights the hottest tech stories from all around the web on a single page.
google talktechmemegurunewbot
https://www.red-gate.com/simple-talk/blogs/data-activator-the-secrets-of-monitoring-alerts/
This great workaround can help you to improve the quality of Data Activator Alerts, allowing any flexible reactions to triggers
simple talkdataactivatorsecretsmonitoring
https://www.red-gate.com/simple-talk/development/javascript/multi-platform-mobile-development-with-phonegap/
It seems a great idea to have your application on all the main mobile platforms as well as on the desktop. Nothing beats writing an app specially for each...
multi platformmobile developmentsimple talkphonegap
https://www.red-gate.com/simple-talk/devops/containers-and-virtualization/a-beginners-guide-to-virtualizing-exchange-server-part-1/
The advantage of virtualizing your servers is that it helps you make better use of your hardware resources, and reduces some of your licensing costs, However,...
exchange serverbeginnerguidevirtualizingpart
https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/automating-common-sql-server-tasks-using-dmo/
Phil Factor's DMO automation procedures provide a valuable additon to any DBAs toolkit.
sql serversimple talkautomatingcommontasks
https://www.red-gate.com/simple-talk/blogs/compare-those-hard-to-reach-servers-with-sql-snapper/
If you've got an environment which is at the end of an unreliable or slow network connection, or isn't connected to your network at all, and you want to
comparehardreachserverssql
https://www.red-gate.com/simple-talk/blogs/caption-competition-20-the-size-of-the-matter/
We present a whimsical scene. The best (funniest) suggestion for what's going on wins $50 in Amazon credit. As always, extra consideration is given to
caption competitionsimple talksizematter
https://www.red-gate.com/simple-talk/development/dotnet-development/some-nhibernate-best-practices/
NHibernate can help to build a project more quickly if the database it connects to is sound. Otherwise, there are bound to be problems, but they are not...
best practicessimple talknhibernate
https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/dba-in-training-security/
Securing data is not always easy to do, but it should be the top responsibility for database administrators. From protecting the physical servers to preventing...
simple talkdbatrainingsecurity
https://www.red-gate.com/simple-talk/development/dotnet-development/asp-net-mvc-controllers-and-conventions/
Why is it that ASP.NET MVC has such strongly-enforced naming conventions? Can conventions for the default behaviour of code actually help to reduce the...
asp netsimple talkmvccontrollersconventions
https://www.red-gate.com/simple-talk/author/11799-brent-ozar/
Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz and the SQL Server First Responder Kit, and he loves sharing knowledge at...
brent ozarsimple talkauthor
https://www.red-gate.com/simple-talk/author-ai-usage-policy/
Author AI Usage Policy We do not accept any non-attributed AI (Artificial Intelligence) generated text in articles at Simple Talk for publication. The editors...
ai usage policysimple talkauthor
https://www.red-gate.com/simple-talk/blogs/a-beginners-guide-to-mysql-replication-part-3-multi-source-replication/?utm_source=chatgpt.com
Welcome back to the world of MySQL Replication! If you've been following this series, thank you for your support! And if you're new here, welcome! Before
beginners guidemysqlreplicationpartmulti
https://www.red-gate.com/simple-talk/resources/conferences/jacksonville-sql-saturday-2025-roundup/
Are SQL Saturdays finally back to the way they should be? This past weekend in Jacksonville Florida things sure felt like they are. There was an energy
simple talkjacksonvillesqlsaturdayroundup
https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/let-powershell-do-an-inventory-of-your-servers/
If you run a regular and comprehensive inventory of all the servers you manage, you can solve problems more quickly and answer most questions from management....
simple talkletpowershellinventoryservers
https://www.red-gate.com/simple-talk/featured/postgresql-basics-object-ownership-and-default-privileges/
In the first security article, PostgreSQL Basics: Roles and Privileges, I discussed how roles (users and groups) are created and managed in PostgreSQL
simple talkpostgresqlbasicsobjectownership
https://www.red-gate.com/simple-talk/databases/oracle-databases/high-availability-and-sla-requirements-for-oracle-database/
Designing a highly available database system involves taking various elements and combining them to suit your business needs and requirements. At the beginning...
high availabilityoracle databasesimple talkslarequirements
https://www.red-gate.com/simple-talk/databases/sql-server/tools-sql-server/page/2/
simple talktools
https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/estimating-disk-space-requirements-for-databases/
In the first of a series of Database Maintenance Tips and Tricks, Alex Kozak discusses some general issues surrounding disk space requirements for SQL Server...
disk spacesimple talkestimatingrequirementsdatabases
https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/sql-server-spatial-indexes/
Spatial Data in SQL Server has special indexing because it has to perform specialised functions. It is able, for example, to break down an indexed space into a...
sql serverspatial indexessimple talk
https://line6.com/support/topic/58705-lets-talk-about-simple-delay-vs-vintage-delay/
Let's talk about Simple Delay vs Vintage Delay. There is nothing simpler than Simple Delay, right? Actually no. Line 6 developer has decided that its...
lettalksimpledelayvs
https://www.red-gate.com/simple-talk/blogs/simultaneous-auto-growth-multiple-files/
SQL Server 2016 has a new configuration to control the process of auto-growth of multiple files in the same filegroup. Let's see how it works.
simple talksimultaneousautogrowthmultiple
https://www.red-gate.com/simple-talk/development/javascript/developing-google-chrome-extension-using-angular-4/?utm_source=simpletalk&utm_medium=pubemail&utm_content=20171128-slota2&utm_term=simpletalkmain
It may seem a tricky task to create a Chrome extension with TypeScript and Angular 4 but it turns out to be relatively simple. The advantage is that you gain...
google chrome extensionsimple talkdevelopingusingangular
https://www.red-gate.com/simple-talk/featured/what-is-change-management/
Change management is a process to prepare an organization to implement change. In this article, Rohan Kapoor explains the five components of change management.
change managementsimple talk
https://www.red-gate.com/simple-talk/development/dotnet-development/creating-custom-oauth-middleware-for-mvc-5/
Website visitors will have come to expect to be able to use OAuth authentication, rather than require yet another ID and password. Although MVC5 provides...
custom oauthsimple talkcreatingmiddlewaremvc
https://www.red-gate.com/simple-talk/databases/sql-server/learn/avoiding-database-deployment-disasters-7-tips/
Here are seven practical tips for any 'accidental DBA' or developer, faced with having to deploy an upgrade to a database live to production, in a development...
simple talkavoidingdatabasedeploymentdisasters
https://www.red-gate.com/simple-talk/blogs/an-interview-with-jeff-moden-exceptional-dba-2011/
He may call himself an "Accidental DBA", but the many SQL Server professionals who have benefited from Jeff Moden's knowledge and experience would agree
simple talkinterviewjeffmodenexceptional
https://www.red-gate.com/simple-talk/databases/sql-server/performance-sql-server/graphical-execution-plans-for-simple-sql-queries/
Learning how to read and analyze execution plans takes time and effort. But once you gain some experience, you will find them an essential skill for getting to...
execution planssql queriesgraphicalsimpletalk
https://www.red-gate.com/simple-talk/databases/sql-server/performance-sql-server/t-sql-window-function-speed-phreakery-the-fifo-stock-inventory-problem/
Sometimes, in the quest for raw SQL performance, you are forced to sacrifice legibility and maintainability of your code, unless you then document your code...
sql window functionstock inventoryspeedfifo
https://www.red-gate.com/simple-talk/blogs/squaring-the-nosql-circle/
NoSQL was a bold new revolution. Many of these databases are schema-less, or rather the schema is implicitly defined by the developer, and therefore is
simple talksquaringnosqlcircle
https://www.red-gate.com/simple-talk/databases/sql-server/performance-sql-server/get-your-scalar-udfs-to-run-faster-without-code-changes/
Microsoft has added a group of features called Intelligent Query Processing to SQL Server 2017 and 2019. In this article, Greg Larsen explains one of the...
scalar udfsrun fasterwithout codegetchanges
https://www.news-medical.net/opinion/e385a87e-5789-494c-99a5-fd20cbb62d50.aspx
A group of over 120 researchers from various institutions across Europe has performed the first genome-wide association study to reveal host genetic factors...
quitbeatingaroundbushokay
https://www.red-gate.com/simple-talk/databases/running-postgresql-in-docker-with-proper-ssl-and-configuration/
Learn how to run PostgreSQL in Docker with production-grade SSL encryption, certificate-based authentication, and custom configuration files.
ssl certificatesbest practicessecurepostgresqldocker
https://www.red-gate.com/simple-talk/blogs/caption-competition-40-barrel-of-laughs/
Man, machinery and...murder? Help us get to the bottom of this curious scene through the medium of caption. As ever, the funniest response will be swiftly
caption competitionsimple talkbarrellaughs
https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/filling-in-missing-values-using-the-t-sql-window-frame/
Since SQL Server delivered the entire range of window functions, there has been far less justification for using the non-standard ex-Sybase 'Quirky Update'...
missing valueswindow framefillingusingsql
https://talkpython.fm/episodes/show/348/dear-pygui-simple-yet-fast-python-gui-apps
I'm always on the look out for a good Python UI framework. This episode focuses on Dear PyGui. Dear PyGui: A fast and powerful Graphical User Interface Toolkit...
python guiepisodedearsimpleyet
https://www.red-gate.com/simple-talk/databases/oracle-databases/oracle-12-1-0-2c-hot-cloning-of-non-container-databases/
In the initial release of Oracle 12c (12.1.0.1c), a non-Container Database (non-CDB) could be converted to a pluggable database (PDB) using any of the...
oracle databasehotcloningnon
https://www.red-gate.com/simple-talk/opinion/editorials/simple-talk-2024-year-in-review/
Edit: Added pictures to the PASS section of the Redgate Hub Happy New Year to all of the Simple talk readers! What a year this has been. I just read a
simple talkyearreview
https://www.red-gate.com/simple-talk/opinion/opinion-pieces/dbas-vs-developers-a-sad-tale-of-unnecessary-conflict/
For many developers, does DBA really stand for Don't Bother Asking? David Poole thinks it is time to end the unnecessary conflict between developer and DBA,...
dbasvsdeveloperssadtale
https://www.red-gate.com/simple-talk/blogs/creating-functions-kusto-queries/
Discover once again the power of Kusto Queries creating Kusto Functions and using them to query Log Analytics and analyse Azure activities
simple talkcreatingfunctionskustoqueries
https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/faking-arrays-in-transact-sql/
It is a simple routine that we all need to use occasionally; parsing a delimited list of strings in TSQL. In a perfect relational world, it isn't necessary,...
transact sqlsimple talkfakingarrays
https://www.red-gate.com/simple-talk/development/dotnet-development/tracking-online-users/
Sometimes, the requirements for a web application include a list of users that are currently logged-in. It would seem, at first glance, to be pretty trivial,...
tracking onlinesimple talkusers
https://www.red-gate.com/simple-talk/development/dotnet-development/documenting-your-powershell-binary-cmdlets/
Whereas it is easy to provide inline documentation for a normal scripted PowerShell cmdlet or function so as to provide comprehensive help at the command-line...
simple talkdocumentingpowershellbinarycmdlets
https://www.red-gate.com/simple-talk/devops/software-delivery-devops-2/a-primer-on-defect-managment/
Defects in software can occur in any phase of the software creation process. The earlier and better they are managed, the easier they are to correct. In this...
defect managementsimple talkprimer
https://www.red-gate.com/simple-talk/development/dotnet-development/c-async-what-is-it-and-how-does-it-work/
The biggest new feature in C#5 is Async, and its associated Await (contextual) keyword. Anybody who is faced with creating Metro applications for Windows 8 is...
cwork
https://www.red-gate.com/simple-talk/development/dotnet-development/handling-errors-effectively-in-asp-net-mvc/
ASP.NET MVC gives you more options in the way that you handle exceptions. Error handling isn't intrinsically exciting, but there are many ways of avoiding the...
handling errorsasp netsimple talkeffectivelymvc
https://www.red-gate.com/simple-talk/databases/sql-server/tools-sql-server/sql-backup-6-wind-of-change/
One could be forgiven for thinking that there is little more you can do with any third-party Backup software than just ...er... backup databases. It takes a...
sql backupsimple talkwindchange
https://www.red-gate.com/simple-talk/opinion/geek-of-the-week/chuck-moore-geek-of-the-week/?article=775
Charles Moore is one of the greatest ever programmers. The 'Forth' language he invented is still in use today, particularly by NASA, and has never been...
chuck mooresimple talkgeekweek