SQL Server - ICB Consulting, Inc. Kbase

ICB Consulting, Inc. Kbase	Search this site

ICB Consulting Home
Knowledgebase Home
ASP
Crystal Reports
Dynamics CRM
Dynamics GP
HTML/Javascript/CSS
Miscellaneous
PHP
Sharepoint
SQL Server
SQL Reporting Services
VBA
VB.net
VBScripting
Linux
MySQL
Epicor Prophet 21
Sitemap

About ICB Consulting

ICB Consulting, Inc. is a computer consulting company based in Denver, Colorado.

http://www.icbconsulting.com

Colorado

Navigation

SQL Server

Code samples and troubleshooting tips for SQL Server.

Subpage Listing

Convert a datetime field to only show the date portion
Create Linked Server to MYSQL
Create text files from SQL Server data
Delete SQL Backups Older Than A Certain Date
Dropping a table in a SQL Server Stored Procedure
Example of pivot query
Generate a text file and FTP it using a SQL Stored Procedure
How to convert a date/time to midnight
How to create process to backup SQL Express Database
How to manually shrink a sql log file
Query an Access database from SQL Server
Search a SQL database for tables and fields that contain a string
Search SQL database for every table and field that contains a certain number
Send an email with sql code
SQL Function to Strip HTML from a field
SQL Server Administration Topics
- Administering SQL Server Indexes
- Data Collector in SQL Server
- Data compression in a SQL Server database
- Key SQL Server Security Concepts and Pre-Defined Roles
- Managing concurrency in SQL Server
- Managing SQL Server database schemas
- Managing SQL Server database schemas
- Monitor SQL Server locks
- Moving SQL Server database files to a new location
- Overview of high availability and replication options
- Partitioning large tables in SQL Server Enterprise
- Policy based management of SQL Server
- Querying Other Databases From SQL Server
- Resource Governor in SQL Server
- SQL Server Agent
- SQL Server Audit Tools
- SQL Server Browser Service
- SQL Server Bulk Copy Program (BCP)
- SQL Server Data Encryption
- SQL Server Data Import Methods
- SQL Server Database backups
- SQL Server Database Engine Tuning Advisor (DTA)
- SQL Server Database Mail
- SQL Server Database maintenance plans
- SQL Server Database Snapshots
- SQL Server DBCC maintenance commands
- SQL Server error logs
- SQL Server Full Text Indexes
- Starting SQL Server from a command line
- Transparent Data Encryption
- Use DBCC to Clear the Process Cache
- Using SQL Server Dynamic Management Views (DMV)
- Using SQL Server Profiler
- Using the EXECUTE AS statement to overcome security
- Using the FILESTREAM data type in SQL Server 2008
Sql to analyze table sizes in a database
SQL to Determine if A Date Is A Month End Date
SQL to determine number of working days in a month
SSIS Script to move/rename/archive source files
Standard syntax to use a cursor in a stored procedure
Syntax to query a remote linked server
Unable to Connect to SQL Engine using Windows Authentication
Using the EncryptByPassPhrase Function in SQL Server
Using the RAISERROR command in stored procedure

Sign in Recent Site Activity Report Abuse Print PagePowered By Google Sites