Snapshots - Part 1
Longtime replication expert Andy Warren takes a look at the initial snapshots involved with replication and dives into an explanation of what's involved.
2008-02-26
2,622 reads
Articles
Using the ReportViewer Control in a WebForm with Parameters
A short article by Darren Herbold, reporting services trainer and consultant that shows how you can easily use a Report Viewer on a web page.
2008-02-26
11,510 reads
Blast Off
SQL Server 2008 launches today and there's are additional events all across the country coming up.
2008-02-26
29 reads
Blast Off
SQL Server 2008 launches today and there's are additional events all across the country coming up.
2008-02-26
38 reads
Blast Off
SQL Server 2008 launches today and there's are additional events all across the country coming up.
2008-02-26
32 reads
Featured Blog: iFTS Transparency – dm_fts_parser
In this post on Integrated Full Text Search (iFTS) in SQL Server 2008, we look at the new dmv dm_fts_parser.
2008-02-26
1,987 reads
Full Control Over a Randomly Generated Password
All of us need a steady stream of random passwords for the various systems we manage. Peter Larsson brings us an interesting T-SQL solution that generates one for us.
2008-02-25 (first published: 2007-04-25)
8,007 reads
Featured Blog: SQL Server 2008 – iFTS Introduction
This is the first of a series of posts on the new Integrated Full Text feature in SQL Server 2008 from MVP Simon Sabin. We'll continue this series on with an in depth look at this feature.
2008-02-25
2,626 reads
MDX Numeric Functions: The Min() Function
Business Intelligence Architect Bill Pearson introduces the numeric Min() function, and leads hands-on practice examples of its use.
2008-02-25
1,754 reads
SSIS Usage of Checkpoint File
In this article Dinesh Priyankara explains how Checkpoint files can be used in a SSIS package so that the package can be restarted from the point of failure.
2008-02-25
1,528 reads
Blogs
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
Looking Back at the Redgate 2026 Company Kickoff
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
PASS Data Community Summit 2025 Recap
By alevyinroc
This is long overdue but life and distractions happened. It’s been a little over...
Forums
Microsoft no longer being supported?
The word is finally out that Microsoft is no longer supporting SSRS. I just...
SQL Agent job running gMSA cannot backup to NAS target
I'm running a group MSA for the database engine and SQL Agent in a...
sys.query_store_query question
All, My query is as follows: SET DATEFORMAT dmy SELECT p.query_id, DATEADD(MICROSECOND,-rs.max_duration,rs.first_execution_time) AS starttime,...
Question of the Day
Encoding Strings
I have this code in SQL Server 2025. What is the result?
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(@message); SELECT @encoded AS EncodedResult;See possible answers