Dynamic SQL Merge
This article by new author Glen Schwickerath uses dynamic SQL and SQL Server 2008's MERGE statement to create a useful stored procedure tool for synchronizing tables.
Managing Risk
Evaluating risk is something we do every day. Steve Jones talks a bit about using this to make ourselves better.
Dealing with Difficult Forum Users - The Flip Side
Earlier I talked about dealing with the difficult forum user from the perspective of providing help. Now let us look at from the flip side of the coin. You are asking for help and you aren't getting what you want or need. The first thing you have...
SQL Server consolidation strategies and best practices
Learn about the benefits of SQL Server 2008 consolidation on Windows 2008, with details on the different consolidation strategies available to organizations.
Duplicate Records using SQLCMD
We have an article here from Renato Buda that shows how to delete duplicate records from your tables. SQLCMD is used with variables that make it easy to write a general purpose script for any table.
The Disappearing DBA
During a "difficult period", a developer often sinks from view. When things are going well, suddenly they are the gunslinger, the hotshot. The DBA often looks on wistfully. For him, the "fame trajectory" seems to work in reverse.
Exploring SQL Server 2008’s Filtered Indexes
One of the most interesting features in SQL Server 2008 is filtered indexes. This article starts with a quick explanation and then digs into the details and results.
Handling workloads on SQL Server 2008 with Resource Governor
SQL Server 2005 resource allocation policies treat all workloads equally, and allocate shared resources as they are requested. It sometimes causes a disproportionate distribution of resources, which in turn results in uneven performance or unexpected slowdowns whereas the new Resource Governor of SQL Server 2008 allows organizations to define resource limits and priorities for different workloads, which enables concurrent workloads to provide consistent performance to the end users.
LinkedIn - Part 2
Recently I posted LinkedIn (part 1) about my efforts to better understand and use it as a networking platform. It ended up generating a lot of good comments, always nice to see, and I'll be addressing some of those here and/or in part 3 coming up...
Managing Risk
Evaluating risk is something we do every day. Steve Jones talks a bit about using this to make ourselves better.
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers