Blogs about: Mssql
Featured Blog
Tip of the Day: SQL RANK Statement
About 5 months into my current job, I was asked to come up with a report that ranked scores in order of best to worst. My intial intention was to just order the data by the score and print out a coun… more »
have you any wool?
Running cakePHP on IIS
Mike wrote 3 days ago: I am trying to get cakePHP 1.2 running on IIS6 with a MSSQL backend, and so far it’s going pre … more »
How to connect MSSQL with php
samsami2u wrote 6 days ago: Please follow the steps given below to connect MSSQL with php: 1. Settings related to your php.ini f … more »
The INSERT Statement
gyana wrote 1 week ago: 1. The Basic INSERT Statement It is the most basic statement to insert data into a table. Its syntax … more »
It's been a while
Mike wrote 2 weeks ago: I’ve been working on other things recently so have unfortunately left this blog a little quiet … more »
Connecting MSSQL Server with Zend Framework on Linux
— 2 comments
kunalbharati wrote 2 weeks ago: Few days ago we completed a project which used Zend framework and the database was MS Sql Server 200 … more »
Tip of the Day: SQL RANK Statement
blaksheep wrote 1 month ago: About 5 months into my current job, I was asked to come up with a report that ranked scores in orde … more »
Tip of the Day : SQL Dynamic Variables in Stored Procedure
blaksheep wrote 1 month ago: Writing useful and reusable stored procedures is something I struggled with when first learning SQL. … more »
Tip of the Day : SQL Multiple rows to Comma Separated Column
blaksheep wrote 1 month ago: When working with SQL server and normalized data structures, there are often times when you need to … more »
Tip of the Day : SQL Union vs Union All
blaksheep wrote 2 months ago: This is another one that I revisist every so often with some of the guys at work. If you have data i … more »
Tip of the Day : SQL Table Variables
— 1 comment
blaksheep wrote 2 months ago: Many times you need to create and use a table temporarily in SQL query or Stored Procedure and then … more »
Tip of the Day : SQL Update from Joined Table
— 1 comment
blaksheep wrote 2 months ago: Updating a table with values from a Joined table. I run into this question from the guys at work qui … more »
You always learn from your mistakes; SharePoint database woes.
slinger wrote 2 months ago: Ran into a very interesting issue about two weeks ago. The hard drive that our MOSS portal is on g … more »
Getting the last updated Seed value!
— 1 comment
azimyasin wrote 2 months ago: While i was doing work on the FYP! I encountered a problem fetching out data from the mssql DB! Here … more »
Database Mirroring without Witness
— 3 comments
bondbhai4u wrote 2 months ago: Hi all, this is my first step into the world of blogging so please bear with me… In this post, … more »
SQL Server Database Publishing Wizard
woaychee wrote 2 months ago: I m just tried out this tool, it can generate entire database (including SP, View and table etc) w … more »
Other SQL optimization tips
— 2 comments
rip747 wrote 3 months ago: Ben started a whirl wind of ideas with his recent post about optimizing SQL queries for better perfo … more »
CMS: Asp.net versus PHP
mtatem wrote 3 months ago: I have asked alot of people their opinions on this subject. Basically asp.net versus php in the Cont … more »
MS SQL Server with Linux
vspike wrote 3 months ago: I was wondering if this is possible, and it seems that it is. I am using Ubuntu 7.10. First I inst … more »
Insert multiple row to MSSQL
— 2 comments
koercoe wrote 4 months ago: Bingung…bingung. Sudah dua hari ini mentok bikin script buat nge ‘DUMP’ data ke SQ … more »
