Conversion of a plain English problem into T-SQL
An example of how a mathematical problem was converted into T-SQL by evolving a script in iterations.
Staying High
Today we have a guest editorial from Tim Mitchell. Tim talks about the need to stay motivated in your career after an event ends.
TSQL Challenge 66 - Find the most relevant advertisement based on keyw
A website wants to display most relevant ads on each of its web pages based on the keywords associated with each page.
Running SQL Server with Hyper-V Dynamic Memory
Memory is a critical resource to Microsoft SQL Server workloads, especially in a virtualized environment where resources are shared and contention for shared resources can lead to negative impact on the workload. Windows Server 2008 R2 SP1 introduced Hyper-V Dynamic Memory, which enables virtual machines to make more efficient use of physical memory resources.
SQL Relay, October 2011
A series training in the UK is happening this week. Read more to find out any of the 16 user group meetings can fit into your schedule.
Closing Out Replies
This editorial was originally published on Oct 17, 2006. It is being republished as Steve is at SQLBits 9 today. Should we change the way we deal with posts and replies? Answer today.
Five Things (We Bet) You Didn't Know About Subversion
Thursday, October 13, 2011 11:30am Eastern, 8:30am Pacific
Come and learn The Truth about Migration to and Administration for Apache Subversion. CollabNet, Subversion founder and corporate sponsor, and Red Gate Software, number one in SQL source management using any SCM system, want to share five powerful truths about Subversion that will fortify your decision to leave VSS behind.
Using PowerShell for SQL Server Database Backups
If you're starting to learn PowerShell and want to see how you can use it for common DBA tasks, this tip will show you how to create a basic PowerShell script to backup all your user databases.
Custom SSMS Shortcuts for ETL Developer. Part 3: Source-Target Mapping
Provides a SQL code that generates a source-target transformation query and can be helpful at several stages of data warehouse development lifecycle.
Blogs
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Forums
Adding new column with DEFAULT II
Comments posted to this topic are about the item Adding new column with DEFAULT...
Advanced Deployment Scenarios: Stairway to Reliable Database Deployments Level 7
Comments posted to this topic are about the item Advanced Deployment Scenarios: Stairway to...
You Need a DBA Pipeline
Comments posted to this topic are about the item You Need a DBA Pipeline
Question of the Day
Adding new column with DEFAULT II
Which number did the two COUNT(*) return:
DROP TABLE IF EXISTS #tmp CREATE TABLE #tmp (id INT NOT NULL) INSERT INTO #tmp (id) SELECT gs.value FROM GENERATE_SERIES(1, 5) AS gs ALTER TABLE #tmp ADD my_value INT NOT NULL CONSTRAINT df_tmp_my_value DEFAULT 1 SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1 ALTER TABLE #tmp DROP CONSTRAINT df_tmp_my_value ALTER TABLE #tmp ADD CONSTRAINT df_tmp_my_value DEFAULT 2 FOR my_value SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1See possible answers