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,373 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,674 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,041 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,848 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,127 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,697 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,292 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,146 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,142 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,376 reads
Blogs
Local LLM Models at SQL Saturday Boston 2025
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
3 things you must do to start data quality management right
As a data & AI strategist who’s seen countless projects succeed and fail, I...
Set Theory vs. Batch Mode in SQL Server
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Forums
Changing the Recovery Time
Comments posted to this topic are about the item Changing the Recovery Time
Getting More Time from AI
Comments posted to this topic are about the item Getting More Time from AI
When Page Prefetching Takes a Back Seat – Exploring Trace Flag 652 in SQL Server
Comments posted to this topic are about the item When Page Prefetching Takes a...
Question of the Day
Changing the Recovery Time
I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?
ALTER DATABASE Finance SET TARGET_RECOVERY_TIME = 12 xxx;See possible answers