Sql-Server

Create a Basic SQL Server 2005 Trigger to Send E-mail Alerts
Feb 5, 2008 · 2 min read ·
Share on:
For as many times as I have read about sending e-mails using SQL Server triggers, I've rarely come across actual code samples. After someone asked for a "Triggers for Dummies" example in a Facebook SQL group, I created the following example which uses a trigger to alert a manager that an expensive item has …
Read More
FIX: SQL Server System Configuration Checker cannot be executed due to WMI configuration (Error:2147500034)
Jan 8, 2008 · 2 min read ·
Share on:
I don't know what on Earth AOL developers do in their AIM 6.x setup but they sure manage to mess things up in Vista. Once AIM is installed, my network detection no longer works and it gives an error that reads: "No network - server execution failed." The problem seems to be some kind of COM error and the fix …
Read More
SQL Server DTS: Dynamically Change Source and Destination in Transform Data Task
Aug 24, 2007 · 3 min read ·
Share on:
I really wish I had more experience with DTS and SSIS (Replication, Clustering, Hardcore HA too), especially since I've been a DBA for 8 years. I bought the Wrox book "Professional SQL Server 2000 DTS" years ago hoping that one day I'd be making 50-step DTS packages but I never had the need. Today, I finished …
Read More
DBAs: What Do You Do When Major Installations Require Sysadmin Access?
Aug 17, 2007 · 2 min read ·
Share on:
This is driving me absolutely crazy. For the 80th time, I'm required to create a user and give it the sysadmin role. I *have* to do this because the software is business critical (Blackberry Enterprise Server, Interwoven DMS) and installs will fail without it. With some software, I can temporarily grant access the take …
Read More
Do My SQL Statements Conform to the SQL Standard?
Jul 10, 2007 · 1 min read ·
Share on:
While researching for a paper I have to write in class about hierarchical data in relational databases, I was reading Joe Celko's book Trees and Hierarchies in SQL for Smarties. In the intro, he mentions a really useful website for validating SQL-92, SQL-99 and SQL-2003. The site is nice enough but could really benefit …
Read More
T-SQL Equivalent of VBScript's FormatDateTime Function
Jul 3, 2007 · 2 min read ·
Share on:
Looking for the T-SQL (somewhat) equivalent to VBScript's FormatDateTime function? I've been too, for years. I finally found it within the CONVERT() function. As stated in SQL Server Books Online:
In CONVERT ( data_type [ ( length ) ] , expression [ , style ] ), style is the style of the date format used to convert …

Read More
T-SQL: Convert Seconds to Datetime / Get Total Seconds from Datetime Field
Jul 3, 2007 · 2 min read ·
Share on:
For my final project in my database class at USF, I chose to create a database for a small record label looking to sell albums online as well as provide artist bios, tour information and news. The database, which was scaled down version of a project I worked on in the past, looked something like this: …
Read More
VBScript: Forward SQL Server Alerts/Windows Events to (Cingular) SMS
May 11, 2007 · 3 min read ·
Share on:
Someone recently asked why I don't use SQL Mail on my SQL Servers (2000 and below). The answer is: I don't want to install Outlook on my SQL Servers. Sure, there are ways around it but I prefer just using "net send" to alert the Operator (moi) then forwarding those messages on to my inbox and phone.
Although …

Read More
MSSQL: Parse Search Engine Querystrings for Search Terms
Feb 22, 2007 · 7 min read ·
Share on:
As a compliment to my MaxMind GeoIP Locator scripts and the parse top-level domain from URL function, I've created another function to parse the search term from an URL.
I've heard that T-SQL is a bit slow with parsing strings and wanted to test this myself so I created this in both C# and T-SQL. The difference is very …

Read More
SQL Server 2005: SP2 Now Available for Download
Feb 21, 2007 · 1 min read ·
Share on:
You can now download SQL Server 2005 SP2 on Microsoft's website. Here's hoping that the install issues in SP1 won't plague SP2 as well!
Read More
- 9
- 10
- 11
- 12
- 13