Creating One-Time Jobs - SQL School Video
SQL Agent is one of the handiest subsystems in SQL Server. This video shows how you can schedule a one-time job to handle something without you being there.
Smart Teaching
Do computers help us learn quicker? Do we need to in today's wired world? Steve Jones talks a little about learning in today's editorial
How do I run code automatically when SQL Server starts?
The need to run a stored procedure or SQL Agent Job when SQL Server or SQL Agent starts is a common requirement in the world of SQL Server administration. This article gives an overview of the ways to execute SQL stored procedures or SQL Agent jobs on startup.
Powerful Geographical Visualisations made easy with SQL 2008 Spatial (Part 2)
This is the final article in a series on how to perform data visualisation with SQL Server 2008
Powering up DTS with PerlDTS
This article introduces the PerlDTS project that provides a Perl distribution to access and execute MS SQL Server 8 DTS packages.
The Set-Based Limit
An interesting post from Linchi Shea inspires Steve Jones to comment on procedural v set-based programming.
Powerful Geographical Visualisations made easy with SQL 2008 Spatial (Part 1)
This article is part one of a two part series on how to perform data visualisation with SQL Server 2008
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