TSQL OUTPUT Clause on Insert Statements
One of the often overlooked features of SQL Server is the OUTPUT clause, which applies to INSERT, UPDATE, DELETE, and MERGE statements. In this post… Read More »TSQL OUTPUT Clause on Insert Statements
SQL Server
Does SQL Server work with PHP
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… Read More »Does SQL Server work with PHP
My SQL Server is Out Of Disk Space
As the DBA, you get a call from the IT Team who monitors disk space and they tell you the following: “One of our server… Read More »My SQL Server is Out Of Disk Space
SQL Forensics
If you owned a convenience store, or other business that was likely to get robbed you would likely have surveillance cameras with the intention of… Read More »SQL Forensics
SQL Server 2014 Compatibility Level
With SQL Server 2014, there was a new compatibility level introduced, level 120 the new SQL Server 2014 Compatibility Level. SQL Server can run in a… Read More »SQL Server 2014 Compatibility Level
Database Health Monitor – Beta 8 – Soft launch
Today I launched Database Health Reports Beta 8 as a soft launch. What I mean by the soft launch is that other than updating the… Read More »Database Health Monitor – Beta 8 – Soft launch
SQL Server Performance for Developers
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… Read More »SQL Server Performance for Developers
SQL Server FILESTREAM and FileTables
Monday: 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,… Read More »SQL Server FILESTREAM and FileTables
Speaking at Vancouver DevTeach this week.
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… Read More »Speaking at Vancouver DevTeach this week.
Introduction to CTEs Slides and Sample Queries
Today I am at SQL Saturday Portland Oregon, and at 9:00am I am presenting the Introduction To Common Table Expressions session: Here is the abstract:… Read More »Introduction to CTEs Slides and Sample Queries