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,371 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,672 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,039 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,835 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,052 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,493 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,290 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,137 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,364 reads
Blogs
KDA: Echoes of Deception - Onboarding
By Zikato
I’ll walk through the KDA UI and tackle the first challenge before diving into...
Kusto Detective Agency - Intro
By Zikato
While I mostly write about SQL Server, I have a soft spot for Kusto....
The Book of Redgate: Customer Quotes
By Steve Jones
Many organizations list customer testimonials and quotes on their websites or literature. It makes...
Forums
How to take a backup as a .bak file while omitting some tables?
Hi Guys, I'm not sure if this is possible or not, but let me...
Life Moves Pretty Fast
Comments posted to this topic are about the item Life Moves Pretty Fast
Parse XML data from SQL table using temp tables and variables
Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL...
Question of the Day
Multiple Collations
Can I have a collation expression like this in SQL Server 2022?
... WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS ...See possible answers