Generating Database Objects Scripts in SQL Server 2005
SQL Server Management Studio provides a wizard to generate script out of a database. Learn how to automate the process to generate and store the database script.
2009-10-12
3,712 reads
Additional Articles
Configure disaster recovery across SharePoint farms by using SQL Server log shipping
This article describes how to use Microsoft SQL Server 2005 or Microsoft SQL Server 2008 log shipping to create a disaster recovery farm in a geographically distributed data center for Microsoft Office SharePoint Server 2007 with Service Pack 2 (SP2). By using this configuration, you can provide a disaster recovery site that provides current search results when a failover occurs. The article assumes that you are familiar with the concepts and terms presented in Plan for availability (Office SharePoint Server).
2009-10-09
2,570 reads
SQL Server 2005 Index Best Practices
In continuing with our series of tips on Best Practices for SQL Server I'm turning my sights on Maintenance. Specifically in this tip we will be discussing Index maintenance: when, if, why, and how are questions that will be addressed.
2009-10-09
6,894 reads
How to easily identify a scheduled Reporting Services report
In this tip I will show you an easy way to identify the scheduled Reporting Services report, so you can run that scheduled job to reproduce the reports and delivery of the reports.
2009-10-08
3,640 reads
SQL Server RDL Specification
In today's database reporting market, most vendor applications use a proprietary format for representing the definition of a report. In addition, vendors that provide a report execution environment usually only support their own design tools. For customers, this means that reports cannot be easily moved between different reporting implementations and that there are few options for choosing new tools that work with their existing execution environments.
2009-10-08
440 reads
Securing Reporting Services
Marcin Policht continues his discussion of implementing Reporting Services on SQL Server 2005 Express Edition, focusing in particular on security-related topics. This article continues this subject by describing other technologies that assist with data protection, their corresponding configuration settings, and a few authentication and authorization caveat
2009-10-07
2,632 reads
Installing SQL Server
Because installing SQL Server is so easy it is tempting to cut corners, fail to plan properly and blindly accept default options without considering the alternatives.
2009-10-06
4,162 reads
On demand creation and destruction of a Linked Server for SQL Server
Create a linked server on the fly in this tip.
2009-10-06
3,401 reads
Collecting Query Statistics for SQL Server 2005
With SQL Server 2005 DMVs, we can easily find query performance statistics. Every DBA has a favorite script to find query performance stats. I also have one. But, are all the queries captured by the DMVs? In this tip I will walk through capturing some of this data and show what is capture and what is not captured by the DMVs.
2009-10-05
4,784 reads
Using Transfer Error Messages and Transfer Master Stored Procedures Tasks in SSIS
DBA's can use the Transfer Error Messages and Transfer Master Stored Procedures tasks to transfer error messages and stored procedures between difference SQL Server instances.
2009-10-05
2,328 reads
Blogs
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Generate Embeddings in SQL with Aurora and Bedrock
Most embedding pipelines on AWS have the same shape: a job reads rows out...
Resolving SQL Server Transaction Log Issues Efficiently
By Arun Sirpal
Transaction log issues are one of the quietest ways a healthy database turns into...
Forums
Symmetric Key Encryption
Comments posted to this topic are about the item Symmetric Key Encryption
The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Building Your Own Software
Comments posted to this topic are about the item Building Your Own Software
Question of the Day
Symmetric Key Encryption
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers