Using OpenDataSource - SQL School Video
The OPENDATASOURCE command is used for adhoc access to other servers or files in a filesystem. MVP Andy Warren shows how you can quickly use this to access data in other sources.
Collecting performance counters and using SQL Server to analyze the data
Quite frequently I find myself in situation where I need to get detailed information on performance monitor counters. For example I need to determine which processes are consuming all CPU at certain times.
Encrypting SQL Code
This Friday's poll looks at the encryption options for your code in SQL Server. Steve Jones asks if there is a benefit for these routines.
Encrypting SQL Code
This Friday's poll looks at the encryption options for your code in SQL Server. Steve Jones asks if there is a benefit for these routines.
Encrypting SQL Code
This Friday's poll looks at the encryption options for your code in SQL Server. Steve Jones asks if there is a benefit for these routines.
Measuring the Impact of Task Switching/Multitasking
Many of us make a living by working on tasks while monitoring email, taking a few calls, and in non uncommon cases also keeping up with Facebook, Twitter, and more. Often it's multiple tasks, and we get better at plate spinning.
Testing a SQL Server environment before an upgrade
Learn how application and full regression testing can ensure a successful SQL Server upgrade – and save on money and performance headaches.
SQL Unit Testing
This article talks about an easy way to add hundreds of unit tests in your solution using SQL Load Test from Codeplex.
Container Tasks in SQL Server 2008 Integration Services
Learn how container control flow tasks within SSIS can be used by database developers to provide a structure to a package and repeat control flows.
Database level permissions for SQL Server 2005 and 2008
I am new to SQL Server 2005/2008 having administered SQL Server 2000 and below. I have heard there are a lot of new permissions at the database level. What are they and what do they give rights to perform?
Blogs
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Forums
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries