Using SQL Server 2008's MERGE statement
SQL Server 2008's new MERGE statement allows you to insert, update, or delete data based on certain join conditions in the same statement.
Which Platform Do You Work On?
The growth of SQL Server's subsystems leaves Steve Jones wondering how should we be thinking about the product.
XML Workshop X - Working with namespaces
With the tenth installment of his series on XML, Jacob Sebastian turns his attention to the art of namespaces and how you can avoid ambiguity in interpreting various elements.
Optimize tempdb in SQL Server by Striping and Splitting
Find pointers to optimize tempdb performance in SQL Server by striping and splitting across multiple files in SQL Server 2005.
The Baker's Dozen: 13 Productivity Tips for Transact-SQL 2005
SQL Server 2005 offers T-SQL language features that can improve your productivity.
PC Energy Use
Spreadsheet to calculate a reasonably accurate picture of energy use of PCs and peripherals in your company.
Whack a Database
The SQL Server team is looking for feedback on deleting databases and Steve Jones gives a few ideas.
Creating Custom Reports for SSMS
The new custom report feature of SQL Server 2005 SP2 allows you to incorporate Reporting Services report definitions (.rdl) files into SQL Server Management Studio (SSMS).
Replicate Stored Procedure Execution
Replication usually involves data, but it can also include stored procedures as well. SQL Server expert trainer Andy Warren brings us a look at how you can ensure that your stored procedures move as well.
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers