SQL Server 2005 log shipping setup using the wizard
Along with some best practices, SQL Server MVP Hilary Cotter shares a log shipping setup process from start to finish.
2008-04-22
2,862 reads
Additional Articles
SQL String User Function Workbench: part 1
Robyn and Phil go back to basics and hammer out some basic String-handling User Functions in TSQL, based on Python examples. Plenty of sample code, and TSQL programming tricks.
2008-04-22
4,839 reads
2008-04-22 (first published: 2008-02-22)
3,212 reads
Identify SQL Server 2005 Standard Login Settings
Gaining insight into my SQL Server standard and Windows logins has historically been a challenge in terms of determining password changes, failed login attempts, etc. I have noticed that you have experienced the same issue with your tip entitled 'When was the last time the SQL Server sa password changed' and I have noticed some information in the forums on the topic as well.
2008-04-21
3,407 reads
SQL Server 2005 Express Edition - Part 20 - Authenticating Merge Web Synchronization
We have been discussing SQL Server 2005 Express Edition replication-specific features, investigating authentication mechanisms that are available in order to accommodate connection attempts from remote clients interacting with SQL Server-based distributor via Internet Information Services. We will continue coverage of this topic here.
2008-04-21
1,679 reads
Integrating Reporting Services into Your Application
This paper summarizes the different ways that developers can integrate SQL Server 2005 Reporting Services capabilities in their applications.
2008-04-18
10,171 reads
Set Functions: The StripCalculatedMembers() Functio
Business Intelligence Architect Bill Pearson continues his examination of MDX functions, this time introducing StripCalculatedMembers(). In this article, we expose the function, and then lead a hands-on practice session with examples that reinforce the concepts.
2008-04-18
2,513 reads
SQL Data Generator
A new tool from Red Gate software that helps you generate realistic test data for testing your SQL Server applications.
2008-04-17
3,550 reads
myLittleAdmin for MS SQL Server 2005
A short review from the perspective of a web hoster on this handy software utility.
2008-04-16
5,463 reads
SQL Server Script to Create Windows Directories
An interesting script to handle file tasks from within SQL Server.
2008-04-16
5,394 reads
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
Forums
BCA KCP Pasar Minggu Center Hubungi.0821•3111•185
BCA KCP Pasar Minggu Center Hub.0821•3111•185 Jl. Lenteng Agung Raya No.26 E-F, Ps. Minggu,...
BCA KCP Semanggi No. Telp 083139530154
Whatsapp: 083139530154 Wisma GKBI, Jl. Jend Sudirman 28 Suite G 01, RT.14/RW.1, Bend....
BCA KCP Pulogadung Hub.0851•8812•0691
BCA KCP Pulogadung Hub.0851•8812•0691 Jl. Raya Bekasi No.B-C Km.19 No.30, RT.1/RW.6, Wil, Kec. Pulo...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers