Getting Started with the Modern.ie VMs on VirtualBox with IIS Express
Microsoft has made pre-packaged Virtual Machine images available for purposes of testing different versions of IE via the modern.ie web...
2014-05-22
2,372 reads
From Zero to Pull Request with Git on Windows
I wrote a guide about using Git and GitHub for "Windows people".
This is the guide I wish was available when...
2014-04-22 (first published: 2014-04-16)
1,673 reads
Rounding versus truncating
Be careful when implicitly converting data types in T-SQL. Directly assigning 1.5 (either as a FLOAT or a NUMERIC) to...
2014-04-15
1,040 reads
Query to Find "Update" Dependencies on a Table or View (SQL Server 2012)
The built-in dependency finder in SQL Server Management Studio does not provide the ability to distinguish between dependencies that are...
2013-07-23
2,839 reads
How To Make Your DLL Into A NuGet Package for a Private NuGet Feed
This is my reinterpretation of the documentation on NuGet.org, modified to remove the public publishing steps, and to add local...
2013-06-05
25,112 reads
Performing an INSERT from a PowerShell script
This code demonstrates how to do an INSERT into SQL Server from a PowerShell script using an ADO.NET command object...
2013-05-24
85,622 reads
Setting up an Internal Friendly URL
Note: This solution is not necessarily the best or most efficient solution in all cases. It is, however, very simple...
2013-02-27
3,291 reads
Using SkyDrive at Work for Collaboration - A Quick Start Guide
It seems that many of my projects in the past year or so have required sharing files with external business...
2013-02-06
1,144 reads
Using Inline “With” Blocks to Augment a VB.NET Default Constructor
Say you have a simple data transfer class that looks like this:
Public Class Employee
Public Property Name As String
Public...
2013-02-02
1,140 reads
IIS Express Quickie Command-line
This is a reminder to my future self for how to quickly start IIS Express from the command-line on 64-bit...
2012-11-24
3,370 reads
Blogs
The Evolution of Data: From Databases to Spark to Lakebases
By Daniel Janik
The circle cylinder of life Maybe you’ve noticed all the twenty somethings tight rolling...
Why Microsoft Fabric Signals the Next Wave of Data Strategy
By Chris Yates
In today’s data-driven economy, organizations are no longer asking if they should invest in...
PostgreSQL Timeline: History and Evolution
By Rohit Garg
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Disaster Recovery for Azure SQL
I am creating a Disaster Recovery plan for Below Data pipeline. I need to...
An Introduction To Database Diagrams
Comments posted to this topic are about the item An Introduction To Database Diagrams
Question of the Day
The Updated Columns List
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers