Reblog: November 21 to November 27
Photo credit – Jenn and Tony Bot
Sometimes old stuff is just as cool as new stuff. Over the past few years,...
2014-11-28
1,024 reads
Blog Posts
Setting up WebStorm to debug grunt with TypeScript
It’s possible to use the WebStorm editor to debug grunt tasks if you are using TypeScript and generating .map files. ...
2014-11-28
1,646 reads
Virtualization Virtual Chapter Webinar – Open Q&A
On December 10 at 11am CST I will be presenting the next PASSVirtualization Virtual Chapter monthly webinar, where you can ask...
2014-11-28
939 reads
Beware the defaults! (in windowing functions) – The Movie!
I was recently contacted by the fine gents of Webucator, an online training services provider. In order to promote their...
2014-11-27
1,068 reads
In-memory OLTP Part 1: Introduction to In-memory OLTP
SQL Server 2014 introduced probably one of the biggest changes to the SQL Server engine since years, “In-memory OLTP” (or...
2014-11-27 (first published: 2014-11-21)
8,408 reads
Parameterization Part 6: Simple vs. Forced Parameterization
This is the sixth post in the “Parameterization” series. In the previous posts I explained what parameterization is, how plan...
2014-11-27
7,523 reads
Use -eq in Powershell
I was writing a quick script to work with files and I only wanted to process one file for each...
2014-11-27 (first published: 2014-11-17)
6,039 reads
Audit Database File Size Changes
Recently I shared an article on how to track the growths and shrinks that occur within database files. I shared...
2014-11-26
2,576 reads
Audit Database File Size Changes
If you just so happen to be running on SQL Server 2012 or later, you will need to change your event sessions that were tracking file changes. It is...
2014-11-26
14 reads
Exam Prep 70-463: More about Dimensions
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2014-11-26 (first published: 2014-11-20)
7,023 reads
Blogs
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Who’s the Winningest Coach (with AI Help)
By Steve Jones
I was listening to the radio the other day and the hosts were discussing...
Learning from Mistakes: T-SQL Tuesday #194
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
Forums
Azure-SSIS, Self-Hosted Integration Runtime, & Data Gateway?
Looking to confirm my understanding of these three products and how they can be...
Basic Always On Groups Randomly Stop Synchronizing
In one of my environments I have 3 pairs of Always On SQL 2022...
Learning From Breakage
Comments posted to this topic are about the item Learning From Breakage
Question of the Day
Adding and Dropping Columns I
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GOI decide to add two new columns for the StateProvince and Country. What code should I use? See possible answers