To ensure that queries run as efficiently as possible, the database administrator needs to monitor performance to find inefficient queries. This article focuses on exploring how a DBA can monitor the I/Os against an instance of SQL Server, using Dynamic Management Objects, or more commonly know as Dynamic Management Views (DMVs) and Functions (DMFs).
2010-08-11
4,130 reads
This is just a quick one prompted by a question on the SSIS Forum, how to programmatically add a precedence constraint (aka workflow) between two tasks. To keep the code simple I’ve actually used two Sequence containers which are often used as anchor points for a constraint. Very often this is when you have task that you wish to conditionally execute based on an expression.
2010-08-10
2,547 reads
On Aug 18, 2010 there is a SQL Social meeting in Kent, UK. Read about the details and attend if you are in the area.
2010-08-10
1,683 reads
A Technique to deal with moving data from multiple schemas into one table
2010-08-09
6,404 reads
This challenge invites you to create a graph/chart using T-SQL
2010-08-09
3,795 reads
Many times there is the need to restart the SQL Server services, this could be a reboot of the server after patching, service pack installation or due to some other reason. Sometimes we may face issues after the restart for example the SPN is not registered, a database is offline etc... For the solution you can use the below standard SQL Server validation checklist after you restart your SQL services.
2010-08-09
3,617 reads
Red Gate Software is having another million dollar challenge. If you work for a small software company, or have a software product of your own, read about the challenge.
2010-08-06
4,013 reads
SQL databases come in all shapes and sizes and schemas. This month, our SQL expert helps with condensing, growing and redesigning databases.
2010-08-06
4,321 reads
Take a moment and vote on the new SQL Rally logo that will be used for the event next spring.
2010-08-06
1,762 reads
A short editorial explaining the pitfalls of using search engines as reference for DBA's.
2010-08-05
328 reads
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Comments posted to this topic are about the item Removing TDE
Comments posted to this topic are about the item The day-to-day pressures of a...
How do I remove TDE encryption of data from database xxx?
See possible answers