PowerShell, the New SQL Hammer
This is my PowerShell presentation that I have given to both Chicago SQL Server User Groups. The name of the...
2011-04-17
979 reads
Blog Posts
SSMS Tips & Tricks – Registered Server Groups
Here are a couple more SSMS tricks I’ve stumbled upon recently. Both involve the functionality of registered servers. If you...
2011-04-17
1,621 reads
Powershell Day 16
Day 16 Introduction to Mini Shell Mini Shell or SqlPS is the default shell utility provided by Microsoft to support...
2011-04-16
400 reads
A SQL Server Hardware Nugget A Day – Day 15
For Day 15 of this series, I am going to talk about Power Management and its effect on processor performance....
2011-04-15
470 reads
Do you work with data? You’ve always got options.
She's ready for the future. Are you?
In preparing for the SQLPeople event, I thought about the role, motivation, and techniques...
2011-04-15
950 reads
Late April Free Training from PASS VCs
PowerShell provisioning of Hyper-V Servers
Designing Cubes for Performance
Database Standards SOP
_____________________________________________________________
PowerShell provisioning of Hyper-V Servers
April 20, 2011, 12 PM EDT (GMT...
2011-04-15
719 reads
Powershell Day 15
Day 15 Introduction to Powershell for MS Sql Server So far we have discussed several features and information about Windows...
2011-04-15
785 reads
Re-Blog – April 8-14
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-04-15
581 reads
SQL Azure
If you’ve talked to anyone from Microsoft recently you had to have heard the phrase “all in.” It’s been made...
2011-04-15
646 reads
The Pro-Active DBA List Updated
A couple of years back, in the heart of the economic tsunami, I proposed a list of pro-active steps to...
2011-04-15
1,383 reads
Blogs
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...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
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