Posts

Showing posts from October, 2009

PowerBuilder Q & A

PowerBuilder Q & A N41 by Nouvolution

Backup SQL Server Databases with a Windows PowerShell Script - PF

Backup SQL Server Databases with a Windows PowerShell Script - PF N41 by Nouvolution

Download details: Microsoft SQL Server 2008 Express with Tools

Download details: Microsoft SQL Server 2008 Express with Tools N41 by Nouvolution

Download details: Microsoft SQL Server 2008 Management Studio Express

Download details: Microsoft SQL Server 2008 Management Studio Express N41 by Nouvolution

Download details: XML Notepad 2007

Download details: XML Notepad 2007 N41 by Nouvolution

SQL Server Date function that determines date range based on weekday - PF

SQL Server Date function that determines date range based on weekday - PF N41 by Nouvolution

SQL Server Unique Constraints for Large Text Columns - PF

SQL Server Unique Constraints for Large Text Columns - PF N41 by Nouvolution

GS1 US BarCodes and eCom - The Global Language of Business

GS1 US BarCodes and eCom - The Global Language of Business N41 by Nouvolution

Streamlining SQL Server Documentation - PF

Streamlining SQL Server Documentation - PF N41 by Nouvolution

Index Usage Report in SQL Server - PF

Index Usage Report in SQL Server - PF N41 by Nouvolution

Configuring SQL Agent Jobs to Write to Windows Event Log - PF

Configuring SQL Agent Jobs to Write to Windows Event Log - PF N41 by Nouvolution

SQL Server 2005 tablediff command line utility - PF

SQL Server 2005 tablediff command line utility - PF N41 by Nouvolution

SQL Server Configuration - The Basics

SQL Server Configuration - The Basics N41 by Nouvolution

Process Explorer

Process Explorer N41 by Nouvolution

You cannot delete a file or a folder on an NTFS file system volume

You cannot delete a file or a folder on an NTFS file system volume N41 by Nouvolution

Configuring SQL Agent Jobs to Write to Windows Event Log - PF

Configuring SQL Agent Jobs to Write to Windows Event Log - PF N41 by Nouvolution

T-SQL Debugger is back in SQL Server 2008 ... debugging now made easy - PF

T-SQL Debugger is back in SQL Server 2008 ... debugging now made easy - PF N41 by Nouvolution

SQL - Kill Active connections

Simply Run the script in current database. DECLARE @p_SPID int, @p_SQL nvarchar(2000),@dbName nvarchar(100) SET @dbName = DB_NAME() DECLARE #cur_Processes CURSOR FOR     SELECT p.SPID FROM master.dbo.sysprocesses AS p JOIN master.dbo.sysdatabases AS d ON( d.dbid = p.dbid )     WHERE d.Name = @dbName AND p.SPID > 50     -- AND spid >= 51 (because spids of 50 or less are reserved for internal use.) OPEN #cur_Processes FETCH NEXT FROM #cur_Processes INTO @p_SPID WHILE @@FETCH_STATUS = 0 BEGIN     SET @p_SQL = 'KILL ' + CONVERT( nvarchar(30), @p_SPID )         PRINT @p_SQL         EXECUTE( @p_SQL )     FETCH NEXT FROM #cur_Processes INTO @p_SPID END CLOSE #cur_Processes DEALLOCATE #cur_Processes

Script to determine SQL Server Reporting Services parameters, path and default values - PF

Script to determine SQL Server Reporting Services parameters, path and default values - PF

Introduction to SQL Server 2008 Report Builder 2.0 - PF

Introduction to SQL Server 2008 Report Builder 2.0 - PF

Microsoft Access Pass-Through Queries to SQL Server - PF

Microsoft Access Pass-Through Queries to SQL Server - PF

Managing SQL Server Database Fragmentation - PF

Managing SQL Server Database Fragmentation - PF

Using the Built-In Time Dimension and Time Intelligence in SQL Server Analysis - PF

Using the Built-In Time Dimension and Time Intelligence in SQL Server Analysis - PF

SQL Server Monitoring Scripts with the DMVs - PF

SQL Server Monitoring Scripts with the DMVs - PF

Exchange - DNS, Reverse DNS and MX Records | Amset.info

Exchange - DNS, Reverse DNS and MX Records | Amset.info

Microsoft Exchange Server 2007 - create mailbox

Microsoft Exchange Server 2007 - create mailbox

Index Usage Report in SQL Server - PF

Index Usage Report in SQL Server - PF

Rounding Functions in SQL Server - PF

Rounding Functions in SQL Server - PF

Solid State Disk Drive Considerations for SQL Server - PF

Solid State Disk Drive Considerations for SQL Server - PF

How to identify when a database was restored, the source of the backup and the date of the backup - PF

How to identify when a database was restored, the source of the backup and the date of the backup - PF

How to Dynamically and Iteratively Populate An Excel Workbook from SQL Server - SQLServerCentral

How to Dynamically and Iteratively Populate An Excel Workbook from SQL Server - SQLServerCentral

How to Backup and Restore a SQL Server FILESTREAM Enabled Database - PF

How to Backup and Restore a SQL Server FILESTREAM Enabled Database - PF

Poor Man's Enterprise Feature - Lock Pages in Memory

Poor Man's Enterprise Feature - Lock Pages in Memory

Export data from SQL Server to Excel - PF

Export data from SQL Server to Excel - PF

Getting your IP whitelisted with Yahoo (solving the deferred 451 problem) - Forums & Blog

Getting your IP whitelisted with Yahoo (solving the deferred 451 problem) - Forums & Blog

Date/Time Conversions Using SQL Server - PF

Date/Time Conversions Using SQL Server - PF

How to identify when a database was restored, the source of the backup and the date of the backup - PF

How to identify when a database was restored, the source of the backup and the date of the backup - PF

How to identify when a database was restored, the source of the backup and the date of the backup - PF

How to identify when a database was restored, the source of the backup and the date of the backup - PF

Whitelisting MS Outlook

Whitelisting MS Outlook

Boot INI Options Reference

Introduction There are number of BOOT.INI switches that are useful for driver developers that wish to test their drivers under a variety of different system configurations without having to have a separate machine for every one. For example, limiting the amount of memory NT sees can be useful for stressing memory loads, and limiting the number of processors for testing scalability. I've compiled a complete list of the options that BOOT.INI currently supports. This list is reproduced in the Startup, Shutdown and Crashes chapter of Windows Internals, where you'll find more information about the boot process. Note: to see what options a system has booted with examine HKLM\System\CurrentControlSet\ Control\SystemStartOptions. /3GB Increases the size of the user process address space from 2 GB to 3 GB (and therefore reduces the size of system space from 2 GB to 1 GB). Giving virtual-memory- intensive applications such as database servers a larger address space can improve their perf...

Open DBDiff for SQL Server 2008 — DatabaseJournal.com

Open DBDiff for SQL Server 2008 — DatabaseJournal.com N41 by Nouvolution

indonchung - Nouvolution Newsletter

indonchung - Nouvolution Newsletter N41 by Nouvolution

Unable to reconcile accounts or to create, print, or email PDF files

Unable to reconcile accounts or to create, print, or email PDF files N41 by Nouvolution

Symantec Email Proxy error

Question: Hello, When I try to send e-mail in Microsoft Outlook I get an error message from Symantec Email Proxy: "Your email message to (e-mail address) with the subject of ( subject of email) was unable to be sent because the connection to your mail server was interrupted. Please open your email client and re-send the message from Sent messages folder." Thanks.     Solution : Hi, I got this from the Symantec site Unfortunately no link on that page. So pasting the lot. Your email message to with the subject was unable to be sent . . ." (1003,9) Situation: This page tells you what to do when you see the message "Your email message to with the subject was unable to be sent because the connection to your mail server was interrupted. Please open your email client and re-send the message from the Sent Messages folder." (1003,9). Solution: When do you see this message? I only see the message when I send email I only...

Rebuilding the SQL Server master database - Part 2

Rebuilding the SQL Server master database - Part 2 N41 by Nouvolution

Creating a SQL Server 2008 FILESTREAM Enabled Database and Using INSERT, UPDATE and DELETE statements to manage FILESTREAM Data - PF

Creating a SQL Server 2008 FILESTREAM Enabled Database and Using INSERT, UPDATE and DELETE statements to manage FILESTREAM Data - PF N41 by Nouvolution

Rounding Functions in SQL Server - PF

Rounding Functions in SQL Server - PF N41 by Nouvolution

SQL Server Service Broker example on how to configure, send and receive messages - PF

SQL Server Service Broker example on how to configure, send and receive messages - PF N41 by Nouvolution

How To Configure SQL Server Reporting Services 2005 to Run in SharePoint Integrated Mode - PF

How To Configure SQL Server Reporting Services 2005 to Run in SharePoint Integrated Mode - PF Problem We have heard about running SQL Server Reporting Services in SharePoint Integrated Mode but are not really sure how to go about configuring this. Can you provide the details on what capabilities this provides as well as how to do it? Solution Probably the biggest benefit of running Reporting Services in SharePoint Integrated Mode is that you can deploy and manage reports directly in SharePoint rather than the Report Manager web application. This is probably easier for our business users. As a matter of fact you no longer use the Report Manager after you switch to SharePoint Integrated Mode. The highlights of the capabilities provided by SharePoint Integrated Mode are the following: A Report Viewer Web Part that provides report viewing capability, export to other rendering formats, page navigation, search, print and zoom. Web application pages so that you can create subscriptions and sc...

Script to check SQL Server connection pooling

Script to check SQL Server connection pooling N41 by Nouvolution

ntwdblib.dll download

ntwdblib.dll download N41 by Nouvolution

Troubleshooting Slow SQL Server Replication issue due to Distributor Database Growth

Troubleshooting Slow SQL Server Replication issue due to Distributor Database Growth N41 by Nouvolution

Microsoft Access and SQL Server Integration - PF

Microsoft Access and SQL Server Integration - PF N41 by Nouvolution

Sending email from SQL Server Integration Services (SSIS)

Sending email from SQL Server Integration Services (SSIS) N41 by Nouvolution

Disable Triggers in SQL Server 2005

Disable Triggers in SQL Server 2005 N41 by Nouvolution

How to isolate the current running commands in SQL Server

How to isolate the current running commands in SQL Server

5.1.2 - Bad destination host 'DNS Hard Error looking up

This is a pretty straightforward error indicating that there was an MX lookup error. What is the rest of the error message (include the specific domain, not a placeholder)? Have you checked the DNS for your domain to make sure all is well? Do a DNSreport here: http://www.dnsstuff.com/ What are you using for a spam filter? Some spam relay services can cause this issue.

Configuring Roaming User Profiles: Group Policy

Configuring Roaming User Profiles: Group Policy

Easy Access and Storage Part of N41's New Look - Special Reports - Features - Apparelnews.net

Easy Access and Storage Part of N41's New Look - Special Reports - Features - Apparelnews.net N41 by Nouvolution

Nouvolution: New Player on the ERP Front - Columns - Features - Apparelnews.net

Nouvolution: New Player on the ERP Front - Columns - Features - Apparelnews.net

Roaming user profile - Wikipedia, the free encyclopedia

Roaming user profile - Wikipedia, the free encyclopedia N41 by Nouvolution

Folder redirection - Wikipedia, the free encyclopedia

Folder redirection - Wikipedia, the free encyclopedia

Resetting Windows Roaming Profile

Find a spare machine and reboot it. Select the "Refresh" option when the Rembo menu comes up. Continue to the next step, making sure nobody else uses that machine while you're working on everything else. If you are logged into *more than one* machine, log out of *all except one* of them; otherwise, log in on a spare machine in the lab (leave the other one refreshing). You must only be logged into one machine for this to work. Double click on "My Computer" and double click on your home drive "H:". Right click on the H: drive window. Select "New", then "Text Document". Change the text "New Text Document.txt" to "REMOVE_MY_PROFILE.txt". - If you are not given an option to do this immediately, right click on the file and select "Rename". It will highlight the filename and you can replace the name with "REMOVE_MY_PROFILE.txt" (sans the quotation marks, of course). Reboot this system via the option ...

Managing your Roaming Profile

What is a profile? A Microsoft Windows User Profile describes the Windows configuration for a specific user, including the user's environment and preference settings. For example, those settings and configuration options specific to the user - such as installed applications, desktop icons, colour options, etc. - are contained in a User Profile. A profile also stores data like your email settings, shortcuts and/or files on your Desktop, files cached by Internet Explorer, custom screen backgrounds that you use, some application settings, drive mappings that you want reconnected every time you log-on, and so forth. What is a roaming profile? A roaming profile is a profile stored on a network share (as opposed to on the local machine) which can thus be accessed from any computer. A user who has a roaming profile can log on to any computer for which that profile is valid and access that profile. Roaming user profiles provide the user with a consistent working environment from machine to...