Get a Return Every Time.
This article will show how you can produce a return regardless of variables passed and debugging tool for @SQL String.
Featured Blog: iFTS Manageability – Loading thesaurus files
MVP Simon Sabin continues his in depth look at Full Text Search in SQL Server 2008. This time he examines how you can load Thesaurus files.
Script Component as Data Source
In this article Dinesh Asanka demonstrates how you can use your own data sources in SQL Server Integration Services.
SQL Server 2005 Express Edition - Part 16 - Transactional and Merge Replication
Marcin Policht provides a step-through sample implementation of transactional and merge replication.
Terry-bites
A new technology could be a boon for database servers, dramatically increasing the amount of memory available for SQL Server.
Terry-bites
A new technology could be a boon for database servers, dramatically increasing the amount of memory available for SQL Server.
Terry-bites
A new technology could be a boon for database servers, dramatically increasing the amount of memory available for SQL Server.
How to lay out SQL Code
Anyone who inherits a database application dreads poorly laid-out SQL code. Development teams loathe it. Putting it right would be easier, if there was a common, agreed, standard in place, so why the difficulty?
Open Source SQL DDL Scripting Tool
Keeping track of your DDL is something that is critical and some sort of VCS system should be used. However pulling out your scripts from SQL Server sometimes entails a bit more than the standard scripting. New author Richard Sutherland brings us an open source project that can help you get this done. Complete with code.
Blogs
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Forums
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
TempDB Facts I
Comments posted to this topic are about the item TempDB Facts I
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers