Certification High School
Certifications are being devalued in the IT industry because of cheating and braindumps. Steve Jones thinks we need to re-examine how we view them.
2009-07-20
940 reads
Articles
Help Me Name My New Blog
I am in the process of creating a new blog, but I am having difficulty coming up with a good name. I would like to go with a Hawaii-based theme on the blog, so a Hawaii-based name would be great.
2009-07-20
541 reads
Retaining historical index usage statistics for SQL Server - Part 3
In this, the third of the four part series on persisting the rowset results from the indexing Dynamic Management Views cached in temporary internal SQL Server structures we will explore what is required to store the missing index-related metadata.
2009-07-20
2,160 reads
Using the Resource Governor
SQL Server 2008 introduces a new feature, the Resource Governor, which provides enterprise customers the ability to both monitor and control the way different workloads use CPU and memory resources on their SQL Server instances. This paper explains several practical usage scenarios and gives guidance on best practices.
2009-07-20
2,190 reads
A Deadlock Occurrence and Resolution
This article gives an example of a deadlock occurrence and the resolution steps taken. (Republished from 2008).
2009-07-17 (first published: 2009-02-03)
28,717 reads
Building Your Brand at Work?
This Friday's poll asks how much you can help yourself while working at your job? Can you build your own brand at work?
2009-07-17
665 reads
Context Switching or Database Impersonation using EXEC AS
SQL Server 2005/2008 provides the ability to change the execution and security context with the EXEC or EXECUTE AS clause to allow a user to perform high privileged activities without allowing the user to have high privilege access.
2009-07-17
2,114 reads
Rant: Updating Application Databases the Right Way
Recently, a fellow DBA showed me a set of documentation on a commercially available product. This is a product people pay money for to license and use. It's not an in-house developed application or a community released free sample.
2009-07-17
2,589 reads
Setting up Service Broker for secure communication
Securely sending Service Broker messages from instance to instance requires a somewhat complex configuration. This tip walks you through the proper methods
2009-07-17
1,595 reads
SQL Server Best Practices - Implementation of Database Object Schemas
SQL Server 2005 implemented the concept of a database object schema. A schema is a distinct namespace to facilitate the separation, management, and ownership of database objects. It removed the tight coupling of database objects and owners to improve the security administration of database objects. Database object schemas offer functionality to control and help secure application objects within a database environment not available in previous versions of SQL Server.
2009-07-17
4,124 reads
Blogs
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers