Estimating Priorities
Steve Jones is more willing to ask for changes in software than the real world. Is that a good thing or not? Read on to find out.
2009-07-23
425 reads
Articles
Estimating Priorities
Steve Jones is more willing to ask for changes in software than the real world. Is that a good thing or not? Read on to find out.
2009-07-23
523 reads
Estimating Priorities
Steve Jones is more willing to ask for changes in software than the real world. Is that a good thing or not? Read on to find out.
2009-07-23
461 reads
XML Workshop 24 - Modifying XML Documents Using XQuery Part 1
This next few installments of this series from MVP Jacob Sebastian will deal with how to modify XML documents. Part 1 looks at XQUERY.
2009-07-22
6,779 reads
Building a Data Foundation for a BI Solution
August 2009
Business Intelligence: Planning Your First Microsoft BI Solution
Even BI novices can learn what goes into creating a BI solution, from planning and designing a data mart to preparing data. An Adventure Works example illustrates the first steps a company can take to ensure that its BI solution supports the strategic decisions it needs to make. Stacia Misner
Business Intelligence: Building a Data Foundation for a BI Solution
See how you can design and build a data mart that uses SQL Server 2008 Integration Services to perform the extract, transform and load (ETL) processes for the Adventure Works BI solution introduced in "Planning Your First Microsoft BI Solution." Derek Comingore
2009-07-22
2,055 reads
I Want a Database
Gordon Bell works for Microsoft Research and always asks Steve Ballmer for a database. What's wrong with SQL Server?
2009-07-22
441 reads
I Want a Database
Gordon Bell works for Microsoft Research and always asks Steve Ballmer for a database. What's wrong with SQL Server?
2009-07-22
449 reads
I Want a Database
Gordon Bell works for Microsoft Research and always asks Steve Ballmer for a database. What's wrong with SQL Server?
2009-07-22
689 reads
Using SQL Server Data Mining Add-Ins for Office 2007 to Predict Database Growth Trends - Part 2
I want to show you another easier way to pull information to help predict database growth again using the Data Mining Tools.
2009-07-22
2,359 reads
Foreign Keys, Part 1 - SQL School Video
Understanding referential integrity is important for anyone working with databases. It can help you design better forming systems. Learn the basics of foreign keys in this SQL School video.
2009-07-21
8,646 reads
Blogs
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
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...
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