Coming from a SQL Server, and PHP background, I often get asked, does SQL Server work with PHP? The answer is YES. I have been using SQL Server and PHP together in a high availability load balanced environment with multiple data centers for the last 4 years. Microsoft offers drivers that plug into PHP to allow the connectivity. You get support …
For the .NET programmer, Visual Basic programmer or PHP programmer, if you are accessing a SQL Server database there are some things you should know to performance tune your queries. Learn how to improve query performance with Indexes, how to properly use parameterized queries, using the query analyzer, and avoiding common SQL Server performance pitfalls. This presentation is a lot …
This week I will be attending and speaking at Vancouver DevTeach. This event taking place on December 2nd to 4th 2013 at the Vancouver Sheraton Wall Center Hotel. Monday and Tuesday I have morning presentations which leaves the rest of the day to attend a few other sessions. Here are the sessions that I will be presenting. Monday: Using FILESTREAM and …
The two sessions I will be presenting at DevTeach in Vancouver BC will be the following: Using FILESTREAM and FILETABLES in SQL Server – Configuring and Using FILESTREAM and FILETABLES in SQL Server Developers love to use SQL Server to store files, but this causes headaches for the DBA, finally a reasonable solution for file storage in SQL Server FILETABLES …
Working on my sessions for DevTeach in Vancouver in December. Read more »
Today I learned that two of the sessions that I proposed for Vancouver DevTeach were accepted. This event taking place on December 2nd to 4th 2013 at the Vancouver Sheraton Wall Center Hotel. It will have 3 full days of main conference (Dec. 2-4). Don’t miss this Vancouver DevCon! The first session: Using FILESTREAM and FILETABLES in SQL Server Steve Stedman …
Technical Debt is a programming concept that is also known as code debt. The concept of Technical Debt applies closely with Agile software development, but also applies to database development. There are many tools available to report on technical debt for C#, PHP or other programming languages, but there isn’t much available to manage the SQL Server or T-SQL technical …
Its about time, MySQL has had a feature LIMIT which is similar to the usage of OFFSET and FETCH for years. Now in SQL Server 2012 Microsoft introduces OFFSET and FETCH. The OFFSET and FETCH functionality is used to achieve data paging server side in TSQL. Thing of a page like your typical search results where you are shown the …
The Microsoft SQL Server ODBC Driver for Linux provides native connectivity from Linux to Microsoft SQL Server. Just released 11/21/2011 – Linux ODBC driver for SQL server. http://www.microsoft.com/download/en/details.aspx?id=28160 Hopes: I hope this is better than the original SQL Server driver for PHP. I hope this driver will work on other Linux distributions besides Red Hat.