Forum Search Changes
Forum Searching The forum search is back, allowing you to search for specific issues in our discussion forums. There is a search link above the forum thread lists. Please report any issues to the webmaster.
Linked Server Optimization
This article demonstrates the negative affect that linked servers can cause in queries and offers alternatives to speed up performance.
The Truth Table
Truth tables are an important part of working with logical values in SQL Server. Yousef Ekhtiari brings us some T-SQL that can help you construct those many variable truth tables and ensure you are getting the results you expect.
Using VBScript to Automate Tasks
This article discusses why VBScript should be one of the tools you use to manage your server. Sample scripts show how to remove files over x days old and how to FTP files.
Apply Test-Driven Development to your Database Projects
This article from MSDN discusses the benefits of TDD and bringing unit testing to your database development.
Bad Meetings
A joint editorial this week from the Red Gate team looking back at the news of the week.
Bad Meetings
A joint editorial this week from the Red Gate team looking back at the news of the week.
Extending SQL Server Reporting Services with SQL CLR Table-Valued Functions
This article describes how to take advantage of SQL CLR table-valued functions to combine different types of data sources to create rich and exciting SQL Server Reporting Services reports.
Dreams of the Future
Steve Jones looks ahead to an interesting trip for the future of a couple of technical geeks.
How to Break Replication
David Poole is a regular author at SQLServerCentral.com, sharing many of his knowledge and experiences with us over the years. This time he examines some of the issues that you might have with replication.
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers