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
Articles
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
VDBA RAW
I've had a few requests in the past, so I decided to just give it a go. Here's the raw footage from the episode of the Voice of the DBA podcast that I shot this week. It's uncut, the raw footage of what I took off the camcorder,
2009-07-17
940 reads
Auditing with SQL Profiler
Complete package to allow tracking of any data that Profiler can capture and storage for auditing purposes, use to satisfy SOX compliance.
2009-07-16
5,880 reads
Setting Single User Mode - SQL School Video
This edition of SQL School brings us a look at how to set single user mode for your SQL Server instance.
2009-07-16
4,201 reads
Being The Best vs. Being Affordable
I read a post on Brent Ozar’s blog last week that discussed employers’ expectations when hiring new team members. Though the story was specific to database professionals, the same principles apply to almost any hiring situation. The moral of Brent’s story...
2009-07-16
1,541 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-16
658 reads
Blogs
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Half of All Engineers
Comments posted to this topic are about the item Half of All Engineers
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers