Generate SQL Agent Job Schedule Report
I am trying to come up with a list of Job Schedules so I can make sure that my Jobs are staggered. Is there a way to query the system tables so I do not have to manually keep track of the schedules?
SQL Server 2008 Full-Text Search: Internals and Enhancements
This white paper covers in detail the new integrated full-text search architecture, new features, main changes from full-text search in SQL Server 2000 and SQL Server 2005, and limitations and best practices for deploying applications that use SQL Server 2008 full-text search.
E-Discovery and Data Retention
While most DBAs might never encounter the legal aspects of their professional, Phil Factor brings to light a few things that you might want to be aware of in these litigious times.
Investigating the new Spatial Types in SQL Server 2008 - Part 2
This is the second article in the series on the new spatial data types in SQL Server 2008
Using Script Component as a Transformation - SQL School Video
Script components greatly enhance the flexibility of your SSIS packages. MVP Brian Knight shows how you can use this in your transformations.
Escaping In Expressions
The expressions language in Integration Services is a C style syntax, so you may need to escape certain characters.
Using Partitioned Tables with Multiple Filegroups for High Availability
Let us look at another means to increase the availability of your highly critical databases. We will extend the concept of filegroups as highlighted in a previous tip on Disaster Recovery Procedures in SQL Server 2005 Part 2 (Isolating Critical Objects) wherein we can use filegroups to isolate and store a critical object.
Investigating the new Spatial Types in SQL Server 2008 - Part 1
This article introduces us to the new Spatial Data Types in SQL Server 2008
Trust But Verify
As data professionals we need to be sure that we can present back the data we receive. Perhaps other people should embrace this mantra in other lines of work.
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